SELECT dependant on parameters

• lee roberts

  SSC Veteran

  Points: 250

  More actions

  June 21, 2007 at 3:56 pm

  #196430

  I think i posted this in the wrong place, so i'll put it here 

  Hi,

  Is there a way (through case or if statements i assume) to select rows from a table depending on a parameters value?

  i.e.

  @customerID int

  if customerID = (certainValue)

  select * from Table where customerID = @customerID

  else

  select * from table

  Thanks for your time

  Lee

• Aaron Ingold

  SSCrazy Eights

  Points: 9070

  More actions

  June 21, 2007 at 4:04 pm

  #714470

  SELECT *

  FROM table

  WHERE ( @customerID = (CertainValue) AND customerID = @customerID)

  OR @customerID (CertainValue)

  That should do ya...