Stored Procedure Problem

[migules]

Hi,

I am new to c++ and stored procedure, how to get two values from sql server.

Here's my stored procedure code

Create Procedure Get_Item_Details
(
@pCode nvarchar(10),
@pDesc nvarchar(50),
@pRemarks nvarchar(50)
)
as

select @pDesc,@pRemarks = description from dept where code = @pCode;


No luck with this code with error return message

Msg 141, Level 15, State 1, Procedure Get_Item_Details, Line 9
A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations.

Thanks