Jeff Moden

Forum Replies Created

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

RE: Need Logic

That being said, please see the first link under "Helpful Links" in my signature line below for how to post readily consumable data to help us help you more quickly.
--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)

May 1, 2017 at 3:51 pm

#1940620
RE: Sync Prod to Non-Prod

Rechana Rajan - Monday, May 1, 2017 7:13 AM
Jeff Moden - Friday, February 10, 2017 7:11 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)

May 1, 2017 at 2:16 pm

#1940607
RE: Are the posted questions getting worse?

Getting back to the original question that started "The Thread"...
No need to pile on but the following link is what this world has come to and why 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)

May 1, 2017 at 2:10 pm

#1940606
RE: Table Changes

danielnunez86 - Friday, April 28, 2017 1:27 PM
I have a table with Personnel Records.
Those records have information on a a table 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)

May 1, 2017 at 1:58 pm

#1940602
RE: Encrypting the data

Heh.... I just scribble over the data with two different ball point pens. 😉
--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)

May 1, 2017 at 1:42 pm

#1940601
RE: Find and Replace a value across all tables in database

Devendra Thakur - Sunday, April 30, 2017 10:51 PM
Jeff Moden - Saturday, April 29, 2017 4:03 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)

May 1, 2017 at 1:39 pm

#1940600
RE: Query Performance Standards - Overall Per DB

chris.munsell - Monday, May 1, 2017 8:11 AM
Jeff Moden - Wednesday, April 26, 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)

May 1, 2017 at 1:01 pm

#1940594
RE: Export data in XML to import into Word

kevaburg - Sunday, April 30, 2017 1:48 AM
Jeff Moden - Saturday, April 29, 2017 5:02 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)

April 30, 2017 at 3:31 pm

#1940514
RE: Keeping up to, and down with, Date

TomThomson - Friday, April 28, 2017 5:28 PM
Eric M Russell - Monday, January 9, 2017 3:33 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)

April 29, 2017 at 9:47 pm

#1940502
RE: Export data in XML to import into Word

kevaburg - Saturday, April 29, 2017 11:19 AM
So, I have altered the BCP export to include elements and the root element:
[code...
--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)

April 29, 2017 at 5:02 pm

#1940498
RE: Importing only certain named columns from CSV

achilleid - Friday, April 28, 2017 3:25 PM
I have a client that is terrible about giving me consistent data sets, so 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)

April 29, 2017 at 4:44 pm

#1940497
RE: SSIS ForEach Column loop

I can't help thinking that someone needs to fix the design of this whole thing but, if you absolutely need it, please see the following article for how to do...
--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)

April 29, 2017 at 4:09 pm

#1940496
RE: Find and Replace a value across all tables in database

With absolutely no disrespect to the author, I cringe a bit when I see things like this. It generally means that the database wasn't properly designed to begin with. If...
--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)

April 29, 2017 at 4:03 pm

#1940495
RE: Are the posted questions getting worse?

Luis Cazares - Friday, April 28, 2017 11:55 AM
<rant>
Have you ever encountered a situation where your company defines certain authorized software 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)

April 28, 2017 at 8:48 pm

#1940467
RE: Questions for me to ask during a job interview

On a more serious note than my previous post, I'd likely ask the following questions as well as some of those already posted.
1. What kind of 3rd party...
--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)

April 28, 2017 at 8:33 pm

#1940464

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