select L_Month, L_MonthName FROM tbl_Month Mth
WHERE NOT EXISTS
(SELECT 1 FROM tbl_SignOff Sgn
WHERE Sgn.SO_Month = Mth.L_Month
AND Sgn.SO_Year = @YearVar
AND Sgn.SO_Location = @UserLoc)
For every expert, there is an equal and opposite expert. - Becker's Law
My blog
My TechNet articles
No comments:
Post a Comment