Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,481 through 18,495 (of 59,098 total)

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
RE: Can we delay the execution?Or ReWrite this Query?

suryahanuma (1/29/2016)
I am 100% sure it would not go beyond C usually,with 3 exemptions if all are utilized it will go F. SO we do not have to think until...
--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:12 pm

#1855432
RE: OPENROWSET - how to read everything as text

Ed Wagner (1/29/2016)
Once you get the syntax of the format file down, the BULK INSERT command is a rock-solid approach. You get to control the data type and maximum...
--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 6:08 pm

#1855429
RE: Datetime conversion

Ed Wagner (1/29/2016)
Luis Cazares (1/29/2016)
J Livingston SQL (1/29/2016)
fair enough...see your (very valid) point. but why use "CONVERT" instead of "TRY_CONVERT"? (2012 forum)
Thanks
Bad practice. I didn't see it was...
--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 6:07 pm

#1855428

Viewing 15 posts - 18,481 through 18,495 (of 59,098 total)