First things first - we need to understand what you really mean by this:

I want email sent with the above data in html table format and only if col3 values...

This article[/url] looks good.

Kevin,

This design worries me. Can you please describe the business problem you're trying to solve? I would be willing to wager that what you're trying to do would...

I answered this already here:

For a minute I thought my post disappeared... then I realized you were double-posting. While I realize that you may feel that double-posting gets you...

I'm pretty sure Eirikur will shred my SQL, but this works:

SELECT MatchID

, MatchDate

, TeamID

, PrevMatch

, DaysElapsed

FROM (

-- get the difference in days between matches

SELECT MatchID

, MatchDate

, TeamID

, LAG(MatchDate,1) OVER (PARTITION...

The really short answer is to use a tablix with two columns (StartOfWeek, WorkHours) inside of a matrix with a ColumnGroup on MonthNumber.

Which means you need to add a calculated...

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...