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 |
|
jodyford
Starting Member
4 Posts |
 Posted - 2001-03-28 : 10:47:25
|
| I need help on code that will accomplish the following:a stored proc that accepts three parameter (primary, secondary, myuser). These parameters are strings seperated by commas (1,2,3) except for the "myuser."The strings needed to be parsed so that that contents are inserted into the primary and secondary table. Example:sp_myproc, "Denver, Chicago", "New York, California", myuserproduces:insert into primary "Denver" where uid=myuserinsert into primary "Chicago" where uid=myuserinsert into secondary "New York" where uid=myuserinsert into secondary "California" where uid=myuser.There can be a random number of values in the string -except for myuserThanks for the help. I know the example does not produce the correct code but I was going for brevity over accuracy in hopes that the audiance would understand where I was trying to go.thanks in advance! |
|
|
|
|
|
parsing a string