Looks like if you created a subreport for this part:

1--------------------------contacted--------------------2-------------1-------------1-----------0----->

1-------------------------%contacted-----------------66%----------100%---------50%----------0%---->

1--------------------------interviewed------------------1-------------0-------------1------------1----->

1-------------------------%interviewed---------------33%----------0%-----------50%----------100%-->

You could do the % under that, and you'd be good to go, right?

In a word, Normalize your table. Then this is stupid easy. Repeating fields are going to make your life miserable.

Took me a while to find it... and stop sitting on Itzik's book and actually read it. Got any good references for learning the hardert part of T-SQL queries...

"CTEs cannot be nested" Are you sure? http://stackoverflow.com/questions/7306191/how-to-nest-cte-properly

and what's with all those NOLOCK hints?

https://www.simple-talk.com/sql/database-administration/grant-fritcheys-sql-server-howlers/

I had this kind of fun just today on SSRS 2012. I went into the dataset and re-ran the query from within SSRS. that fixed it for some...

I need to change the code so the report selects data 14 days before and 14 days after the selected date.

WHERE [DateColumn] BETWEEN DATEADD(days,-14,@DateParameter) AND DATEADD(days,14,@DateParameter)

not sure about the sequence...

What are you trying to do? (Explain the business part, not the math.)

Can you give a really simple example? Do you have a table you're trying to join...

Short answer - you need to turn this into a totals query and group by everything but the date. Get MAX(Date). Or use a subquery to return only...

Maybe it's the lack of coffee or something, but the basic matrix is simple, but getting the % of Internal at the bottom as a pain. (I'm starting to think...

make a copy of the report.

in the new copy (for the restricted folks), change the parameter to single value. (turn off Allow Multiple Values).

I'm pretty sure you can leave everything...

Finally dug up Itzik's book on T-SQL 2008...

-- from p.458 "Inside SQL Server 2008 T-SQL Querying" By Itzik Ben-Gan

SELECT 01.empID,

CONVERT(VARCHAR(7), o1.ordMonth, 121) AS toMonth,

o1.qty AS qtyThisMonth,

SUM(o2.qty) AS totalQty,

CAST(AVG(1 * o2.qty)...

Check out this article by Dwain Camps...

https://www.simple-talk.com/sql/t-sql-programming/calculating-values-within-a-rolling-window-in-transact-sql/

there's an example using 2008 that doesn't use windowing functions.

This is my attempt at applying what he wrote... maybe it's because it's stupid late,...

I would probably do it this way:

Package---(1,M)--Contains--(M,1)--Items

CREATE TABLE Contents (

PackageID INT NOT NULL,

ItemID INT NOT NULL,

Qty INT

FOREIGN KEY fkItemID ItemID REFERENCES Item(ItemID),

FOREIGN KEY fkPkgID PackageID REFERENCES Package(PackageID));

I'm assuming that the...

To create a variable...

1. Under the Report menu, choose "Report Properties".

2. Click on the Variables Tab (in the left pane).

3. Click the Add button.

4. Give the variable a name.

5. click...

I created the variable to store the aggregate value to divide by. If you're doing "% of total" then you would store the total value in the variable, and...