Viewing 2 posts - 1 through 2 (of 2 total)
August 31, 2018 at 8:04 am
#2004133
And why hardcode the 'Finance'?
Just pass in a parameter @Dept and change the WHERE clause:
WHERE STF.Department = @Dept or @Dept = ''.
I am creating...
August 30, 2018 at 12:54 pm
#2004073