I have to deal with an older database. In this database no relation was used, instead the references have been stored as a comma separated list :-(
Now I need to execute a statement like this
My problem is, that 1,2,3 is a value stored in one row of another table
So how to combine this in SQL? My naive approach
results in: convert 1,2,3 to numeric not possible.
asked 04 Oct '10, 10:05
If you are on V10+, you can use sa_split_list() system procedure to break comma-separated list into individual items, like this:
answered 04 Oct '10, 10:27