Hi all,
I am writing a stored procedure to query a tale using a select statement
and get those fields as output parameters...but am getting an error:
Error 141: a select statement that assigns a variable must nt be
contained with data retrieval operations...
the skeleton is as follows: any help greatly appreicated..;
CREATE Procedure sp_getvals(@id uniqueidentifier,@pId int output,@Def
varchar(100) output)
AS
BEGIN
select @pId=id,@Def=definition from tbl where id=@id
END
GO
thanks for ur time,
Ben
*** Sent via Developersdex
http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!