insert into temp table based on if condition
- From: "das" <Adityanad@xxxxxxxxx>
- Date: 12 Apr 2006 09:29:57 -0700
hello all,
this might be simple:
I populate a temp table based on a condition from another table:
select @condition = condition from table1 where id=1 [this will give
me either 0 or 1]
in my stored procedure I want to do this:
if @condition = 0
begin
select * into #tmp_table
from products p
inner join
sales s on p.p_data = s.p_data
end
else
begin
select * into #tmp_table
from products p
left join
sales s on p.p_data = s.p_data
end
Tha above query would not work since SQL thinks I am trying to use the
same temp table twice.
As you can see the major thing that gets effected with the condiction
being 0/1 is the join (inner or outer). The actual SQL is much bigger
with other joins but the only thing changing in the 2 sql's is the join
between products and sales tables.
any ideas gurus on how to use different sql's into temp table based on
the condition?
thanks
adi
.
- Follow-Ups:
- Re: insert into temp table based on if condition
- From: Teresa Masino
- Re: insert into temp table based on if condition
- From: Serge Rielau
- Re: insert into temp table based on if condition
- From: Chris Fulstow
- Re: insert into temp table based on if condition
- Prev by Date: Re: Time to shrink a database
- Next by Date: Re: Smalldatetime comparisons with non-clustered index
- Previous by thread: Smalldatetime comparisons with non-clustered index
- Next by thread: Re: insert into temp table based on if condition
- Index(es):
Relevant Pages
|
