allergy

Create a query (temp table, cte, table variable) where you create all the dates of the month with a zero value for the quantity and UNION ALL it with the...

Why do you need the Null category at all? Does it exist simply for roll up? If it is just for roll up then drop the null category...

mow

I am not sure this is true in SSIS, but....

Have you tried DT_STR? In SQL Server an NVARCHAR is limited to 4000 characters because each character takes 2 bytes,...

TRIM all of your data.

I hear Snookie is pregnant, and her due date is December 21, 2012.

Well played Mayans......well played.

vacuum

If your source data has a key, why not just use that?

Your expression

project_manager_lastname == "Anyname" ? 1 : 2

is a valid conditional expression that should return a 1 when project_manager_lastname...

peg

I didn't know the answer for certain, but I couldn't imagine a situation where it would be good or practical to have multiples writing to the same cache. Thanks.

Christina Aguilera and Maroon 5 just had a song about him.:-P

It looks like you might have a couple of problems. The first is multi value inputs to stored procedure parameters. I like the table valued function approach to...

trivia

Stage everything to SQL Server first, then do your ETL work.