I have not tried this, but have considered it for an upcoming project. Can you create a one-time subscription, which would then create a SQL job.. Then execute that...

I'd really like to know too, so I'm joining in hopes someone else does.

Mike,

I'm trying to do the same thing. Were you able to figure out how to get this to work?

Thanks.

Is there a benefit to dealing with storing and looking up the string 'yy-xxxxx', rather than 2 numerical fields (a year field and some incrementing number)?

I hope this turns out to be useful to someone. I found the core of this code from another SQL site (before I found this one