sp_executesql の結果を変数に取り出す
EXEC sp_executesql
    N'SELECT @C = COUNT(qty), @S = SUM(qty) FROM sales',
    N'@C int OUTPUT, @S int OUTPUT',
    @C output, @S output