Post reply

Partitioning by surname

  • November 9, 2010 at 4:50 am

    #228829

    Hi,

    I understand how to do this with a data range or int , but how can I logically split a table by surname? I only want about 10 max partitions.

    by date

    create partition function pf_orderdate (datetime)

    as RANGE RIGHT

    for values

    ('01 jan 2004','01 jan 2005')

    go

    How to do it for a-d,e-g etc?

    many thanks

  • November 9, 2010 at 5:05 am

    #1248157

    create partition function pf_customername (char(10))

    as RANGE RIGHT

    for values

    ('John','Paul')

    A-I will go to Partition 1

    J-O will go to Partition 2

    P-Z will go to Partition 3

    Vishal Gajjar
    http://SqlAndMe.com

  • November 9, 2010 at 9:01 am

    #1248366

    Many thanks all working

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

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