I agree with several of the posters that have indicated a general lack of business interest in making a full commitment to the full use of SP. It may...

It would probably be easiest to include the week datepart in your sql query, then use the week to group the report. If you can't change the query, the...

I'd suggest adding some parens to the where - change to :

where

(flow_START_DATE is not...

I think it's jsut the way that Excel handles a variance in data type within a column. your first few rows make Excel think you have a text data...

Ewww! Of course not. They are far...

You can't pass the date function in directly, pass it through a variable:

from MSDN: http://msdn.microsoft.com/en-us/library/ms189915.aspx

-- Passing the function value as a variable.

DECLARE @CheckDate datetime;

SET @CheckDate = GETDATE();

EXEC dbo.uspGetWhereUsedProductID 819, @CheckDate;

GO

Agree completely

You might look through this article as well:

http://www.simple-talk.com/content/print.aspx?article=722

Remove the last comma before the end paren

fwiw - there certainly are some zips that cross state borders. Wikipedia says:

Because ZIP codes are intended for efficient postal delivery, there are unusual cases where a ZIP code...

sort by the month datepart integer, but display the month name

You can always copy and paste. Just click the corner in the results grid to select all, then copy (ctrl-c), and paste into excel. By default when the...

you could decompose the string and recompose in a date-like format, the cast and convert both work ok in sql query. dunno about informatica. the date string you...

It's a fair cop

just to consider - you won't be able to open reports created in old bids with 2008 r2 bids. different namespace.