[SQL] Invitation to connect on LinkedIn

LinkedIn Suha Onay requested to add you as a connection on LinkedIn: -- Marcin, I'd like to add you to my professional network on LinkedIn. - Suha View invitation from Suha Onay http://www.linkedin.

[SQL] Intersection of two date interval

Hi, How can i find the number of days in the intersection of 2 date interval? For example: 1st interval: (10.01.2007, 20.01.2007) 2nd interval: (13.01.2007, 21.01.2007) The intersection dates are: 13,14,15,16,17,18,19, 20 The result is: 8 How can i find the result, 8 in an sql query without usi