Have a look at EXISTS in BOL. If I understand you right, this should do what you want.

Why bother with something sophisticated, when good thing can be easy?

See, if this helps:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=146326

See, if this helps:

http://www.microsoft.com/sql/techinfo/administration/2000/rosetta.asp

http://www.microsoft.com/technet/prodtechnol/sql/2000/plan/ssmsam.mspx

http://www.microsoft.com/sql/techinfo/administration/2000/scalability.asp

http://www.wintercorp.com/

MS has a bunch of case studies of VLDB customers on their site. Unfortunately I can't find the link right now. A friend...

The discussion here seems to say that none of that matters and many physical log files are treated as one logical file.

Yes, SQL Server internally treats it as one virtual...

I wish you can relate your message to some of my clients -NOT to focus so much on performance....

I know, I know...

Performance definitely is important, but it is NOT...

Sorry, I'm the wrong person for this. I never really cared about cars. I know where to fill up gasoline, where to look for oil and that's it. For me...

Do you have the Haynes car manuals in Germany?

Sorry, I don't understand

Brilliant!

Thanks, Razvan!

And honestly, it wouldn't really be nice. I think, there is a lot of work to do in the German SQL Server community. More than in other countries. And...

One might argue that this is a violation of Codd's rules 5, 8, 9, 10, 11 and 12. You can read about them for example here:

http://www.sqlservercentral.com/columnists/fkalis/coddsrules.asp

To me it seems...

Hm, just out of curiosity, where do you see here derived column names in the WHERE clause?

Hey, I'm not insulted! I would be, if I were to drive such a thing some call a car

No, I think, the trabby...

papier mache car made by the East Germans

Hm, I guess this would annoy quite a few people as there is no such distinction anymore here,...

< snip dramatic pause to emphasize on the irony >

... I mean...

Here we go http://www.insidesql.de/content/view/179/

Thanks, Kenneth!