Query: Multiple step update error

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.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Query: Multiple step update error

Author

Topic

Shumaila
Starting Member

21 Posts

Posted - 2001-10-26 : 12:38:48

SELECT A.ID, DateAdd(yyyy , 1 , A.DateTimeStamp) AS dExpiryDate ,
A.CustID, A.ProdID , A.Status ,
Preference.TimeToRenew AS nDays , Preference.IRPDate
FROM A , B
WHERE A.CustID= Preference.CustID AND
A.Status =0

I have this query in a stored procedure. The recordset i get has about 100 records.Now i am checking some condition, changing the status field of the recordset in VB Program (VB is calling SP) and updating .

if condition1 then
Status = 1
else
Status = 2
end if

but after doing 10-15 records its giving this error

-2147217887:
Multiple-step operation generated errors. Check each status value."

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources