Conditional WHERE in SP

• BrianDQuinn

  SSC Enthusiast

  Points: 117

  More actions

  July 22, 2002 at 9:57 am

  #79411

  Hi Folks,

  I have a stored procedure that has 5 arguments. Any combination of these arguments could be passed to the SP for use in the WHERE clause.

  Here's my question, is it possible to default each argument to a generic "select all" value, so the I only need one query with all the arguments in the WHERE clause, or do I have to write IF / Else IF tree to see if the argument has been passed or not (each one with its own select statement)?

  cheers,

  Brian Q

• Andy Jones, DBA

  Hall of Fame

  Points: 3641

  More actions

  July 22, 2002 at 10:28 am

  #433173

  See the thread: -

  http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=5489&FORUM_ID=8&CAT_ID=1&Topic_Title=Remove+Null+Parameters+from+Select&Forum_Title=T%2DSQL

  Regards,

  Andy Jones

  .

• BrianDQuinn

  SSC Enthusiast

  Points: 117

  More actions

  July 22, 2002 at 12:31 pm

  #433182

  Thanks Andy!