Conditional when

• deastr

  SSC Enthusiast

  Points: 111

  More actions

  June 23, 2008 at 7:07 am

  #381291

  Is anything similar to this possible without writing whole query in every begin block or without dynamic sql:

  proc(@arg1 bit)

  select * from table where x=y

  if @arg1 = 1 begin

  and when a=b

  end

  order by date

• Michael Earl-395764

  SSC Guru

  Points: 53873

  More actions

  June 23, 2008 at 7:29 am

  #832654

  proc(@arg1 bit)

  select * from table where x=y

  and (a=b or @arg1=0)

• SwePeso

  SSC-Dedicated

  Points: 39758

  More actions

  June 23, 2008 at 8:04 am

  #832700

  Also asked and answered here

  http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=105355

  ---

  N 56°04'39.16"
  E 12°55'05.25"

• noeld

  SSC Guru

  Points: 96590

  More actions

  June 23, 2008 at 9:41 am

  #832821

  Peso (6/23/2008)

  ---

  Also asked and answered here

  http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=105355

  This is funny 🙂

  
  * Noel