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.

2nd post in as many days for this same thing... you guys got a little homework from the same professor?

Try this... most of it is test setup code... AND, it's...

Very clever. 

Slight mod for you...Take out the initial variable load and you won't get the leading (or trailing) commas... change the two variable lengths also gets rid of the...

Sorry... wasn't talking about the concept of BI... I was talking about the expensive products people buy to do BI.... we made our own because nobody seemed to be doing...