Just to clarify, do you just need the company information for companies meeting one of those criteria, or do you want the reason (expired offer, no offer) included in the...

It's a statement type often employed in what is called the "quirky update" method of calculating a running total.

It basically leverages an odd behavior of SET when used in UPDATEs,...

That would be the correct logic.

You'll have to deal with the fact that the number of closed purchase orders and the total number of purchase orders will be integers, so...

It seems the second rule listed serves no purpose, if I understand this correctly.

The case with the same name and email, but different phone is handled by the third.

The case...

There are a couple reasons this might happen.

First, if person_id in the table in the subquery is NULL for any row, then no rows will be returned when using...

I got an identical request from a client a couple years ago, where they had multiple client databases on the same instance, and had to give their clients some SQL...

If we're talking about the values for Size and Space Available when you right-click a database and look at the General tab in Properties, then yes, the value for Size...

I wouldn't worry too much about using THROW, honestly. I thought it was worth mentioning that Microsoft recommends using THROW for new applications, but that isn't something I've bothered implementing...

No problem! I'm glad to help.

Yes, if that is the code within your CATCH block, the reason it's not failing the job is because no error is actually being raised....

Error handling within SQL Server 2000 is pretty limited, but there's a decent article describing what can be done here: http://www.techrepublic.com/article/understanding-error-handling-in-sql-server-2000/

As for TRY...CATCH, you do need to include code in...

There may be more elegant ways to do this, but it's late so I'm doing this the first way that occurs to me 🙂

The following should get you the desired...

Just from a quick glance, it looks like in the one that doesn't work the opening parenthesis for the subquery doesn't have a corresponding closing parenthesis (as a hint of...

Hmmm....that WHERE clause you said threw a syntax error works for me. I'd guess there's something else in the statement that's causing some issues.

Alvin's should also work if you remove...

If you want to get an IO profile of your workload, one thing you could do is set up a job to pull the information from sys.dm_io_virtual_file_stats on a regular...

The main point of having available unused space is to prevent costly autogrowth events.

So, let's say you have a database file with just one data file and one log file....