Hi Please help me I 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 level2 test testee N Y eg: the string of value from application will be as (SVDB, N, Y; VGBY, Y, B; SCFV, Y, S; SRVD, Y, N; .....) The SP have to get the fist set of data i.e SVDB, N, Y , check if SVDB exists in the table for that login, if yes update else insert. Finally do acheck and delete the Acctid not available in above list Im using SQL 7 server. Please help me in doing this Thanks in advance

Hi Experts, I have to find discrepancy between two tables I have Table 1 with columns OrderID Date Quantity Symbol Table 2 with columns OrderID Date Quantity Symbol I want a script to find out a list of OrderIDs present in table1 but not in table 2 and a list of OrderIDs present in table2 but not in table 1. Could any one help me in writing this query? Thanks in advance