Date Difference Grouping 1

[TMRO]

Hi everybody,

I think this is a easy one, but somehow my brain is stucked on this Monday morning:

I have this table

Name Date
A1 1/1/2004
A1 1/2/2004
A2 1/1/2004
A2 1/6/2004
A3 1/2/2004
A3 1/8/2004

Always the column "name" will be in pairs: 2 A1, 2 A2, 2 A3 etc...
So what I need to find out is: the difference in days between the first A1 and the second A1,

somethink like
Name Difference in days Month
A1 1 1
A2 5 1
A3 6 1

etc...


Could anybody give me a hint?
Thanks a lot,
TMRO

 

[LogicMagic]

try something like:

select pairname, datediff(d, max(date), min(date)), datediff(m, max(date), min(date))
from pairs
group by pairname

Good luck,

Vlad

http://www.logicmagic.com