Hi,

Is it possible to do next query without a procedure?

Select max(DateA,DateB)-min(DateC,DateD)+1 as days from......

DateA and DateC are start/end dates of a month.
DateB and DateD are start/end dates of a employee contract.

I want to now, how many days have the contract in that month.


Thanks.
Yartax