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 :)
bLuEmEzzy
0
Junior Poster in Training
Recommended Answers
Jump to PostPlease explain your requirement clearly..
All 4 Replies
Pgmer
50
Master Poster
Featured Poster
Please explain your requirement clearly..
bLuEmEzzy
0
Junior Poster in Training
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
50
Master Poster
Featured Poster
Look at this link it may help you in understanding the SPLIT function in sql
bLuEmEzzy
0
Junior Poster in Training
Thank u :) I will study it..
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.