SQL Server 2008: Fill multiple T-SQL variables from one SELECT query?

Question

To fill one variable with a value from a query I can write following:

SET @TargetID = (SELECT TOP 1 ID FROM @bigDataSet ORDER BY date DESC)

To fill multiple variables from this query, eg. something like:

SET (@TargetID, @TargetName) = ....(SELECT TOP 1 ID, [Name] FROM @bigDataSet ORDER BY date DESC)

what can I write?

Martin Smith · Accepted Answer · 2010-09-29 14:30:30Z

22

SELECT TOP (1) @TargetID=ID, @TargetName=Name 
FROM @bigDataSet 
ORDER BY date DESC

answered Sep 29, 2010 at 14:30

Martin Smith

457k97 gold badges777 silver badges887 bronze badges

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

1 Answer 1