I have to tell you that if you work with the right recruiter, you don't have to worry about AI HR bots, HR people, or whatever.  A lot of people...

p.p.s.  Almost forgot.  Sheet names that are weird or begin with a numeric digit must be encapsulated in single quotes along with the normal square brackets.  For example the sheet...

Probably not. The STRING_SPLIT function is relatively crippled for those that need...

p.s.  If the OP has a spreadsheet with just one header row, we'll need to do a little work but not much.  We'll make it so it's self-healing just like...

Ok... Demo time.

The first thing is to unzip and copy the spreadsheets from the attached SpreadSheets.zip file to the directory of your choice.  If the directory is something other than...

Actually, skip all of that.  Most of it just doesn't matter.  I'll be back soon with a demo from the presentation I give on the subject of "Automating "Excel Hell"".

OK, so what was the "silly" fix you employed?

I'll also state that it's a shame that...

I declared a variable to hold the file to pass to send mail task. I had a given a value like 'The value is generated by scrip task' ...

Heh... I guess that's true in a lot of cases.  You would think that...

Thank you for the extremely kind and generous words but we have a difference in languages and understanding here.  I've "talked" with Brahmanand through other methods and he is a...

THAT, good Sir, is the crux of the problem. 😉

Not sure that's...

Don't put your face in them. I stopped recording videos about 9 months ago. I'm going to get back on it, but change the format a bit. No more...

Production DB is (RTPOneReporting) DB Owner is 'sa'

Cross database ownership chaining is NOT enabled.

My repository DB is (JHMRReporting) DB Owner is 'dbo'

Cross database ownership chaining is NOT enabled.

My sp,...

Hi,

Assuming you have to add 3 columns with data to the existing 5million row table.

Following is the approach which you can use -

<li style="list-style-type: none;">

1. Extract the 5...