That is a scary thought to most people.  Change!

It's Scary how your culture affects your day-to-day interactions with your co-workers.

that is correct, Thanks John

why are you using: ( 'LAST_ORDER_DATE')
('LAST_ORDER_DATE' >= convert(datetime,'20170601',103))
AND 
('LAST_ORDER_DATE' < convert(datetime,'20170930',103))

I would have thought it would be: (LAST_ORDER_DATE)
(LAST_ORDER_DATE >= convert(datetime,'20170601',103))
AND 
(LAST_ORDER_DATE < convert(datetime,'20170930',103))

I had to change the CTE used to query the data out of the table. The PCT Free calc was not correct.

replace

CONVERT(Numeric(18, 1), 100 -...

I used the script at the bottom of the article. There was no terms table in the script so I used the test in the article. The only...

so I am getting an error:

An error occurred while setting up a binding for the "text" column. The binding status was "DT_NTEXT".

any suggestions?

I am on Windows 7 Pro, Sql Server...

the 2005 stored procs that modify system config values, and go out to AD or the server registry and disk subsystem. Basically the ones that can reach outside the...

I find the Ned Hermann Brain Dominance model a better predictor of behaiviour. The model describes four quadrants:

http://en.wikipedia.org/wiki/Herrmann_Brain_Dominance_Instrument

and assigns a role-based strength rating to each quadrant for a...

What rights on the server does the account that is running the agent have? You may have access but does the account that is running the agent

Thanks Craig!

Thanks!

it runs fine on my SS2012 and SS2008R2 dev databases. It just doesn't run on production. 🙁

check writes to tempdb the tipping point might be a working table set that has to be flushed to tempdb because of memory constraints. This is a real...

can't index a table variable