Hi there, I have one stored procedure which have 5 input variables and all of those can be null. Now i need to write the query in the stored procedure so that which ever input variable is having value supplied that parameter will be used in query to filter the data. One way of dealing with this is i create a dynamic sql and execute that in the end. Is there any other way i can deal with this? Thanks !