Has the view been refreshed when you run this?

That would work... but why would you want to do that?

You'll most likely have an id field (some sort of autonumber, but repeating). And you'll have a date column for the last entry... That'll be your key.

Come on Frank.. we haven't had a holly war in so long .

I'm curious to see what he's gonna answer to this. But here's one of his answer on a very similar topic :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=172998

I don't think you're a Monster Joe. You just have a way to be very direct about what you think... and I like that .

Nice link BTW.

I was here since the first post. I just didn't reply untill now cause I had nothing to say. We just say s-q-l here, but it's in french, therefore irrelevant...

Happy to hear that... what's the final transfer time after the modifications?

Good point .

Moo point often take a lot of space on this board .

You must have me confused... I never proposed the IIRC. What does it stand for??

Yes it's syntaxe only... but I preffer the read something that looks like an inner join. That way I can't miss the 2nd table in the query... But...

Nice variation... first time I see it.

Here's the kicker...

Compare colid to colid2 .

I know it's not perfect but the syscolumns handle the colid in strange way in functions and...