SQL & Linq To SQL Help

Posted by cre-johnny07 on Stack Overflow See other posts from Stack Overflow or by cre-johnny07
Published on 2010-05-12T12:55:24Z Indexed on 2010/05/12 13:04 UTC
Read the original article Hit count: 286

Filed under:
|

I have a table which is some thing like below..

Date             ID

 2009-07-01            1
 2009-07-01            2
 2009-07-01            3
 2009-08-01            4
 2009-08-01            5
 2009-08-01            6
 2009-09-01            7
 2009-09-01            8
 2009-10-01            9
 2009-10-01            10
 2009-11-01            11

....

Now I need to write a query which will show a output like below.

Date               Start            End
2009-07              1               3
2009-08              4               6
2009-09              7               8

...

How can I do this.. Any help would be highly appreciated Thanking In Advance Johnny

© Stack Overflow or respective owner

Related posts about sql

Related posts about linq-to-sql