To: dwain.c

For this data:

INSERT INTO #test

SELECT

1,

'20130428',

'20130523'

UNION

SELECT

1,

'20130526',

'20130823'

UNION

SELECT

1,

'20130728',

'20130728'

UNION

SELECT

1,

'20130826',

'20130830'

UNION

SELECT

2,

'20130501',

'20130515'

UNION

SELECT

2,

'20130516',

'20130520'

UNION

SELECT

2,

'20130525',

'20130830';

i got wrong result:

12013-05-24 00:00:00.0002013-05-25 00:00:00.000

12013-08-24 00:00:00.0002013-08-25 00:00:00.000

22013-05-15 00:00:00.0002013-05-16 00:00:00.000

22013-05-21 00:00:00.0002013-05-24 00:00:00.000

there should not be gap between 2013-05-15 and 2013-05-16