Thanks for your help guys.

One more thing I forgot to mention, all Id's dont have constant number of records or fields.

One id can have 5 records another can have 20 records, so I need...

Thanks Sergiy,

Your solution is great, but each id can have upto 20 to 30 records means that many different fields like name and address.

I'm thinking about something dynamic to get...

Iam using SQL reporting services, but I need SQL query to create this as view.

Thank you

ash

There is a field for date updated, so I can use it to select last updated record.

Thanks

ash

Record should have least number of nulls for columns 4 thru 6.

If you can't differentiate then select first one.

Thank you

ash