sql - Need Cross Tab TSQL Query to Calculate Date Difference -

sql - Need Cross Tab TSQL Query to Calculate Date Difference -

i have dataset , need calculate date difference. need generic query dataset different every day.

here dataset

**client number : status : statusdate** 123456 admit 2012-01-18 123456 accepted 2012-01-15 123456 offered 2012-01-10 567899 admit 2012-01-11 567899 accepted 2012-01-07 567899 offered 2012-01-05 987342 admit 2012-01-24 987342 accepted 2012-01-24 987342 offered 2012-01-21

above sample info , said info alter on daily bases. there 3 entered specific client number can see above 3 status in above next order.

what need calculate days different between offered accepted , accepted admit. above result set should this. 3 columns

**clientnumber : date diff betw offeres & accepted : date diff betw accepted & admited** 123456 5 days 3 days 567899 2 days 4 days 987342 3 days 0 days

i need generic query , said each client number have 3 status.

thanks in advance.

you'll have self join. here generic example.

select t1.clientnumber, datediff(day, t1.statusdate, t2.statusdate) offertoaccept yourtable t1 bring together yourtable t2 on t1.clientnumber = t2clientnumber , t1.status = 'offered' , t2.status = 'accepted' whatever

it's similar thing other interval mistyped in question. says "date diff betw accepted & accepted"

sql sql-server tsql