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

It is possible to set Language for a connection.

Or you can also set Language for an account.

But from experience I am familliar with a lot of problems when the format...

See :

http://www.karaszi.com/sqlserver/info_datetime.asp

The ultimate guide to the datetime datatypes.

This explains the datetime datatypes very extensively. Far better than I could anwser your question.

Ben

Used to generate a large number of rows.

L0..L9 are used to generate a large number of rows.

The lower parts are used to generate a specific 'code' in this case a...

A sepperate thread has been created, to 'continue' the discussion about how constraints can prevent certain actions to be performed.

See:

Merge Two Clients

Ben

Thank you, Ben

Hello All, I have had a rough week*) and not the oppertunity to reply.

Sorry for that.

The original question how to delete a duplicate row has been answered extensively enough. In...