Hi,

I just setup logs and tried again. This is the result:

Microsoft (R) SQL Server Execute Package Utility

Version 9.00.4035.00 for 32-bit

Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

Started: 2:50:50 PM

DTExec:...

Hello and thanks for all of your input, the more i learn the more i enjoy workign with SQL. Old hand i am going to look at what you mentioned...

Thanks for your replies. I should explain that I am ok with adding SQL queries to my code but not so good with the inn’s and out's of setting this...

Thanks for the reply. I read up on that but two things don't makes sense on that being the issue. Firstly i used the same query from data in the...

Thanks for yyour replies. Yes the data in the other columns for the duplicates are different but this doesn't matter i don't care which one i grab.

Someone on another forum...

That worked great. Thanks for the help.

Hi Again,

I have looked at the Min, max, avg etc but they appear to all be related to columns that are numbers, where as the fields i am using are...

Hi, and thanks Atif & Paul for your detailed input, Paul i posted this reply before i saw what you had wrote, great explanation. I do see where your coming...

I am applying it to DISTINCT ilr.person_code but i would need to have access to all the other columns related to the results that the distinct defines. Maybe there is...

Can you not just distinct on one column only then display the rest of the columns based on the results for the distinct column person_code?

Seems crazy i can't get the...

Hey, thanks for that i tweaked ti and got the result i needed. Thanks again

Hey Flo,

I'm still not getting it right. i had the -- lines for personal comments to reference the tables those fields need to be inserted. I took them all out...

Hi Flo,

The tables i have provided are the exact replication of what i have. The demo code you setup has been replicated because the logic i think will work. Of...

Hi,

Not a stupid question, it is to move data from one table into two tables actually but in one of the two table wce_contact, there needs to be two rows...

Hi Again,

Ok, here it is, the sample code i gave you was a mini replication of what i need to do, the field names and stuff are diffrent but i...