Another Reporting System Stored Procedure Issue

Thx to all who helped me for Stored Procedure previously





Here is what I have:


3 Drop Down Boxes:


1) List of property


2) Ticket Status


3) Tech Name





All 3 Drop boxes have default value of "All"





So, if all 3 drop boxes are "All" ie.





list of property = All


Ticket status = All


Tech Name = All





Query pulls up all records from database and displays it.





Lets say if I select Tech Name is XYZ then query should pull out all property, all ticket status by Tech XYZ.





Now my previous developer has if else case and he has total 9 query for doing all this. He has used SQL along with C# code.





I am trying to modify this if-else and convert it into Stored Procedure. Is there a way I can handle all with 1 stored procedure ?





Previous Reporting works like charm........