Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,951 through 7,965 (of 59,098 total)

Reply To: Validating meta data of xls file

David Burrows wrote:
Phil Parkin wrote:
Unzipping files is natively available in .NET, so there should be no need to install additional software.
See here for more info.
I was thinking the same and there...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 8, 2020 at 8:02 pm

#3713788
Reply To: Validating meta data of xls file

I know I don't have to check on the CLR thing... I don't use them. 😀
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 8, 2020 at 7:59 pm

#3713785
Reply To: Validating meta data of xls file

Phil Parkin wrote:
Unzipping files is natively available in .NET, so there should be no need to install additional software.
See here for more info.
Just to be sure, my solution didn't include...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 8, 2020 at 5:06 pm

#3713699
Reply To: Validating meta data of xls file

Eirikur Eiriksson wrote:
David Burrows wrote:
Eirikur Eiriksson wrote:
David Burrows wrote:
Eirikur Eiriksson wrote:
Phil Parkin wrote:
David Burrows wrote:
This is why I moved away from SSIS and ACE for spreadsheets with mixed data (ie numeric and alphanumeric) in the same column,...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 8, 2020 at 5:02 pm

#3713693
Reply To: Validating meta data of xls file

Phil Parkin wrote:
Jeff, thank you for taking the time to write all of this stuff out.
Importing from Excel using SSIS is almost always a massive pain, so I am going to...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 8, 2020 at 4:56 pm

#3713686
Reply To: How to get highest bonus and second highest bnus paid freelancer for each group

Heh... can you put the Create Table statement back in?

--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 8, 2020 at 5:02 am

#3713489
Reply To: How to get highest bonus and second highest bnus paid freelancer for each group

Your test data only has one person per group.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 8, 2020 at 4:52 am

#3713486
Reply To: Great Writers Get Hired

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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 8, 2020 at 4:40 am

#3713485
Reply To: Validating meta data of xls file

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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 8, 2020 at 4:33 am

#3713481
Reply To: Tally OH! An Improved SQL 8K “CSV Splitter” Function

corey lawson wrote:
Hey, Jeff, will you update this yet again to include the new split_string() function in SQL Server 2016+?
Probably not. The STRING_SPLIT function is relatively crippled for those that need...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 8, 2020 at 3:33 am

#3713475
Reply To: Validating meta data of xls file

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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 8, 2020 at 2:57 am

#3713467
Reply To: Validating meta data of xls file

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...
Attachments:
You must be logged in to view attached files.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 8, 2020 at 2:33 am

#3713464
Reply To: Validating meta data of xls file

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"".

--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 8, 2020 at 1:23 am

#3713454
Reply To: Validating meta data of xls file

Phil Parkin wrote:
Jeff Moden wrote:
Charmer wrote:
Finally, issue is fixed which was a silly and it's done. 🙂
OK, so what was the "silly" fix you employed?
I'll also state that it's a shame that...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 8, 2020 at 12:22 am

#3713446
Reply To: Validating meta data of xls file

Thom A wrote:
Charmer wrote:
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' ...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 8, 2020 at 12:20 am

#3713445

Viewing 15 posts - 7,951 through 7,965 (of 59,098 total)

Jeff Moden

Forum Replies Created

Attachments: