How do I declare a varible equal to a value in a table?

• Mitch2007

  SSC Eights!

  Points: 830

  More actions

  August 12, 2009 at 3:11 pm

  #209447

  Hi all,

  hope this is a quick and dirty one but how do I state a declare variable to be equal to a field within a table ?

  Something like this:

  Set @ months = (I want to pull ADateFiled from TableA)

  Thanks in advance,

  Mitch

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  August 12, 2009 at 3:34 pm

  #1038346

  Like this:

  Set @ months = (SELECT ADateFiled from TableA WHERE ...)

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

• Mitch2007

  SSC Eights!

  Points: 830

  More actions

  August 12, 2009 at 3:46 pm

  #1038360

  Thank you Sir, much appreciated !!

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  August 12, 2009 at 3:51 pm

  #1038366

  Glad I could help.

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

• rgillings

  SSCrazy

  Points: 2114

  More actions

  August 17, 2009 at 5:53 am

  #1040108

  Another good option to be aware of is that you can assign values directly from your SELECT statement...

  SELECT @valueA = Field1 FROM someTable WHERE...

  This offers the ability to assign multiple values from the same record in one statement. For example, you can use:

  SELECT @valueA = Field1, @valueB = Field2 FROM someTable WHERE...

  Instead of:

  SET @valueA = (SELECT Field1 FROM someTable WHERE...)

  SET @valueB = (SELECT Field2 FROM someTable WHERE...)