I have the following select statement:
SELECT the_items from ItemTable
result: item1,item2,item3,item4,item5
I want to place those items into a NEW item table(uniqueidentifier ID, varchar(20) TheItem):
123456 || item1
987655 || item2
765498 || item3
etc.....
Anybody have a nice easy query to do that????
thanks..
View Complete Post