David, if you find a good solution to this question, please post it back here. I am also struggling with the lack of session-specific temp tables in Oracle to...

+1

<snip>

Jeff Moden (1/10/2016)

---

Also notice that I've removed the drops of the Temp Tables from the end of the code because that will actually slow SQL Server down a bit. ...

Interesting question. I learned something, b/c I don't use REPLICATE() for long strings.

The explanation from BOL is quite specific:

If string_expression is not of type varchar(max) or nvarchar(max), REPLICATE truncates...

Jeff Moden (1/7/2016)

---

First, thanks for responding. I had delete a whole...

Hi, Jeff, we're all still waiting for this super-duper magical emailing code you allege to have concocted!

:rolleyes:

Rich

<snip>

Hugo Kornelis (12/31/2015)

---

[Final note: yyyy-mm-dd is also an official ISO standard and supported for the newer data types, but the old data types for legacy reasons still support other formats...

You've probably got more material than you need by this point. This one's an old article, but I still find it useful to refer people to: https://www.simple-talk.com/sql/t-sql-programming/ten-common-sql-programming-mistakes/%5B/url%5D.

My guess is...

Alan.B (1/4/2016)

---

Except for recursive CTEs, CTEs and Subqueries are basically the same thing. I prefer CTEs for a couple things:

First, for nested queries. CTEs make nested queries much more readable...

One of my more common uses of CTEs is to pre-assign row-ordered values like ROW_NUMBER(), NTILE(), etc., which I can then aggregate on in a final select.

Any kind of grouping...

ScottPletcher (12/22/2015)

---

The really tricky part of this is deciding how you want to handle Feb 29 birthdays: in non-leap years, is that birthday Feb 28 or Mar 1? In...

DOH, misread the question: I thought I was supposed to return each year's HR and the delta from the previous year.

Tough to code properly when the brain is impatient...

Rich

It wasn't clear to me (I maybe skipped something posted): have you definitely identified the CPU pressure as originating from SQL Server? Are there other, non-SQL processes on the...

"googol"

Not trying to be pedantic, but I do like...

Following up on Thomas Rushton's suggestion, here are 3 links I've had bookmarked for quite some time for ideas to circumvent the lack of Agent in SQL Express. Haven't...