Thanks again Tim, life saver! Thanks everyone for all the help, i think this case is closed for now.

Thanks Ian, that is very true i need to think about that as it might cause me some issues.

That's it, thanks for all your replies. Ken well spotted i moved the where clause and it gave me thecorrect results. Thanks again

I tried removing "Disability" from the top select query but still get the below error. I also remove the * and added the same columns from the top select query...

Hi I will look at this now but i don't think i can use distinct on all the columns i'm using which i why i ended up with the following....

Just in case anyone is reading my last post and thinks i have resolved my issue, i haven't i was thanking tim for some information in a post he wrote....

Thanks Timothy that helped a lot. I will investigate so of the other posts on this matter. It's nice to learn new things that make SQL more easy to manage...

Hi Again,

I have executed this query in Full SQL 2005 Server and it worked! I got the row number i expected. As long as the data is consitent and not...

Hi, thanks for your reply. I am working through it now to make sure i understand what is happening.

When i first run it i get this error "The OVER SQL...

Hello Again,

I need some clarity on this max() function I am using. As you will see from the above posts I have lots of data in a badly designed table....

Thanks for that. I removed the destination and set it up again and it worked with no warnings. Thanks again.

The problem is the design of the table but it's the best i have to work with as i have no control over design or the data populating it.

The...

Hi, I tried to find a good ordering field but have nothing.

I'm not really sure what you could use to get this using Top 1. Am i right...

Thanks for that, will try it out and let you know how i get on.

Thanks for the reply.

There are many rows with the same company details so a company might appear 50 + times in the table but i only want one row...