Parsing range values to comma separated array of values in insert trigger?

I'd recommend these numbers should really be stored in a separate table e.g. Range (start int, end int) with a many-1 link to the table your referring to which should make queries like this much simpler and save you other potential headaches, but maybe you have good reason for doing it this way. In which case I would suggest creating a UDF to generate the CSV string and declaring the field as a computed column referencing the UDF. Be aware of potential performance issues though if this is a heavily used or frequently updated table.

First you need to create a Table Valued function which takes start and end value to generate the sequence. This is done using recursive cte.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions