Hey Oscar, this is SQL Server, not Oracle.

AFAIK there is no such thing like ROWID in SQL Server.

If you haven't bought it right now, it might be a good...

Maybe I understood Brian Knight's post wrong, but there is a second chance to answer. At least I had to answer a second time.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Should save headaches.

I don't answer in the newsletter, but like the button to bring me to the QOD page in a new browser instance.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Are you telling you don't have a family life after 10 PM when coming home from working 14 hours?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Sorry, I guess nothing you really want to hear, but I had the same problems.

I have a mixture of german and english SQL installation here, and I bet it...

You mean the Douglas Adams' book?

If so, wasn't this character the robot?

Me thinks the British have served the art of insulting very well in having black puddding and serving warm...

Yes, you're right.

If I were aware that Noel already answered I wouldn't have posted at all.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

TIT ????

TIT Taste in Television (Married with Children)

TIT Teacher in Training

TIT Technician Induced Trouble

TIT Tenchi In Tokyo (anime)...

I would say, that EXISTS almost always performs better, because it can stop once the logical test is true, while COUNT walks through the whole resultset, even after the condition...

It might be that I don't understand your question correctly, but you're talking about one of the fundamental principles of relational databases.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Ah yes, ask the user what he wants and he starts thinking (maybe the first time) on what he's doing the whole day

In another forum I...

Oh sorry,

Something like this should work

On Error Resume Next

....

your db statement

Select Case Err.Number

Case.....

    Response.Redirect somewhere else

End Select

I bet there are lots of examples...

quote:

---

As a DBA I expect all submitted code to be commented.

The comments should detail up front which tables are going to be...

No, you're not wrong, but please use this thread to complain

http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=19291

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Would this help?

http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=18138

http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=18119

Frank

http://www.insidesql.de

http://www.familienzirkus.de