Cacher is the code snippet organizer for pro developers

create partition function RandomData_Range(datetime)
as
range left for values(
'20001231 23:59:59.997',
'20011231 23:59:59.997',
'20021231 23:59:59.997',
'20031231 23:59:59.997',
'20041231 23:59:59.997',
'20051231 23:59:59.997',
'20061231 23:59:59.997',
'20071231 23:59:59.997',
'20081231 23:59:59.997',
'20091231 23:59:59.997',
'20101231 23:59:59.997',
'20111231 23:59:59.997',
'20121231 23:59:59.997',
'20131231 23:59:59.997',
'20141231 23:59:59.997',
'20151231 23:59:59.997',
'20161231 23:59:59.997'
)

create partition function ArchiveSales(Date) as
range left for values('12-31-2010','12-31-2011','12-31-2012','12-31-2013','12-31-2014','12-31-2015')