CASE WHEN
DATEDIFF(mm, NPB.CreatedOn, soeb.ASK_ContractEndDate) > 1
THEN
DATEDIFF(mm,NPB.CreatedOn, soeb.ASK_ContractEndDate)
ELSE 0
END
Software engineers do the job better!
SQL DBA
Precious Lite 2022 | All Rights Reserved. Precious Lite theme by Flythemes