|
-
Column to Rows
Hey,
I M stuck with a problem. Here it is as :
I have a table called Temp which has somem columns.Now one column hav differnt value but comma separated.For ex:
Temp Name TempLocation
test abc,xyz,lmn
Now I need to resolve this one record into multiple records based on differnt
Values in "TempLocation"
So that I should get 3 records with same TampName but Differnt TempLocation.
Please tell me how can I do it ???
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|