Wednesday, 25 September 2013

How can I write this T-SQL cursor?

How can I write this T-SQL cursor?

I have multiple values in one cell in a table which are separated by an
space from each other. this is somehow how my table looks like, there is a
space in between each string in every cell:
column1 column2
abc fgt rty lkj
I want to create another table based on the first table in which "abc" and
"rty" are in one row because they both are located in the first place,
"fgt" and "lkj" are in another row for the same relational reason (they
are in the 2nd place and so on):
column1 column2
abc rty
fgt lkj
How can I do that?

No comments:

Post a Comment