The problem is you're using SQLServer. Which has different stored procedure
definition from Oracle!
So there :-P
From: andrew.henshall@... [mailto:andrew.henshall@...]
Sent: Tuesday, February 26, 2002 9:56 AM
Subject: [Chat] On the wings of love
For the SQuirrelL's amongst you all. If any of you can figure out how I
should do the following then i'd appreiciate it.
What I need to do is to loop through all the rows in a table and for each
row run a stored procedure that does some updates on it.
The stored proc needs the ID of the row passed to it.
My current attempt is:
SELECT UserID FROM WebLeaveUser
WHILE @@IDENTITY <= @@rowcount
PRINT '1. ' + @@IDENTITY
EXEC usp_aprilUpdate @@IDENTITY
But that seems to do nothing at all
Well the select works
Codedcombat-chat mailing list