i am creating one Stored procedure which contains around 12 to 14 variables.
here i have to check that if @Parameter1 <>' and rest of all are empty then execute one select query and if @parameter1<>' and @Parameter2<>' and rest are empty then according query will get execute.
but if i use the if else condition in the stored procedure to execute this then it will become so confusing and very big because i have to pass a select query for each condition........ :(
so please help me to know if there is any way in which i can check all the condition in a very easy way without using this if...else statement.....
View Complete Post