case when @StartDate<@EndDate then
DATEDIFF(dd,@StartDate,@EndDate) + 1
when @StartDate>@EndDate then DATEDIFF(dd,@StartDate,@EndDate) - 1 end
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm: