SQL Query - Between two dates

[gooseriver]

I have two date parameters DT1 and DT2. If I enter two dates - return data from within those two dates. If no values are entered in the parameters, return everything.

Not sure how to incorporate both.

 

[johnherman]

something like this (untested, obviously)

select * from (
case when (your specific query) is null then (your select all query) else (your specific query) end
)


==================================
advanced cognitive capabilities and other marketing buzzwords explained with sarcastic simplicity

 

[bborissov]

SELECT (what ever)
FROM ???
WHERE @Dt1 IS NULL 
   OR SomeDate BETWEEN @Dt1 AND @Dt2

Borislav Borissov
VFP9 SP2, SQL Server

 

[Auguy]

My two cents. If there are time values on the SomeDate column then you will have to account for those.
Maybe something like.

SELECT SomeDate >= @DT1 AND SomeDate < DATEADD(DAY, 1, @DT)

Where DT1 & DT2 have no time values.

Auguy
Sylvania/Toledo Ohio

 

[gooseriver]

bborissov

Do I need to add brackets???