Hi

IN SQL I am often am looking up values to use in my Stored procedure.

like


SET @member_ref = (SELECT member_ref from MEMBER where MEMBERSHIP_NO = @membership_number1)
SET @individual_ref = (SELECT individual_ref from MEMBER where MEMBERSHIP_NO = @membership_number1)

is there a way to combine that into one select statement and is there any point . (ie is one statement more efficient)

Thanks

Nick