Most Efficient Way to Retrieve Date Ranges
What's the most efficient way to retrieve date ranges with a table structure like this?
create table SomeDateTable ( id int identity(1, 1) not null, StartDate datetime not null, EndDate datetime not null ) go
Say you want a range for both
EndDate. So in other words, if
StartDate falls in between
EndDate falls in between
@EndDateEnd, then do something.
I know there are a few ways to probably go about this, but what is the most advised?