If you're using a Slowly Changing Dimension, and this is classwork, you might want to read up on them in Kimball's book. He explains how to do this in...

Probably should have done this with a CTE, but anyway, I think this works:

SELECT mx.SaleYear, mx.SaleWeek, mx.highestSale, sd.ProductID

FROM

(SELECT SaleYear

, SaleWeek

, MAX(Quantity) AS highestSale

FROM SalesData

GROUP BY SaleYear, SaleWeek) mx

INNER JOIN...

If you're using a normal database and not an SSAS cube, then you can use a Calendar table. Here's the article on it: http://www.sqlservercentral.com/articles/T-SQL/70482/

Basically, the Calendar table has a...

In a dataset that already exists within the ssrs 2008 r2 report I need execute

a stored procedure called StudentData and pass 3 parameter values to the stored procedure. The...

Yes, that's what I'm saying. I could be wrong, but I couldn't get it to work any other way. Would love an SSRS wizard to set me right.

No. do your own work. Read the article, try it, and post your SQL if you get stuck.

I think your only option is to do something like this:

IIF([State]='CA',NULL,[ValueColumn])

Are you doing this in T-SQL or in Reporting Services?

if you're using SSRS, use a Matrix. Otherwise, read this:

Using PIVOT and UNPIVOT

seeing that it will be around 1 AM, probably not. But if you post a simple description of what you're modeling and then your model (create table scripts with...

My problem is I do not know how to have the dataset call the stored procedure with the 3 parameter values and pass back the 5 different unique data values...

Output parameters are your friend:

http://technet.microsoft.com/en-us/library/ms187004(v=sql.105).aspx

Can you post a really brief description of what you're modeling and your table definitions on the part you're having trouble with? (start with only maybe two or three...

"You can get the job on the basis on your SQL certificate"... depends a lot on how big the pool of available SQL developers is in your area, I guess....

In the 2008 version, there's a whole chapter on Customizing Security.

Thanks SQLBuddy! Way to live up to your moniker! I'll check them out.