assigning value to variable in stored procedure

[brsecu]

I am trying to get info into a variable in a sql server 2000 stored procedure How can this be done. I thought i had it but it doesnt seem to work. This is what i have. Declare @var1 int Select @var1 Select max(List_ID) from table1 @var1 stays NULL What am i doing wrong?

[Pete OHanlon]

Here you go:

SELECT @Var2 = MAX(Lis_ID) from table1

Please visit http://www.readytogiveup.com/ and do something special today. Deja View - the feeling that you've seen this post before.

[RepliCrux]

Set @var1 = (SELECT max(List_ID) from table1) Select @var1 This is one way too

[brsecu]

Thanks a lot it worked I appreciate the help

[brsecu]

Thanks a lot it worked I appreciate the help

[Pete OHanlon]

Not a problem - I'm glad to help.

Please visit http://www.readytogiveup.com/ and do something special today. Deja View - the feeling that you've seen this post before.