From the Article:

---

"I'd love to be able to insert data into a table, have it not available as a live value until committed on other nodes, and avoid locking...

I have found many examples how to zip ziles, but is there  native to P/S how to create multiple zip files based upon a parm to split them...

I have found many examples how to zip ziles, but is there  native to P/S how to create multiple zip files based upon a parm to split them based...

With the understanding that there are many dialects of "SQL" and that (especially) functions and the UPDATE statement vary widely in MySQL, SQL Server, MS Access, Oracle, Sybase, Informix, Postgres,...

I agree with Phil.  You can kick your own butt if you want (heh... I've got a sore butt from doing the same) but you learned something different and then...

I'm thinking that they broke something in the process.  I get the load failure in the light pink strip even on this very post and every post.  So far as...

Just in case there are any doubters, here's the code to build a 10 million row test table... don';t let that scare you.  It takes a little over 5 seconds...

I need to change the numeric format into 'AM/PM' format in CONCAT function (I use SSMS v 18.5.1)

Here is my formula. RCLDTE - is a date and RCLTIM is...

If you store times as integers, it makes life much easier if you have a time table containing all the formats you need, however, if you need to just...

Congrats, Jeff. Quite an achievement. I used to try and keep ahead, but haven't bothered.

Now I wonder where I get to 1mm first. Here or in miles flown. At...

Stop and think about what a LEFT OUTER JOIN is.

Like I said, a Left Outer join on the pertinent columns.

Thank you, kind Sir and thank you and all the denizens of this fine forum...

You've got it pretty well mapped out.  Like I said, pick the table that has the the primary unique information in it an left join to that to form your...

Thanks for the screen shot and the very kind words.  I aim to please... I sometimes miss but I'm always aimin'. 😀