It's like the ORDER BY in the second query.  Do the ORDER BY using the column aliases for the SUMs rather than the SUMS themselves.

The reason why the code doesn't produce an error can be found in the execution plan.  Apparently, since SQL knows there's only 1 row, it never executes the ORDER BY. ...

Gosh... thanks for the very kind words but I'm far...

I've never seen anything like that from a CU before.  What happens when you re-enable the jobs?

His name is "Hallengren". 😉

What guidance???  Be specific because, if they have to do with indexes, MS finally figured out what a...

Building a new logic may take time plus avoiding certain characters, or keeping a conversion table and when there no resource available, why don't you expand the field itself. ...

Such formatting can, indeed, be done in a query or stored procedure.  My "Morning Report" emails I get from the servers are proof...

Gosh... thanks for the very kind words but I'm far from perfect. ...

You'd think someone working in it would know how to ask for help properly..... developer just sent me.

"the UAT ETL server seems to be really slow this morning.  Any...

I totally agree with Grant.  IMHO, what he's recommending (AD Groups a.k.a. Active Directory Groups) is the only way to go on something like this.

I can vouch for the settings that Johan mentions because those are the ones that changed my life for backups years ago.  However, I've found that they actually make restores...

Heh... Bing, Bard, BOOM!  I've done some simple but non-basic tests on both and they've both failed miserably.  Either the provide the wrong answer that wouldn't even run, produced the...

Hi Jeff,

I do not have force parameterization turned on. The sp passes two parameters as input. One is productcode varchar and locationid int. I checked the data and there...

Ha!

And we can keep going. Don't let Jeff get started on fragmentation. Don't let me get started...

Just to ask the question, the servers aren't set to automatically shut down for a part of the day, are they?

If not, you might want to make a call to...