SQL Server - how to pass variable to nested query?

Asked By lightw

26-Oct-07 07:30 PM

how to assign the @title global so the inner query, the 2nd select, will know
what it is?  thanks.

declare @title nvarchar(100);
set @title='testing';

select *
from a
where id=@title
and (select * from b where id=@title);

26-Oct-07 07:49 PM

That will work.  What problem are you experiencing?

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON   Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


how to assign the @title global so the inner query, the 2nd select, will
know
what it is?  thanks.

declare @title nvarchar(100);
set @title='testing';

select *
from a
where id=@title
and (select * from b where id=@title);

26-Oct-07 08:45 PM

Without making any offense, you should explain what you are trying to do
with your query; ie., what's the result that you want to get from your
tables A and B.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)

27-Oct-07 05:53 AM

Hi,

You have not specified which kind of problem you are facing, but then
also As per my knowledge this will not work properly. I think you are
trying the fetch records from both tables. I will suggest you to use
query like,
--------
declare @title nvarchar(100);
set @title='testing';

select a.id,a.title,a.name,b.id,b.title,b.name from a inner join b on
a.id=b.id where id=@title
--------
You can use as many fields you like by 'table name.field name'.

Regards,
Mansi Shah.

*** Sent via Developersdex http://www.developersdex.com ***