2 Date Fields formula or something 1

[codrutza]

I work with SQL Server 2000.
I need to write in a SP:

SELECT ….FROM…
WHERE
DepArr>=@DateStart and DepArr<@DateEnd

Where DepArr:
If table.type=’imp’ then DepArr=table.ArrDate
Else if table.type=’exp’ then DepArr=table.DepDate

Pls help

 

[markros]

You can use two ideas:

select .. FROM
where (Table.Type = 'imp' and Table.ArrDate >=@DateStart and Table.ArrDate < @DateEnd) OR (Table.Type = 'exp' and Table.DepDate >=@DateStart and Table.DepDate < @DateEnd)

Alternative solution

select * from 
(select .., case when Type = 'imp' then ArrDate 
when Type = 'exp' then DepDate end) as DepArr FROM .. ) 
Derived where Derived.DepArr >=@DateStart and DepArr <@DateEnd

You need to test the performance.

PluralSight Learning Library