Use cross tabs with the OVER clause.

SELECT *,

SUM(CASE WHEN Status = 'Passed' THEN NumberOfTasks ELSE 0 END) OVER(PARTITION BY Cycle) AS [Passed],

SUM(CASE...

Check the defaults for your parameters or avoid your report from executing automatically.

The error indicates problems when creating your dates. Try this formulas instead.

set @START_DATE = DATEADD(MM, @START_MONTH - 1, @START_YEAR);

set @END_DATE = DATEADD(MM, CAST(@END_MONTH AS int), @END_YEAR);

Review the parameters you're sending...

Now, that's a great idea. I'm not...

Jeff Moden (3/18/2016)

---

Luis Cazares (3/18/2016)

---

I agree with all that has been said. But, maybe you could make it work implementing Full-Text Search? This is only if you already have problems...

Eirikur Eiriksson (3/18/2016)

---

Luis Cazares (3/18/2016)

---

Define "just after the full backups". It happens when the...

If you're using a query, you could get the calculation there.

COUNT(DISTINCT wh) OVER(PARTITION BY Name, OrderNum) AS WH_Count

I'm not sure how to do it in SSRS.

Define "just after the full backups". It happens when the query is first run...

I haven't met a read-only database, so you could probably compare backups.

I agree with all that has been said. But, maybe you could make it work implementing Full-Text Search? This is only if you already have problems with this data, if...

spaghettidba (3/18/2016)

---

Me too, but for some reason it didn't catch all the...

Just a word of advice.

This will become annoying in the future, you'll end with hundreds of tables all with the same structure. You'd be better by creating a table with...

I prefer to use a nice pattern instead of learning ASCII values. But that's just me. 😀

SELECT *

FROM @sampleData AS s

CROSS APPLY (

SELECT Name = (

SELECT SUBSTRING(s.name, number, 1) AS...

g.maxfield (3/18/2016)

---

Looks like another version error issue! How do we know until we test the code? Could the version number be added to the Question then in that...

rcooper 78099 (3/17/2016)

---

Really?

You said: You're missing the closing parenthesis for your cte.

You also have an additional semi-colon at the start and a missing semi-colon at the end of your...