如何在一条sql语句中根据条件赋值多个变量

DECLARE @Variable1 INT;
DECLARE @Variable2 VARCHAR(50);

SELECT 
    @Variable1 = CASE 
                    WHEN condition1 THEN value1
                    WHEN condition2 THEN value2
                    ELSE value3
                 END,
    @Variable2 = CASE 
                    WHEN condition4 THEN value4
                    WHEN condition5 THEN value5
                    ELSE value6
                 END
FROM 
    YourTable
WHERE 
    condition3;