Jeff, I've been off this site for several years, came back today to check whether the thread for "are the posted questions getting worse?" was still alive and kicking.  14...

Thanks, Steve!  I've been away from SSC for a number of years, and I wasn't trying to note my return by being a pedantic twit.

Mostly, I was dropping the comment...

Though only if you have imported pandas as "pd"....

That's a great explanation and amplification of the query, thank you.  I made a "mistake" in my simplified example, as my original project table does in fact have a PK...

Jeffrey thank you and a sheepish apology for my not checking BOL first!

🙂

That wording is unusually clear and definitive, isn't it?

Happy New Year!

Rich

colin.frame (9/29/2016)

---

Thanks George. That triggered a further bit of research.

The puzzle for me was where the extra decimal places came from in the AVG result. I've...

Steve, in your explanation, did you mean to say "This is offset by -1" instead of "by 1"? Or maybe by "offset" you meant the successive values of the...

As I read through the notes, I would like to voice an unspoken but assumed point underlying the discussion: technical staff must know how to communicate with non-technical staff --...

"Prodded"????

My first thought on reading this was "oh, dear, Steve just shot a pork chop at Jeff Moden"! 😀

Rich

sknox (9/9/2016)

---

Good question, but the explanation is incomplete. Precision is only half of the story, the other being scale.

1.0 can fit in a number with precision of 1, if the...

About BI tools:

I've run SSRS and been working 6 months with Tableau. They are (and are intended to be) very different products. Tableau wins hands down for interactive...

Careful with that cursor definition: I had a horrible issue with backups never being executed using a solution much like this. Although a query from sys.databases returned the correct...

TomThomson (4/6/2016)

---

Ed Wagner (4/6/2016)

---

TomThomson (4/6/2016)

---

It was however easy to see which of them was the one that was wanted, just by looking at the wording - it was the only...

Hugo Kornelis (4/7/2016)

---

Nor should you. In production code, I would always write out the explicit intent instead...

Funny, I've had the reverse problem migrating to using Toad for Oracle: where is everything I know in SSMS? Chacun a son gout, as they say. 🙂

Here's an...