Heh... that level was...

My basic trouble with hackathons in a company is... why do they actually need one to begin with?  It seems like that's an admission that they don't embrace innovation during...

He means "Readily Consumable" data.  Please see the article at the first link below...

Yes, you would need to download and install the ACE drivers.  If you use the quiet mode, you can do it without have to make the mistaken of uninstalling all...

That was a super fast load process... Just wanted to thanks again ... very impressive and well documented SP

Just a side question, what process do you choose to load...

Your code has an rCTE(Recursive CTE) in it that is reading 1 row at a time for a total of 21.45 million rows probably due to the result of an...

I have to admit that I miss in-person events because, as good as they can be, discussions even on things like teams still don't have the "feel" and "serendipity" of...

That might also be the reason why they've done the RBAR thing in the trigger.  They don't want to have everything during and Insert or Update roll back...

As it's written, it returns either a NULL or and empty string.  I think someone forgot to complete the 2nd operand of the substring, which should probably equate...

That might also be the reason why they've done the RBAR thing in the trigger.  They don't want to have everything during and Insert or Update roll back if something...

I would think that a trigger to try to catch errors in other places would be mostly useless for a lot of code but I don't see anything wrong with...

If it's for a table with a large number of columns and it's an...

Brief tangent into real SQL stuff...

Has anyone ever heard of table triggers not firing for every row if you do set-based updates to records?

Our vendor sent us code for...

Ok.  Mostly done.  We still need to add some "pretty" error handling and the file move-after-imported thing but this is working quite nicely and it does tolerate errors along with...

Sorry. I've not had much time to work on this. Working on it now. Having some fairly good success. I'm also making sure that it's fully documented so that you...