To be honest, I'll never understand the idea of creating a Temp Table and then deleting rows from it.

I was at a company that hired a new IT director. He made it very clear at the beginning that he wanted to bring in his own people, so...

I wrote an entire book on this topic, based on the work I did at AIRMICS. Look at ISO-11179 and the Metadata Committee stuff. We found  that with good...

If the looping is necessary, just add a column (maybe call it ProcessOrder) to the temp table and populate it with ROW_NUMBER() OVER (ORDER BY ID).

Also, to support Thom on his claim that 3 and 4 part naming has been deprecated, take a look at the following article written by a really smart...

Now THERE'S and SQL "Oolie" if I ever saw one!  Nice job, Mr. Collins.  And, yep, it IS clearly documented.

This topic interests me intensely. I've been reading about software development trends for many years, with a view to improve myself and to suggest better ways for those I...

Thanks, Ryan.

Thought I'd throw one more out there.  It doesn't spell "community", but the community needs to know. 😀

https://www.postgresql.org/docs/

From the Article:

---

"A little more than 12 months into the new gig, I finally started to have a mind shift and look more earnestly for a Postgres family....

I've found that a lot of people just don't give a damn.

I recently did a peer review of some rather length but vertically code where the table name was simply...

...but I don't think I'll ever be converted to leading commas - I think that's at least partly because I'm an English language pedant and believe that a comma...

Nor would I change the Clustered Index...

As a bit of a sidebar, I've not yet found an online video course for beginners that I actually like or think that does the job adequately. 🙁

1.  Microsoft's new journey and phase is causing many well developed areas of skills to be discarded.  By the time we hit SQL Server 2016 the exams were robust...

Maybe for your query but might crush everyone else's performance.

Looking at the graphic that was...