Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
 Posted - 2010-03-18 : 10:56:19
|
| Hello,i have a list of checkboxes in a .net page, totalling over 60 for a questionaire.However when passed to my SP, i pass them as a csv format. Which is then parsed by an inbuilt split function. Whats the best way to put them into the table ??? Am confused, as each checkbox has its own column. NOTE: In a similar approach, i ran a loop, but this doesnt require a loop. Its sort of like thisinsert into mytable ( assesment1, assement2, assement3 etc) select (from the split function )....whats the best approach on this ?thanksEhi |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-03-18 : 12:45:43
|
| if you're storing them in different columns probably its best csv and then do split and pivot to get them onto different column------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Arrays in SQL - Best approach