--CREATE PARTITION FUNCTION [pfAVMX_HISTORY_YEAR](date) AS RANGE RIGHT FOR VALUES ('01/01/2000', '01/01/2001', '01/01/2002', '01/01/2003', '01/01/2004', '01/01/2005', '01/01/2006', '01/01/2007', '01/01/2008', '01/01/2009', '01/01/2010')
SELECT $PARTITION.[pfAVMX_HISTORY_YEAR](CAST('20100505' as DATE))