Inserting Records

• reneolavarrieta

  Newbie

  Points: 6

  More actions

  December 10, 2008 at 1:10 pm

  #197080

  I have a table which contains records as follows:

  Unique ID StartDate EndDate NumMonths Total

  1234 20080101 20080531 5 500

  I would like to insert into a new table as many records are the NumMonths above incrementing the StartDate by one month for each records. Essential I would like my output to be as follows:

  1234 20080101 20080131 1 100

  1234 20080201 20080229 1 100

  1234 20080301 20080331 1 100

  1234 20080401 20080430 1 100

  1234 20080501 20080531 1 100

  Can anyone provide some insight as to how I can achieve this?

  Thank you,

  Rene O

• SwePeso

  SSC-Dedicated

  Points: 39758

  More actions

  December 10, 2008 at 3:17 pm

  #910705

  Already asked and answered here

  http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=116046

  ---

  N 56°04'39.16"
  E 12°55'05.25"