Problem with variable

[DKL01]

Hi Guys,

I'm wondering what could be the problem here.
Thanks


declare @ItemID int

select @ItemID = max(ItemID) from Table1

if @ItemID = null @ItemID = 0 // error here

 

[tlbroadbent]

You need the SET command in the last statement.

if @ItemID = null Set @ItemID = 0 Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin

 

[DKL01]

Thanks for the response.
I changed my code to :

Declare @ItemID int

select @ItemID = max(ItemID) from Table1
if @ItemID = null set @ItemID = 0
select @ItemID

Actually I don't have any data in Table1. But o/p of the stored procedure is still NULL instead of 0

 

[DKL01]

I'm using SQL Server 7.0

 

[tlbroadbent]

Change the Select statement to use the IsNull function. Then you won't need to test later.

Select @ItemID = IsNull(max(ItemID),0) from Table1
Print @ItemID Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin

 

[DKL01]

Thanks it worked. I really appreciate your help.