also are you sure the dates are being stored that way? dd/mm/yy? That's odd.

Need more info. Table schema perhaps w/ some scripts for loading data in them and perhaps the desired results.

The solution has been successfully consumed. Thanks.

I did notice that when using the cte functionality you must not have any code between any of the cte code. So i suppose...

Sorry i did not. I was hung up on the id=1 in the where so i assumed it was returning one rec. Sorry. I'm going to wrap my mind around...

attached if the result set. Highlighted is what should be returned.

i'm trying to paste the ooutput from excel w the hioghlighterd records but i can't. Forgive me for being a newbie w/ the formatting of these posts.

i need one record returned per first, last, and zip.

The idea here is someone wants the data from this table. Well they want the records who have the most info...

When adding the following three samples to your data, which one should be displayed (each one has values in two out of three columns)? Either, but just one of...

nevermind it isn't. That sucks

That really doesn't apply in this instance however i agree w/ u on typical dynamic sql querries.

So i mentioned i'm getting the below warning

Invalid column name 'identitycol'.

I think i figured...

Thanks. 2 things.

1) i keep getting the following warning when i run it. Do you know why and is it effecting my result st?

Msg 207, Level 16, State 1, Line...

disregard. there was an error in my design.

by the way. The table sizes i'm dealing w in this instance are in the 10+ millions. My fact table at the moment has 15 million record and will grow...

i went ahead and did the remove the xls tne overwrite it w template then write the data to the file shell game.

Seems a bit much though just to overwrite...

i took jacks advise for simplicity sake and it is working.

I will however read your articles thuroughly because i can see how this is something that i will need to...