Programming and managing require two very different skill sets. My best managers were always people with sound judgment and good skills at organizing and supporting their people,...

I'd like a summer vacation, like when I was kid. Ten weeks off with nothing to do but figure out how to best fill up the day....

I have got to start proofreading better. My apologies.

The table being queried isn't 200 million rows, it's closer to 20 (TWENTY).

Also,...

... continued after hiccup/entry

exec stGetSales '38655|38677|90210', -- zip codes

...

Someone mentioned using joins to table variables as an alternative approach. We've gotten excellent results using that technique where we could declare that all parameters of the...

Hey Graeme 🙂 My wife is still in U.S. education (PreKindergarten-1st Grade) and it keeps getting scarier. Teachers are now expected not only to teach...

These things even out over time. Not everyone in the "younger generation" has it easy growing up, and not everyone who has it easy lacks a work ethic....

Hey lucian

Here is some code for doing parsing using a tally table. We usually have a pre-generated one in each db, but this code will run on...

I agree that Googling for answers to coding problems isn't cheating, anymore than buying a reference book for the same purpose would be cheating. More people should...

My existing parser function uses a tally table like that last example and runs pretty damn quick. The huge CPU performance difference I saw was in building...

Hey Wayne, I must be on drugs today. Or maybe I'm not and ought to be because of all the typos I'm making today. ...

Just to answer the rhetorical questions about building xml by wrapping tag constants around data, rather than use a "For XML" statement, we should remember that a lot of code...

Doh! Just realized you are doing a simple select, not an update. My bad.

Why not just put a test in a where clause instead of using the Case statement? That way you aren't even updating all the rows. This...

Good question, and a learning experience for me

I missed it too, not realizing that the underscore wouldn't catch 'C_us'. The lesson learned is that underscore as a...