如何从选择语句中在T-SQL中声明变量

Question

declare @Week nvarchar(16) = quotename(concat('Week',@CID,@SID));
declare @Week2 nvarchar(256) = concat('SELECT TOP 1 [Year],[Week] FROM',@Week,'GROUP BY [Year],[Week] ORDER BY [Year] DESC,[Week] DESC');

exec sp_executesql @Week2

如何从EXEC SP_EXECUTESQL @Week2的结果中分别声明@year和@week？ （在将结果值分配为 @year和@week中为“表示”，

感谢

declare @latestyear NVARCHAR(50), @latestweek NVARCHAR(50)
declare @Week2 nvarchar(256) = 'SELECT TOP 1 @latestyear=[Year],@latestweekweek=[Week] FROM [Week45] GROUP BY [Year],[Week] ORDER BY [Year] DESC,[Week] DESC';
exec sp_executesql @Week2
PRINT @latestyear
PRINT @latestweek

以上似乎对我不起作用，

如果可能的话，也尝试在1个选择的语句中尝试执行此操作