SELECT @local_variable

• Koen Verbeeck

  SSC Guru

  Points: 259197

  More actions

  August 4, 2015 at 2:32 am

  #1817034

  Easy one, thanks.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP

• Scott-144766

  SSCarpal Tunnel

  Points: 4333

  More actions

  August 4, 2015 at 7:10 am

  #1817094

  Or you might get

  Msg 208, Level 16, State 0, Line 7

  Invalid object name '#values'.

  if you have the misfortune to be working on a case-sensitive database.

  --
  Scott

• Naidu PK

  SSCrazy

  Points: 2481

  More actions

  August 4, 2015 at 9:27 am

  #1817204

  Scott-144766 (8/4/2015)

  ---

  Or you might get

  Msg 208, Level 16, State 0, Line 7

  Invalid object name '#values'.

  if you have the misfortune to be working on a case-sensitive database.

  Awww!! Good point to know. I never thought about it.

  Thanks,
  Naveen.
  Every thought is a cause and every condition an effect