Viewing 8 posts - 1 through 8 (of 8 total)
GOTO's... ah where to start. In addition to everything said before me, I'll add:
July 19, 2021 at 3:30 pm
August 2, 2018 at 9:47 am
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...
August 2, 2018 at 5:57 am
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....
May 22, 2013 at 1:49 pm
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...
April 18, 2013 at 7:17 am
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)...
March 25, 2013 at 3:54 pm
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...
March 6, 2013 at 7:16 am
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...
March 5, 2013 at 8:57 am
Viewing 8 posts - 1 through 8 (of 8 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy