This is just an opinion... hard for me to write this one without sounding a bit Draconian... sorry...

Since views use the indexes from underlying tables, I've never understood the need...

Why not go for the simple method... schedule it with Windows Task Scheduler if you can't get it to run through the command shell.

Since you don't use XACT_Abort and you don't have any error checking code to do a conditional rollback, you don't really need the transaction.

Query Analyzer

Enterprise Manager

DOS (Cmd Prompt) w/ OSQL & BCP

T-SQL Help

This forum

Nice...

Concur and now I get it... you were warning everyone of the same thing I was thinking... the requirement was for 4 digits left-padded with zeros and I'm thinking that's...

I don't think he intends to store that in his database, Joe.  3rd party vendors frequently as for data in such a form.  And, no, there's not always a front...

Requirement is to show missing months as well

Dang... missed that one, David... nice catch.

Yep... you shouldn't put 3 pounds of meat in a 2 pound wrapper, for sure.

Thanks for the feedback, Dennis.  Appreciate it.

I forgot about that bloody chart.  Good find, Mike and thanks for the feedback.

Sometimes, there is no presentation layer...

SELECT REPLACE(STR(yourcolumn,4),' ','0')

Aw, what the heck... do it all in SQL... pick your poison...

 SELECT STUFF(RIGHT(CONVERT(CHAR(11),MonthDate,113),8),4,3,'-') AS [Month],

        COUNT(*) AS [Number of Requests Completed]

   FROM #MonthGroup

  GROUP BY STUFF(RIGHT(CONVERT(CHAR(11),MonthDate,113),8),4,3,'-')

Shoot... only 4 gig?  We set our temp db to 12 gig... ON PURPOSE!  Got resources?  Use 'em.