You could use a UNION query and then just use NULL for the missing columns in the dataset with fewer columns. The sorting might be an issue. Hard...

Mario,

Just wondering, but why do you have Earnings and Amount in the same column? If you separated them so that they were in separate columns, it would make dealing...

If you have 2012, then here's an example of a running total using window functions (from Itzik Ben-Gan's book on Window functions in 2012):

SELECT empID, qty,

SUM(qty) OVER (PARTITION BY empID

...

Maybe my brain is not working, but if you can return a set of punch in/outs for an employee, shouldn't you be able to use ROWNUMBER() to get odd (clock...

So this was a simplified example?

If you're having trouble implementing a more complex solution, post the table info and the expected result.

Umm... Okay! I hope you're being facetious!

This is close:

WITH cteList(col1, col2, freq) AS

(SELECT col1, col2, count(*) OVER (PARTITION BY col1, col2) AS Freq

FROM (

SELECT 'John' AS col1,1 as col2,1 as col3

UNION ALL

SELECT 'John',1,1

UNION ALL

SELECT 'John',2,2

UNION ALL

SELECT...

This is the article I was thought might help:

http://www.sqlservercentral.com/scripts/Miscellaneous/31733/

What you're describing is called a data-driven subscription. What version of SQL Server are you using? Enterprise supports them natively. If not, I am pretty sure that Jason...

Why not just use a junction table? Normally, the junction table holds the foreign keys from the two parent tables and then any information that is specific to the...

Create a calculated column in your dataset for the year.

YEAR(SomeDate)

Then you should be able to group no problem.

Do you understand the difference between an OLTP database structure and a DW database structure? Which part are you having trouble with? The star schema?

If you can get your hands on a copy, read a little of Ralph Kimball's Data Warehouse Toolkit

Sorry, I completely missed this. What you describe is exactly what I ended up doing. Lots of parameterized subreports that I could include in a "main" report. ...

I think I managed to reproduce your problem... and I think I solved it.

First off, some data to play with that I used as the data source for my report:

SELECT...