Brandie Tarvin (10/30/2015)

---

Someone needs to have a talk with that David Burrows guy. He's talking crazy in another thread. Like suggesting I could use SQL Server tables to solve a...

LOL Thanks Eirikur 😀

Brandie Tarvin (10/30/2015)

---

David Burrows (10/30/2015)

---

As an alternative you could define a DataTable to contain JobName and Response columns, add rows using a loop (similar to above) and output to a...

Just a guess but if you had pairs of labels (ie J1,J1a,J2,J2a etc) to hold job name and response respectively then

string[] MyJobs = SvrBJobNames.Split(',');

Label[] JobNameLabels = {J1,J2,J3,J4,J5};

Label[] JobResponseLabels = {J1A,J2A,J3A,J4A,J5A};

for...

Or

string[] MyJobs = SvrBJobNames.Split(',');

if there are no empty entries 😉

Also you need to put the WHENs in the order you want them tested

ie

WHEN A.[Measure] IN ('RTT-01','RTT-04','RTT-07') AND A.Value NOT LIKE '%[0-9.]%' THEN ''

WHEN A.[Measure] IN ('RTT-01','RTT-04','RTT-07') AND A.Value >...

Sorry forgot to mention that you will have...

ChrisM's solution is correct.

The error will be due to inconsistances between your Measures and numeric/nonnumeric Values

You will need to add extra WHEN conditions to avoid implicit cast errors

i.e

WHEN A.[Measure]...

ChrisM@Work (10/1/2015)

---

David Burrows (10/1/2015)

---

Many many...

Many many moons ago when...

Poor performance :angry:

But....

WITH

cte1 (Dt,Item,RowNo) AS (

SELECT Dt,Item,ROW_NUMBER() OVER (ORDER BY Dt ASC)

...

DECLARE @value int = 2;

WITH cte AS (

SELECT Dt,Item,

ROW_NUMBER() OVER (ORDER BY Dt ASC) -

ROW_NUMBER() OVER (PARTITION BY Item ORDER BY Dt ASC) AS [Grp]

FROM #tab1 t

),

...

In Tablix make blue section the detail group and the yellow section group header (Phase Code)

See attached sample.

Is this for existing allocated reference number?

take max(reference number) from the table +1 for all rows where reference_nbr column...

Did upgrade 7 to 10 at home, quick and no problems (after I remembered to remove anti virus software), switched off Advertising ID and Cortana.

I still hate the interface (hated...