SELECT DATEDIFF (DAY, @ID1ExpDate, GETDATE() + 1) AS DayDiff
SELECT CASE <variable> WHEN <value> THEN <returnvalue> WHEN <othervalue> THEN <returnthis> ELSE <returndefaultcase> END FROM <table>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)