SELECT @local_variable

• webrunner

  SSC-Dedicated

  Points: 31711

  More actions

  July 30, 2015 at 2:06 pm

  #1816298

  Great question, thanks.

  - webrunner

  -------------------
  A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
  Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

• Koen Verbeeck

  SSC Guru

  Points: 259085

  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