Help in Bulidng a Query

• Prakash-485822

  SSC Eights!

  Points: 982

  More actions

  December 23, 2009 at 11:07 pm

  #141184

  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

• Nabha

  SSCrazy Eights

  Points: 8534

  More actions

  December 24, 2009 at 12:05 am

  #1096229

  dupe I guess,

  http://www.sqlservercentral.com/Forums/Topic838859-338-1.aspx?Update=1

  ---------------------------------------------------------------------------------

• arun.sas

  SSChampion

  Points: 11831

  More actions

  December 24, 2009 at 1:36 am

  #1096252

  Hi,

  Repeated post, Discussion already starts, in

  http://www.sqlservercentral.com/Forums/Topic838860-392-1.aspx?Update=1