Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,451 through 18,465 (of 59,071 total)

RE: Are the posted questions getting worse?

Hugo Kornelis (1/31/2016)
Ed Wagner (1/30/2016)
The articles and discussion on this site are top-notch.
I am once more going to be contrary. But let me start with the positive: a lot 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 31, 2016 at 8:36 am

#1855559
RE: Importing Poorly Formatted Text File to SQL

mxy (1/30/2016)
I have received file from other team,i will check with them, how it was generated.
About duplicate columns names, even though column name is repeated value is unique and...
--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 30, 2016 at 5:24 pm

#1855541
RE: Importing Poorly Formatted Text File to SQL

Orlando Colamatteo (1/30/2016)
I think because I was so excited about trying to solve the tech challenge around loading such a strange file-format.
+1000 to that. It was a bit o'...
--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 30, 2016 at 5:15 pm

#1855539
RE: Importing Poorly Formatted Text File to SQL

Thank you for the post on how to load the SSIS package. I appreciate the time you took. I'll have to pass, though. I was looking forward...
--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 30, 2016 at 5:12 pm

#1855538
RE: Are the posted questions getting worse?

Hugo Kornelis (1/30/2016)
Ed Wagner (1/30/2016)
Hugo Kornelis (1/30/2016)
Ed Wagner (1/30/2016)
I enjoy helping people, but honestly, what do they they expect from a free help forum?
I think that this, even more than...
--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 30, 2016 at 4:27 pm

#1855537
RE: Are the posted questions getting worse?

Hugo Kornelis (1/30/2016)
The problem is, as long as there is as much as a single person on the forum who just posts some random code that appears to fix the...
--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 30, 2016 at 4:12 pm

#1855535
RE: Sub-Grouping by consecutive rows

mishka-723908 (1/24/2016)
Thank you Jeff and thank you all very much, I will try this out tomorrow once I am back in the office.
How'd it go?
--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 30, 2016 at 4:08 pm

#1855533
RE: What is the True Version of Code?

From the Article:
Instead I'd say that production changes should always be fed back to the VCS.
If anyone is actually doing it that way, they need to prepare to fail some...
--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 30, 2016 at 3:37 pm

#1855531
RE: Importing Poorly Formatted Text File to SQL

@mxy,
BTW, what was the DOS command that you used to create the file? The reason I ask is because there may be a simpler method available but I 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 30, 2016 at 2:37 pm

#1855528
RE: Importing Poorly Formatted Text File to SQL

mxy (1/30/2016)
I have below formatted text file each record for a user is separated with space, userid is unique value.
i want to import to SQL either using SSIS or bulk...
--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 30, 2016 at 2:17 pm

#1855527
RE: Importing Poorly Formatted Text File to SQL

@orlando,
I've gotten away from SSIS so much that I don't even know how to open SSIS and load a package. I'm really interested in seeing what you've done. ...
--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 30, 2016 at 2:13 pm

#1855526
RE: Are the posted questions getting worse?

Jacob Wilkins (1/29/2016)
I've been through a few considerings. Went to undergrad planning on law school. Then I changed my mind and went to grad school studying formal logic, hoping 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 29, 2016 at 7:28 pm

#1855438
RE: Are the posted questions getting worse?

Ed Wagner (1/29/2016)
Jeff Moden (1/29/2016)
BL0B_EATER (1/29/2016)
Have you guys during your careers ever thought about doing something else in life.. as opposed to IT / SQL Server / Coding etc etc?
Yes....
--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 29, 2016 at 7:26 pm

#1855437
RE: Are the posted questions getting worse?

Koen Verbeeck (1/29/2016)
Apparently got over 15,000 points today. Yay. :w00t:
Congrats, Koen!
--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 29, 2016 at 7:25 pm

#1855436
RE: Simple Solution to Common Problem

Nice solution and I've bookmarked it in case I ever need such a thing. I've just never needed such a thing... yet.
--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 29, 2016 at 7:23 pm

#1855435

Viewing 15 posts - 18,451 through 18,465 (of 59,071 total)