Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

SQL: Ginger, I need your help :-)

Options
  • 20-07-2010 3:12pm
    #1
    Dr.Silly
    Closed Accounts Posts: 1,759 ✭✭✭


    Hi,

    If Ginger is out there he'll know :-)

    Wondering about SQL partitioning.
    I want to parition a table, and have each months worth of data in one partition, which is fine,
    however, moving forward, is there a way to automate this process so each month I don't have to do it manually ?

    Ta ta


Comments

  • Options
    #2
    E39MSport
    Registered Users Posts: 3,721 ✭✭✭E39MSport


    Teradata: -

    PARTITION BY RANGE_N(<YOUR FIELD> BETWEEN '<your start date>' AND '<your end date>' EACH INTERVAL '1' MONTH );


  • Options
    #3
    Dr.Silly
    Closed Accounts Posts: 1,759 ✭✭✭Dr.Silly


    Oooh..thanks
    need to check if that's similar to SQL Server
    Cheers


Advertisement