December 23, 2009 at 11:09 pm
Dear All ,
Please find below the data
MonthStart MonthEnd MonthTotalDaysAmount
Mar3/9/09 0:003/13/09 0:004 71
Mar3/23/09 0:004/5/09 0:0014 75
I need a query which returns
MonthStart MonthEnd MonthTotalDaysAmount
Mar3/9/09 0:003/13/09 0:004 71
Mar3/23/09 0:003/31/09 0:009 48.21429
Apr4/1/09 0:004/5/09 0:005 26.78571
Please help in this regards
Regards
Prakash
December 24, 2009 at 12:04 am
Not that I know the answer completely, but it would help all of us here if you can post the data like this and on what basis the amount(last column) is getting seperated/divided? (by number of days?)
http://www.sqlservercentral.com/articles/Best+Practices/61537/
---------------------------------------------------------------------------------
December 24, 2009 at 1:35 am
Hi,
Repeated post, Discussion already starts, in
http://www.sqlservercentral.com/Forums/Topic838860-392-1.aspx?Update=1
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply