question

sivatoms avatar image
sivatoms asked

want a stored procedure for comma seperated string column with more than 20000 rows in a table

Hi ALL I Have a column in a table with comma seperated strings on each row of one column like that i have more than 20000 rows . i want to spilt that string on each row and put them in a new table row by row each individual string without duplicates. for this i want to create a stored procedure to pass table name and column(which contains comma seperated strings on each row) as parameters Can anyone help me??
stored procedures
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image ThomasRushton ♦♦ commented ·
I've used Jeff Moden's 8k Splitter routine from the main SQLServerCentral board to do similar; that was processing over 2M rows. See http://www.sqlservercentral.com/articles/Tally+Table/72993/ for more about the split function.
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.