About partitioning....will any one help plz.......

  • Hi, i am existing with below parti

    Create partition function archive_dtPF(datetime)

    as range right for values('20110101','20110401','20110701','20111001')...

    i want to add this partition

    (Create partition function archive_dtPF(varchar(50))

    as range left for values ('AVMselect','RealQuest','Vector')

    ) to above partition.

    Same partition with different data types

    can i add datetime partition to varchar.

    If any one that would be great.

  • Forgive me if I misunderstood your question.

    I havent worked on partitions for sometime but i think you should be able to use the datetime as part of the partition function as an varchar. Now should you is a different question.

  • You can only have one partition function. How do you plan to relate 20110101 with AVMselect? There's no logical way to put these together and determine which values go in which partition.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply