Store procedure returned null value
I have problem on stored procedure after executing it
This is the select statement inside the stored procedure:
select sum(amt) as total from orders where order_Date = today
The problem occurs when there is no record or orders on a specific date.
How could I check if the value returned is null or there is no record found in vb.net?
Hope someone could help me on this. Thanks!!!
Re: Store procedure returned null value
2 solutions:
in SQL (Ms SQL) for example:
Code:
SELECT IsNUll((select sum(amt) as total from orders where order_Date = today),0)
in VB use .IsNull (as I remember) method of DataReader or DataTable
Re: Store procedure returned null value
SQL Server 2000
SELECT COALESCE(sum(amt),0) as total from orders where order_Date = today