How to set multiple T-SQL variables in one SELECT query?

Question

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

How can I set @sampleid and @clientid by running this request 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 

Answer 1

 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