[RESOLVED] Set parameter value in select statement

[shakti5385]

Hello friend
How we can set parameter value in select statement.

Declare @ID decimal(18,2)

Select TOP 1 StudentId from Table1

How I can set first column value in parameter @ID In stored procedure... can we do it without courser.
Thanks
Shakti

[dee-u]

This?

SET @ID = Select TOP 1 StudentId from Table1

[shakti5385]

I am getting error incorrect syntax error.

Declare @TotalAssessedValue decimal(18,2)

SET @TotalAssessedValue = select TOP 1 totalassdval  from VTable order by CYear desc

[si_the_geek]

Erm.. what is that WHERE doing there?

[shakti5385]

Thanks I had done that but still same problem

[si_the_geek]

Try it like this:

SET @TotalAssessedValue = (select TOP 1 totalassdval  from VTable order by CYear desc);

[shakti5385]

thanks

now if we have two parameter than?

SET @TotalAssessedValue1,@TotalAssessedValue2 = (select TOP 1 A,B from VTable order by CYear desc);

[brucevde]

You must use the Select statement to set multiple local variables at once

Select TOP 1 @TotalAssessedValue1 = A, @TotalAssessedValue2 = B from VTable order by CYear desc

[shakti5385]

Thanks I got that