Add text to first record part 2 case in where clause...

• jbalbo

  SSCertifiable

  Points: 7583

  More actions

  November 14, 2013 at 1:14 pm

  #286244

  So I've learned to use a union to add the 'all' to my list

  I am now trying to use a case in my where clause

  WHERE Otherstuffgoeshere...

  AND

  case when @Location <> 'All'' then (Location.Code = @Location)

• Keith Tate

  SSCrazy Eights

  Points: 9938

  More actions

  November 14, 2013 at 2:11 pm

  #1666543

  This is a duplicate post. I have responded to your first post:

  http://www.sqlservercentral.com/Forums/Topic1514453-150-1.aspx

  Let's use that one going forward.

  ---

  
  Microsoft Certified Master - SQL Server 2008
  Follow me on twitter: @keith_tate

  Forum Etiquette: How to post data/code on a forum to get the best help[/url]