[SomeDateColumn]<=TODAY

what I did was to do a weird join. Say you have two CTEs, one for "Current Year" and one for "Previous Year". You can do a terrible...

FWIW, sometimes people just don't know what an answerable question looks like (complete with sample data etc). I was sorely tempted to post a link to Jeff's article when...

Jack,

Cool solution! After stepping away from what I was thinking before, I realized that I could use a CTE to do the thing... (and I saw you did that)....

I got a start on the solution... hopefully this will send you in the right direction. If you have 2012, you can use LAG to compare. The only...

Easiest way to do it is to open the report in design view. Do you not have rights to do that?

My guess would be to create a PIVOT

This article walks you through it:

http://www.sqlservercentral.com/articles/pivot/62808/

Then once you have that, you should be able to append it to your destination table.

Can't you just publish it as a report part and reuse it that way?

If what you're intending is to "explode" the range (say 1/1/2014 to 6/1/2014), then the easiest way is probably using an auxiliary Tally table. (Mine is called "Numbers" for...

This worked... I changed a few field names, because they're reserved in T-SQL. Turns out this is a plain totals query.

SELECT Ticket, UserX, MIN(PriorityX)

FROM

(SELECT 'A' AS Ticket,

'ME' As...

Before trying to build a data warehouse, I would definitely recommend reading Ralph Kimball's book. I have a really old copy of The Data Warehouse Toolkit. There are...

If you really mean the current year as in YEAR(GETDATE()), then

=YEAR(Today())-1 is last year: 2013

=YEAR(Today())-2 is two years ago: 2012

It's a tablix on the outside (for the years) with a matrix inside (for the Totals by month for a single year). Because several years are in the...

In a word, use DATEADD().

for example...

=DateAdd("d",3,Today)

I can try to attach this thing... the fun part is that I had to do some voodoo to get all the dates to show up. Here's the query...