How can I set multiple T-SQL variables in a single SELECT query?

Question

I have 3 variables: @testid, @sampleid and @clientid.

How can I set @sampleid and @clientid by executing this query once?

SELECT
  [sample].sampleid,
  [client].clientid
FROM
  dbo.[test]
  LEFT OUTER JOIN dbo.[sampleslice] ON dbo.[test].samplesliceid = dbo.[sampleslice].samplesliceid
  LEFT OUTER JOIN dbo.[sample] ON dbo.[sampleslice].sampleid = dbo.[sample].sampleid
  LEFT OUTER JOIN dbo.[client] ON dbo.[sample].clientid = dbo.[client].clientid
WHERE
  testid = @testid

Linvi · Accepted Answer · 2017-10-26 12:54:42Z

24

DECLARE @sampleid YOUR_VAR_TYPE;
DECLARE @clientid YOUR_VAR_TYPE;

SELECT
   @sampleid = [sample].sampleid, 
   @clientid = [client].clientid
FROM dbo.[test]


-- The variables are now initialized. You can now use them below.above

edited Oct 26, 2017 at 12:54

Linvi

2,0971 gold badge14 silver badges28 bronze badges

answered Aug 2, 2011 at 19:25

gbn

435k85 gold badges602 silver badges690 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

JustBeingHelpful Over a year ago

Thanks for replying so quickly. I have one more coming in about a minute. :-) Should be the last for today.

gbn Over a year ago

@Mr. MacGyver: you can probably combine this with your INSERT in the other question by JOINs on this table and notes. The WHERE in the other question becomes the JOIn onto "test"

Collectives™ on Stack Overflow

How can I set multiple T-SQL variables in a single SELECT query?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related