http://msdn.microsoft.com/en-us/library/ms179854.aspx explains how partition schemes and functions work. Read that first. Then maybe create a dummy table in a dummy DB to play with until you...

You mean by creating two tablixes and filtering one for value 'A' and the other for value 'B'?

Just add a filter to your tablix and you should be off...

Marco,

I'm confused. What is your ultimate goal? You say you want to delete data from your database, but there are no delete statements anywhere. Your stored procedure inserts...

You are passing too many parameters to your stored procedure. It can only accept two:

create procedure [dbo].[AdventureWorks2008R2]

@severity int, -- param 1

@message nvarchar(max) -- param2

as

...

What do the @severity and...

Might be a case of "when all you [know] is a hammer, everything looks like a nail."

If you're going to output the results to Excel, you have to do it a single dataset at a time, so I don't know that you have any other option...

Global task is to present single screen to user, then he selects @Year and Press Run, system should direct flow based on @Year, if < 2010 then run Report02 else...

Nice setup... makes sorting this stuff out not to hard! I would probably use a cursor because you have to process each combination of Version and Doc separately... ...

Why can't you just do that in your SQL statement? You would probably have to do a lot of

COALESCE(MyColumn1,0) + COALESCE(MyColumn2,0)....

What are you trying to accomplish? can you...

Which was...?

I think I just very carefully solved this using a 2012 solution... figured I would post it for people to tear apart...

the ROWS PRECEDING window function is new in 2012......

Look it up in Active Directory

Like this...

=MonthName(Month(Fields!DueDate.Value)) & " " & Year(Fields!DueDate.Value)

just change DueDate to your field name.

If you are breaking up the year into 4-week "groups", then from what date are you starting the count? The first day of the year? If not, how...

Remove Dates? Where?

Do you have a Calendar/Date dimension table? Could just be me, but I thought you had to add a column to your Fact table for the...