Why not create a UNIQUE constraint on the table and disallow the duplicates that way?

I may just spend some AmazonBucks on them. Ferrari's book looks really good. Might have to find some tutorials on MDX too, but one thing at a time.

Thanks...

Your English is fine! (the sample data is a huge help!)

Here's the sample data in a useable format:

SELECT 49 AS WeekNo, 28...

Sorry, can't remember if any windowing functions were available in 2008R2. Haven't used 2008 in an age (partly because windowing functions are super handy!)

I would probably bring all the data down into Access and index the tables -- after you have all the data. Then build your query there. When you're...

One option is to do this with a windowing function, like this:

SELECT ProductID

, Sales

, SUM(Sales) OVER (ORDER BY Sales

ROWS BETWEEN UNBOUNDED PRECEDING

AND CURRENT ROW) AS RunningTotal

FROM (SELECT 1 AS ProductID,...

Exercise your GoogleFu... There are examples all over the place, especially on the MS website...

http://msdn.microsoft.com/en-us/library/ms190307.aspx

See example B.

I'm still confused. Are you changing the backcolor of your cell with that? Otherwise, I'm afraid your approach doesn't make sense to me.

Something like this in the BackgroundColor...

I'm confused. When I put an indicator into my report, it gives me ranges for Red, Yellow, Green. I tried a couple to see if I could recreate...

What version of SQL Server are you using? If you're using 2012, you could use something like this as the source for your dataset:

SELECT

custID

,OrderID

,OrderDate

,LAG(OrderDate) OVER (PARTITION BY custID ORDER...

If you use windowing functions, this isn't that hard. Since I didn't understand how the create table/insert statements were related to your question, this is a somewhat generic answer.

It...

Seems you would do that in Excel... nothing to do with SSRS.

You might be able to do this by using a Tally table. Jeff Moden has a great article on it.

http://www.sqlservercentral.com/articles/T-SQL/62867/

Itzik Ben-Gan's book on Window functions is good.

SELECT FORMAT(2504,'0000000');