• Similar to what Lowell already posted, but leaving values as variables.

    DECLARE @a AS INT = 1;

    DECLARE @b-2 AS INT = 1;

    DECLARE @Parameter1 AS INT;

    DECLARE @Parameter2 AS INT;

    DECLARE @Parameter3 AS INT;

    DECLARE @Parameter4 AS INT;

    SELECT @Parameter1 = Par1,

    @Parameter2 = Par2,

    @Parameter3 = Par3,

    @Parameter4 = Par4

    FROM( VALUES(1, 0, 77, 14, 21, 0),

    (1, 1, 77, 14, 0, 0),

    (1, 2, 77, 14, 0, 0),

    (1, 3, 77, 14, 21, 0),

    (1, 4, 77, 14, 21, 0),

    (0, 0, 68, 14, 0, 0),

    (0, 1, 78, 14, 21, 0))PM(A,B,Par1,Par2,Par3,Par4)

    WHERE A = @a

    AND B = @b-2;

    SELECT @Parameter1 AS Par1,

    @Parameter2 AS Par2,

    @Parameter3 AS Par3,

    @Parameter4 AS Par4;

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2