Mostly back to normal, day to day is pretty normal able to travel again etc...  Office location was moved to a less favorable location, slightly longer commute, no decent food...

Can you isolate it down to just the dynamic sql statement?  Like if you run just the EXEC sp_executesql on its own outside of a stored procedure and without all...

In all fairness it is fairly unintuitive that SQL server will let you begin named nested transaction even though it doesn't actually create a new transaction, not complain about it,...

It's pretty straight forward to do that in powershell as the first step in the script and periodically check for the file then succeed the step when it shows up...

Yes... and they're making an big deal about it.  ChatGPT is constantly providing incorrect answers about code and...

.Please no >_< .Leading commas I accept as a preference, but leading semicolons are another matter entirely, lol .Those are like...

Well one reason...

What command are you using to insert the data?

It should be pretty straight forward to take a list of table names and build a sql script that can run as a single query to grab the one with...

Totally understood on that... but do you suppose that they'll actually use your good code to "normalize the data" and store that normalized data in a database or store...

Are you familiar with quote qualified delimited files?

Text editors generally don't care about quote qualified which is why you're seeing the line breaks in Notepad++(if you turn on the View...

When dpads were still the go to on controllers, never been a fan of the thumb sticks.

Then just add a key to the address table they are insisting you use, can just be an identity.  And add a column on your application table to store that...

That would depend on whether you're running them through some...

Is this a serious article?