Partitions

• gurpreet.saini343

  SSC Enthusiast

  Points: 131

  More actions

  April 15, 2014 at 12:58 am

  #396604

  I have a table with the following columns:

  [Cookie1] [int] NULL,

  [Cookie2] [int] NULL,

  [AdvertiserID] [int] NULL,

  [ActionID] [int] NULL,

  [PlacementID] [int] NULL,

  [AdID] [int] NULL,

  [TargetingLeafID] [int] NULL,

  [Click] [int] NULL,

  [InventoryTime] [datetime] NULL,

  [AdEventID] [int] NULL,

  [AdEventArgument] [int] NULL,

  [ExtendedData] [varchar](2500) NULL,

  [IPAddress] [varchar](15) NULL,

  [Tentative] [int] NULL ,

  [BIRTHTIME] datetime Null,

  LASTSEENDATE datetime Null.

  Now,the data is coming in from 1st of January 2013.The column 'InventoryTime' contains time in the format "yyyy-MM-dd HH:mm:ss.SSS". I want to create partitions on this table for each month.

  There should be in all 36 partitions till December 2015 (36 months).

  So,if i give input as 20 to the partition function it should return data for August 2014(20 months from Jan 2013).

  In am not able to figure out the syntax for this.

  Can anyone help?