Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,091 through 12,105 (of 59,099 total)

RE: Help needed on TSQL query: update using a self join

This request just doesn't seem right. I don't know why anyone would actually need to do this but my initial impression is that it's on the edge of "data tampering".
--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)

June 18, 2018 at 8:30 am

#1994296
RE: Jobs You Wouldn't Expect To Be Threatened By Tech But Are

Victor Kirkpatrick - Monday, June 18, 2018 4:40 AM
There has to be a balance here. I mean, if automation will put so...
--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)

June 18, 2018 at 8:24 am

#1994294
RE: Entering random data into a table

Junior GalvÃ£o - MVP - Sunday, June 17, 2018 6:46 PM
Hi Jeff,
I understand and accept your words,...
--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)

June 17, 2018 at 7:08 pm

#1994228
RE: Entering random data into a table

Junior GalvÃ£o - MVP - Sunday, June 17, 2018 5:11 PM
Junior GalvÃ£o - MVP - Sunday, June...
--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)

June 17, 2018 at 6:14 pm

#1994226
RE: SSRS 2016 - HTML5 rendering issues

I'm curious... who is actually going to peruse a 4,000 row HTML document?
--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)

June 16, 2018 at 5:28 pm

#1994215
RE: Grouping and Exporting to Text File

Here's the test data setup I used...

CREATE TABLE #TestTable
        (
         id         INT
        ,location   VARCHAR(50)
        )
;
INSERT INTO #TestTable
       ...
--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)

June 16, 2018 at 5:14 pm

#1994214
RE: Entering random data into a table

p.s. I guess you had a couple of special characters in your @Texto string... they didn't copy correctly when I pasted my code. You may have to change some 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)

June 16, 2018 at 3:12 pm

#1994210
RE: Entering random data into a table

I appreciate anyone that will step up to the plate with an article or a script. Since you brandish the title of "MVP" in your handle and I've verified 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)

June 16, 2018 at 3:10 pm

#1994209
RE: One large vs several small files

p.s. To answer the question that was asked... no... I wouldn't split up the files. It's just another "touch" on the data that could screw something up and complicates things...
--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)

June 16, 2018 at 12:20 pm

#1994207
RE: One large vs several small files

kdbarrett 88655 - Friday, June 15, 2018 10:35 AM
It's a bit more than just streaming into a database. There is some processing,...
--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)

June 16, 2018 at 12:15 pm

#1994206
RE: Building Test Data

Frank W Fulton Jr - Friday, June 15, 2018 3:40 PM
The biggest problem with creating your own test data...
--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)

June 15, 2018 at 9:18 pm

#1994195
RE: Building Test Data

Eric M Russell - Friday, June 15, 2018 8:56 AM
Jeff Moden - Thursday, June 14, 2018 9:16...
--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)

June 15, 2018 at 9:09 am

#1994128
RE: The Data Submarine

Steve Jones - SSC Editor - Friday, June 15, 2018 8:01 AM
Jeff Moden - Thursday, June 14,...
--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)

June 15, 2018 at 9:07 am

#1994126
RE: Return All affected dbs in error

Super Cat - Friday, June 15, 2018 1:47 AM
I was really simple. Embarrassed I posted now. Dumped the name in a temp...
--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)

June 15, 2018 at 7:55 am

#1994112
RE: REPLACE Multiple Spaces with One

Thanks for the feedback, Jessin.
--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)

June 15, 2018 at 7:53 am

#1994110

Viewing 15 posts - 12,091 through 12,105 (of 59,099 total)