Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,826 through 15,840 (of 59,098 total)

RE: Join Two CSV Files with a Common Column

vl1969-734655 - Tuesday, January 24, 2017 5:51 AM
well if you never needed the ini, than how did your data got processed?
I have...
--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 24, 2017 at 7:48 am

#1924628
RE: right aligning

Sean Lange - Monday, January 23, 2017 7:08 AM
I am surprised that nobody yet has stated that formatting belongs in the front...
--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 23, 2017 at 4:03 pm

#1924502
RE: Join Two CSV Files with a Common Column

vl1969-734655 - Monday, January 23, 2017 8:55 AM
Jeff Moden - Monday, January 23, 2017 8:28 AM
--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 23, 2017 at 3:55 pm

#1924501
RE: parsing records with empty spaces

ebooklub - Monday, January 23, 2017 9:01 AM
Thanks Jeff,
PowerShell replacement of sql based stored procedures is part our project
bellow is solution I used (part of...
--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 23, 2017 at 3:50 pm

#1924500
RE: Join Two CSV Files with a Common Column

John Bigler - Monday, January 23, 2017 6:49 AM
Good morning all.
Nothing wrong with these solutions, but I prefer something more direct...
--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 23, 2017 at 8:28 am

#1924406
RE: SSC Forum Updates

Zounds. The SQL Code IFCode windows are pretty much a train wreck now. If I copy and paste from SSMS, indentation (leading spaces) disappears and double, triple, and, sometimes, quadruple...
--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 22, 2017 at 9:14 pm

#1924294
RE: parsing records with empty spaces

Ok... Sorry this took so long but I was unexpectedly busy this weekend. I also apologize for the cruddy non-indented, non-aligned code this forum now spews out. Plain code with...
--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 22, 2017 at 7:43 pm

#1924291
RE: use excel to update backend SQL Table

Jeff Moden - Thursday, January 19, 2017 9:15 PM
Excellent! I'll finish putting it together this weekend and get it out to you. ...
--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 22, 2017 at 1:15 pm

#1924270
RE: use excel to update backend SQL Table

Gosta Munktell - Friday, January 20, 2017 2:00 AM
Thanks all
I have been involved in a number of projects with the purpose 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 22, 2017 at 1:12 pm

#1924267
RE: right aligning

The correct answer (out of the ones listed with the question) is actually pretty slow compared to other methods. Also, the correct answer takes inputs as FLOAT. That usually doesn't...
--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 21, 2017 at 9:50 pm

#1924235
RE: Are the posted questions getting worse?

Sean Lange - Friday, January 20, 2017 12:56 PM
Lynn Pettis - Friday, January 20, 2017 12:48 PM
--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 20, 2017 at 4:07 pm

#1924169
RE: parsing records with empty spaces

ebooklub - Friday, January 20, 2017 11:40 AM
Jeff Moden - Friday, January 20, 2017 11:17 AM
--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 20, 2017 at 4:04 pm

#1924167
RE: parsing records with empty spaces

So you did NOT add any spaces to try to line things up? I ask because the alignment of the right most column has flaws in it. I have to make sure of...
--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 20, 2017 at 11:17 am

#1924119
RE: parsing records with empty spaces

ebooklub - Friday, January 20, 2017 9:17 AM
Jeff Moden - Friday, January 20, 2017 8:46 AM
--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 20, 2017 at 10:32 am

#1924109
RE: parsing records with empty spaces

ebooklub - Friday, January 20, 2017 8:05 AM
Jeff Moden - Thursday, January 19, 2017 9:38 PM
--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 20, 2017 at 8:46 am

#1924072

Viewing 15 posts - 15,826 through 15,840 (of 59,098 total)