I am actually working on a report where I need to pass parameters.
I need to pass the parameters HoursStated which could be 5, 10,15 . So when I pass 5 it will give me the details of everything where the Hours worked (which is a integer column) is > HoursStated (Can be 5 , 10 , or 15).
But at the same time I can pass "*" and I should get all the hours which are greater than All ( 5,10, 15)
The Query is
Select * from Production
HourWorked > @HoursStated
The above works perfectly fine for individuals .. Don't know how should I add for all three..