GOTO's... ah where to start.  In addition to everything said before me, I'll add:

1. IMHO... GOTO's should ONLY be used (maybe) at the beginning of the code to check for...

Hi Adam,

I like your article, but I would recommend changing how you filter your dates.  Using the MONTH and YEAR functions can cause SQL to ignore any indexes...

I have no idea (maybe someone else here does) but your last 400 million rows would put your DID into negative numbers - assuming it is not an unsigned int....

This is a little off topic, but we now include a simple quiz with all of our job posts. Something like: "Here's a list of people, a list of...

I Love the SIGN function...

CASE WHEN fsq.SalesAmountQuota > frs.SalesAmount

THEN 1 ELSE CASE WHEN fsq.SalesAmountQuota = frs.SalesAmount

THEN 0 ELSE -1 END

END as Trend

Can be replaced with:

SIGN(fsq.SalesAmountQuota - frs.SalesAmount)...

Check out http://msdn.microsoft.com/en-us/library/windows/desktop/ms710963(v=vs.85).aspx

In your code:

retcode = SQLBindParameter(hStmtHandle,

output_blobs_.cur_pos,

SQL_PARAM_OUTPUT,

SQL_WCHAR,

SQL_WLONGVARCHAR,

0,

0,

(SQLPOINTER)output_blobs_.cur_blob,

0,

(SQLINTEGER*)&size

);

I think the 2nd parameter should be 2 and not output_blobs_.cur_pos, because...

Looking at Thomas' select statement made me think of one of my favorite functions, that (IMHO) doesn't get enough use: SIGN

Now, this only works here because there are no...