Viewing post 1 (of 1 total)
I actually cleaned up the query to make it more generic it should have been just like the other.
AND n.STAFFID = isnull(@STAFFID, n.STAFFID)
The main question becomes why the IsNull function...
December 6, 2009 at 11:19 pm
#1088374