asked on If Statement in SQL Stored Procedure
I have the select statement below.
I am trying to create an if statement if the alias DAY is Null or > 0 then a new alias Late should = 1 otherwise it would be zero. Everything I tried messes up the prior selections.
SELECT distinct ph.NAME_VND_ORDFM as Name_Vend,ph.ID_PO as PO_NBR, pl.ID_REL_ORD AS PO_REL,pl.ID_LINE_PO AS PO_LN, CONVERT(VARCHAR,pl.DATE_RC
CONVERT(VARCHAR,pl.DATE_RQ
Any help will be appreciated.
I am trying to create an if statement if the alias DAY is Null or > 0 then a new alias Late should = 1 otherwise it would be zero. Everything I tried messes up the prior selections.
SELECT distinct ph.NAME_VND_ORDFM as Name_Vend,ph.ID_PO as PO_NBR, pl.ID_REL_ORD AS PO_REL,pl.ID_LINE_PO AS PO_LN, CONVERT(VARCHAR,pl.DATE_RC
CONVERT(VARCHAR,pl.DATE_RQ
Any help will be appreciated.
Microsoft SQL Server 2008
Last Comment
Scamquist
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
if the value returned is null, the isnull(xxx, 100) will return 100.
as you said that null value returned should also display 1 as result, I used 100 as value, 1 or 99999 would have worked the same way.
as you said that null value returned should also display 1 as result, I used 100 as value, 1 or 99999 would have worked the same way.
ASKER
Thank you for the assist and the explaination.
CASE WHEN ISNULL( DATEDIFF(DAY, pl.DATE_RQST,pl.DATE_RCV),