Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,431 through 14,445 (of 59,097 total)

RE: Determine Monday of next month and Monday of next week

Ed Wagner - Tuesday, September 5, 2017 2:16 PM
Jeff Moden - Tuesday, September 5, 2017 1:41 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)

September 5, 2017 at 2:52 pm

#1958208
RE: Determine Monday of next month and Monday of next week

jcelko212 32090 - Tuesday, September 5, 2017 12:00 PM
jcobb 20350 - Wednesday, August 30, 2017 12:08 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)

September 5, 2017 at 1:41 pm

#1958183
RE: remove spaces in strings

komal145 - Tuesday, September 5, 2017 12:29 PM
hi ,
i hvave a value something like this column scrapetype "WebCrawler.Crawlable.EURRUSSIA.C_Darty ". My join is on...
--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)

September 5, 2017 at 1:26 pm

#1958174
RE: How to handle business hour loads?

Melllev - Tuesday, September 5, 2017 1:09 PM
Performance isn't a concern right now, so I'm not worried about that.
You have a process...
--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)

September 5, 2017 at 1:23 pm

#1958173
RE: Update data with same values

Chuck S - Tuesday, September 5, 2017 9:34 AM
Hello,
I have a table with the header and child record in the same table....
--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)

September 5, 2017 at 11:45 am

#1958154
RE: Update Statistics..

So have you run the experiment to see if it's actually out of date statistics that's causing the problem?
--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)

September 5, 2017 at 11:40 am

#1958153
RE: What is your definition of a DBA?

Heh... for quick elevator conversations, I summarize by saying what the shirt says...
https://www.sunfrog.com/Data-Base-Administrator--SOLVE-192312050-Black-Guys.html?15435
--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)

September 5, 2017 at 11:38 am

#1958152
RE: To automatically change the value of a column if a particular date time is reached

poornima.s_pdi - Monday, September 4, 2017 11:54 PM
Hi pietlinden,
Thanks for your reply.
I am doing a bidding system,
I need to change the status...
--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)

September 5, 2017 at 1:11 am

#1958043
RE: Determine Monday of next month and Monday of next week

I'm not sure that we need a Calendar table for this. The following function works in all versions of SQL Server from 2005 and up. I'm in the habit 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)

September 4, 2017 at 11:26 pm

#1958038
RE: Determine Monday of next month and Monday of next week

Ed Wagner - Monday, September 4, 2017 5:16 PM
Jeff Moden - Monday, September 4, 2017 12: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)

September 4, 2017 at 6:30 pm

#1958032
RE: Determine Monday of next month and Monday of next week

jcobb 20350 - Wednesday, August 30, 2017 12:08 PM
I am trying to determine the first Mondayof 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)

September 4, 2017 at 12:18 pm

#1958027
RE: Determine Monday of next month and Monday of next week

Ed Wagner - Wednesday, August 30, 2017 4:40 PM
It looks like you already have your answer. For future reference, Lynn Pettis has...
--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)

September 4, 2017 at 12:03 pm

#1958026
RE: Determine Monday of next month and Monday of next week

drew.allen - Wednesday, August 30, 2017 2:53 PM
If I understand what you want. This will give it to you.
SELECT TOP 1...
--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)

September 4, 2017 at 11:41 am

#1958025
RE: Update Statistics..

Arsh - Monday, September 4, 2017 7:18 AM
Jeff Moden - Friday, September 1, 2017 6:55 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)

September 4, 2017 at 10:34 am

#1958024
RE: 3-level reporting hierarchy.

abhas - Monday, September 4, 2017 9:10 AM
Hi
I have a requirement where I need to get employees managers up to 3...
--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)

September 4, 2017 at 9:51 am

#1958022

Viewing 15 posts - 14,431 through 14,445 (of 59,097 total)