General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2008
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only