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 |
|
smccreadie
Aged Yak Warrior
505 Posts |
 Posted - 2001-10-02 : 11:35:44
|
| I'm sure this isn't too hard, but my brain isn't working today.On an asp page, I've got a bunch of checkboxes that display a list of choices (same field). When I check a few of them and do a Request.Form("varname"), I get a comma-delimited list (CHC, DRP, MC, MW3).I want to pass this into a SPROC (no problem) and do an insert on a table.How do I construct an insert statement to take these values and put them into a table? The above example should generate 4 rows. |
|
|
|
|
|
inserting into table from a comma-delimited string