For TRUE, you need (TRUE) and (TRUE). (TRUE) and (Unknown) means you don't know if you have 2 trues or one of each, so the answer is Unknown.

Wayne,

I was tempted to go with a Mac as well. We got one for the kids, but one thing I've noticed with them each having non-admin accounts, is that some...

Good luck and congrats on the job.

Typically in this case I've moved data into some staging table to hold it there. Then I'd do an update, joining the staging table...

It doesn't in SS2000. Possibly in ss2k5, but the easy way is to build a table and add a line of code to the stored proc to log each run....

Good luck and let us know how you do!

The code was obfuscated in previous versions and there were some procs to decrypt the code. I'm not sure if this applies in SQL Server 2005.

http://www.sql-shield.com/decrypt-stored-procedure.html

Please don't cross post. Answered in another thread.

AND evaluates two expressions.

(exp 1) and (exp 2)

If exp1 evaluates to false, it doesn't matter if exp 2 is true, false, or unknown. The entire expression is false. It's basic...

Will, when massaging out issues, are you working the entire table at a time? I could still see the need for a PK, even a surrogate one to allow you...

These can be hard to troubleshoot. It's an issue with the service account running SQL Server not being able to validate credentials. The service might not have an SPN in...

The way you have things written, it's a very minor overhead. You are only running one statement.

If things are slow, be sure that you have good indexes on this table....

No idea where to get avatars. I've usually snagged photos and cropped/blurred them. My current one is my daughter and I in the car, but you can't make us out.

Yours...

Classes aren't required. The books aren't really either (and that coming from an author!), but the books do help you focus and go in some order for things relevant for...

No pay. It's the price of having a wife that loves horses.

Hey, I mess up the QODs as well as edit the content here.

I installed Red Hat on an old laptop a couple years ago. I didn't really have any issue with the install, the Browser and email clients worked fine.

But they weren't...