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

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

SQL: Ginger, I need your help :-)

Dr.Silly · 2010-07-20 14:12:09

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

20-07-2010 2:12pm

#1

Dr.Silly

Closed Accounts Posts: 1,759 ✭✭✭

Join Date: January 2010

Posts: 1663

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

0

Comments

#2 20-07-2010 4:19pm

E39MSport

Registered Users, Registered Users 2 Posts: 3,721 ✭✭✭

Join Date: June 2008

Posts: 3442

Teradata: -

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

0
#3 20-07-2010 4:35pm

Dr.Silly

Closed Accounts Posts: 1,759 ✭✭✭

Join Date: January 2010

Posts: 1663

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

0