Declare and Set (Batch output)

• JStevenson1

  SSC-Addicted

  Points: 484

  More actions

  August 20, 2012 at 12:41 pm

  #262969

  I am trying to determine if there is a way to obtain all UserName,UserID rather than retrieving one value at a time?

  Declare @TestID Nvarchar (255)

  Set @TestID = '123456'

  Select User.UserName,User.UserID

  From User Join

  Acc On User.CID = Acc.ID

  Where Acc.MyID = @TestID;

• David Webb-CDS

  SSCoach

  Points: 17398

  More actions

  August 20, 2012 at 1:07 pm

  #1527811

  What do you get when you run:

  Select User.UserName,User.UserID

  From User Join

  Acc On User.CID = Acc.ID;

  ---

  And then again, I might be wrong ...
  David Webb