From: mcstockX@Xenquery   
      
   what have you tried?   
      
   "ML"  wrote in message   
   news:f344732f.0406081116.383ec141@posting.google.com...   
   | hello   
   |   
   | i need to write an sql which calculates # of billing cycles for an   
   | order for which ive order start and end date. the first invoice will   
   | be cut on the order start date. Also if i apply a coupon for lets say   
   | one month (30 days) to that order i need to calculate how many billing   
   | cycles that coupon will apply to.   
   | ive start and end date of coupon ina  diff table for that order   
   |   
   | for eg: if an order was started on 1/15 and ended on 4/14 i have 3   
   | billing cycles (the invoice was suppose to cut on. 1/15 , 2/15 and   
   | 3/15)   
   | lets say on 3/15 if a users applied one month coupon which means he   
   | didnt have to pay for billing cycle 3/15.   
   |   
   | can someone help me with this logic   
   |   
   | thank u   
   | ml   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)