Don't return multiple Select's

[RobS23]

How do I stop returning multiple resultsets?

I need to use selects to populate some parameters

Select @Brand = brand from BTable -- Don't return this

and then I want to return the single resultset

Select Name from NameTable Where name = @Brand -- Just return this

Cheers Folks

 

[checkai]

post your entire statement or procedure that you're using...need a little more information...

you can do this to set a variable...

Set @Brand = (select brand from BTable)

dlc

 

[SQLBill]

Try a Sub SELECT:

SELECT [Name]
FROM NameTable
WHERE [Name] IN (SELECT Brand FROM BTable)

-SQLBill