split using stored procedure

[bLuEmEzzy]

please help me, i want to split records using stored procedure
Record1 = 1,2,3,4,5,6
I want to split record1 values and insert in the table but different rows... please guide me... thank you :)

[Pgmer]

Please explain your requirement clearly..

[bLuEmEzzy]

oh hi... i have a parameter @Record1. A stored procedure uspSplitSample and a table Table1...
@Record1 = 1,2,3,4,5,6
i want to split(',') @Record1 and insert it on Table1... Thank you... hope u understand it...

[Pgmer]

http://www.logiclabz.com/sql-server/split-function-in-sql-server-to-break-comma-separated-strings-into-table.aspx

Look at this link it may help you in understanding the SPLIT function in sql

[bLuEmEzzy]

Thank u :) I will study it..