Output parameter from Sproc

[anon]

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!