>>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
>
>Sure,
>
>

>SELECT @member_ref     = member_ref,
>       @individual_ref = individual_ref
>from MEMBER 
>where MEMBERSHIP_NO =  @membership_number1
>

Thanks Borislav