MS SQL CASE statement
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