any one with good nd great knowledge on partitioning can solve this question.........

• sqlmaverick

  Default port

  Points: 1462

  More actions

  July 13, 2011 at 12:56 am

  #240798

  i partition the table by datetime. After that i tried to insert the data into the partition table.

  for example partition boundaries are 20110101:00:00:000, 20110201:00:00:000,20110301:00:00:000,20110401:00:00:000 with range left.

  when i insert the data in the partition table, the data of feb month get inserted in march boundary.

  I mean the data of 20110201 inserted in 20110301.

  So wat the problem will be. if any one help that would be great help for me.

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  August 9, 2011 at 8:33 pm

  #1366375

  If you haven't solved this problem yet, would you please post the actual CREATE PARTITION FUNCTION that you used?