bzoom100 (1/5/2017)

---

Within the same table I need to take the ApplicationNumber value where the Type value = 54 and place it into the ProjectNumber value where the Type value =...

Have at look at your Reporting Services Log, this should give a reason as to why the service didn't start.If you're unsure after looking at them, postt he part of...

This sound like what you're after are cascading parameters, which is easily possible in SSRS, yes. Note, however, that your report would only have one format. if you want to...

bzoom100 (1/5/2017)

---

One more thing:

The report parameters allow me to choose multiple applications types and multiple status types.

If I select one of each it runs ok. If I select one application...

Would that not just provide one continuous string instead?

I'm sure sure this is particularly pretty, and it...

You need to use a LEFT JOIN instead. Taken from FROM (Transact-SQL):

msdn

---

LEFT [ OUTER ]

Specifies that all rows from the left table not meeting the join condition are included in...

When you say not responding what do you mean? Do you mean that a report isn't loading, or that the service isn't starting up?

If the report isn't loading, that would...

The PDF export is awful at best for alignment. I tend to have to create a different report if I want one that is web based, and one that is...

A better solution for you:

DECLARE @StartDate DATE, @EndDate DATE;

SET @StartDate = '01-Apr-2016';

SET @EndDate = '30-Apr-2016';

DECLARE @Weekdays INT;

WITH

L0 AS(SELECT 1 AS c UNION ALL SELECT...

This is an awful way to do this. Loop structures are incredibly slow in SQL.

Also, I would expect your dataset be different with the while block, you're changing your start...

Without having sample data that includes the problem this is going to be very difficult for any of us to trouble shoot.

All I can tell you is that somewhere you...

Can you provide DDL and DLM. Your sample data has a varying amount of columns. You can't have a table which has different numbers of columns for different rows, SQL...

Luis Cazares (1/4/2017)

---

Thom A (1/4/2017)

---

Eric M Russell (1/4/2017)

---

As a side note, it would be great if all valid codes could be pre-loaded into a primary keyed master table, then data...

We definitely need DDL and DLM for this one and more logic. As Kevin said, why Adam 1 - 5. What about Adam 6?

I've given you a sample DDL, which...

Eric M Russell (1/4/2017)

---

As a side note, it would be great if all valid codes could be pre-loaded into a primary keyed master table, then data validation could be enforced...