select #tempTable - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

select #tempTable

Author

Topic

lane0618
Posting Yak Master

134 Posts

Posted - 2002-05-30 : 14:55:21

Is it possible to make this work? #skulist returns column names that I want to use in the second query.

select sku
into #skulist
from dbo.data
Where spec_no = 'ss-h34-01'

select #skulist
from dbo.finish

drop table #skulist

Thanks!
Lane

VyasKN
SQL Server MVP & SQLTeam MVY

313 Posts

Posted - 2002-05-30 : 17:39:50

Is this what you are trying to do?

select *
from dbo.finish
where sku in
(
select sku
from dbo.data
)

--
HTH,
Vyas
http://vyaskn.tripod.com

lane0618
Posting Yak Master

134 Posts

Posted - 2002-05-30 : 19:20:37

No, but thanks. I figured it out using CSV.

Thanks,
Lane

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources