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 |
|
sqldbaa
Starting Member
32 Posts |
 Posted - 2008-06-20 : 07:16:46
|
| HiPlease help meI have to create a SP.The secenario is that, A application calls the SP with a parameter(login), and a string of datas ( Acctid level1 level2; Acctid level1 level2; .......)UserID AcctID Level1 level2test testee N Ythe SP have to get the first string of data and check if the Acctid exists or not. If yes then update else insert.Then get then the second string of data and check if the Acctid exists or not. If yes then update else insert.After checking all the strings ,it have to check if any Acctids other than acctid mentioned in the string exists in the table for that login, then delete those rows |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-20 : 10:27:08
|
| Duplicate:-http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=105228 |
 |
|
|
|
|
|
If exists - SP