1.) I need this done for a single table.
A Partition function and scheme are not table specific, the table is built on the scheme. So if you have more than 1 table built on this scheme, you cannot do it for only 1 table.
2.) I need each partition to be for a year, rather than a month.
Then you create your function based on years and not on months.
3.) I don't want any data removed, so I don't need what happens in part III at all.
Don't do part III. Simply merge that partition in with the left partition.
4.) I don't want to use PowerShell, I just want pure T-SQL with agent jobs.
Write the job in SQL.
Try this:http://msdn.microsoft.com/en-us/library/aa964122%28v=sql.90%29.aspx
If this is a question on how to partition and how to write your functions and such... Best to give it a try first and post any specific issues with proper DDL.
Jared
CE - Microsoft