Mittensonmaui
asked on
SQL server 2000 If statement
I am looking exclude any values that are zero or less than the datediff function returns
Select PCNS_STAFF_NO, PCNS_STAFF_SR_ALLOCATION_E ND_DATE,
datediff(mm,@startDate, PCNS_STAFF_SR_ALLOCATION_E ND_DATE)
from PCNS_STAFF_SR_ALLOCATION
Select PCNS_STAFF_NO, PCNS_STAFF_SR_ALLOCATION_E
datediff(mm,@startDate, PCNS_STAFF_SR_ALLOCATION_E
from PCNS_STAFF_SR_ALLOCATION
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.