Thanks, I do use this, but this is...

Progress update,

Sorry that I can not post the actual code and or situation.

As allready described the code has to be altered before it can be executed.

There were some suggestions how...

Jason A. Long (10/3/2015)

---

ben.brugman (10/2/2015)

---

Not unattainable at all... The only thing SSRS does...

Sorry, I think I was asking for something which is not obtainable.

And I wasn't clear enough in my question.

Because I want the code to cut and paste between the SSRS...

Good anwser.

I would like to make a little change.

Maybe it is...

Hello Luis Cazaras and others:

This afternoon I got a request for a Pivot 'script', which would adjust to changes in a table. So I remembered the given solution on the...

First of all thanks Jacob and Mister Magoo, for your time and attention.

The solution method for both and mine (see below) are the same, but I allready learned something from...

First of all see the code below.

I have made a number of assumptions.

Because of the constructs you have used I assume that days are important.

So I assumed that I could...

Hello Luis

(and ITU_dk2012)

The first time I anwsered, the anwser got lost because my regular work interrupted and when 'posting the anwser' this was 'too late'. Second time I shortened the...

Depending on the query there is a processing order of the rows of a table. It is not determined which is the first row to be processed and which is...

John Mitchell-245523 (9/3/2015)

---

You're confusing dates with date formats. Since this is a SQL Server forum, let's talk about SQL Server, which stores dates internally as a number (two numbers,...

"Proper date/time data".

Problem is that there is...

Thanks Scott,

More elegant, more compact and it did uncover a mistake in my solution.

(My parent_column was not correct, I had not noticed that yet.).

Thanks,

Ben

Edit:

Second check,

, COL_NAME(parent_object_id, parent_column_id) as Parent_column

Does appear...

Another possibility,

I hijacked the code from Luis for the generation of the table.

Test for correct date is ommitted. (To keep it simple).

I reformatted the data in such a format that...

Hello All,

Allthough not completely elegant, I think I found a solution (???) to the stated problem.

What I do not understand is who is the parent and who is the child.

With...