Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,031 through 12,045 (of 59,095 total)

RE: When it comes to salaries, I'm not average

@Andy... yes, I absolutely understand that. And it's all very well stated. What I'm getting at is that everyone is going to use this once they become aware of it...
--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 22, 2018 at 5:50 pm

#1995043
RE: Get first date and last date of the current month base on Work Week

Thanks for the feedback. Glad to help.
--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 22, 2018 at 3:24 pm

#1995031
RE: Are the posted questions getting worse?

Lynn Pettis - Friday, June 22, 2018 1:20 PM
Geez, why are people coming here expecting some one here to write code for...
--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 22, 2018 at 2:27 pm

#1995025
RE: How to find the all table list in the order of reference

binutb - Friday, June 22, 2018 7:21 AM
Hi,
We are using
--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 22, 2018 at 6:58 am

#1994963
RE: How to find the all table list in the order of reference

binutb - Friday, June 22, 2018 2:42 AM
Hi,
Finally we can conclude, unable to find table list in creation sequential order.
Please advise any...
--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 22, 2018 at 6:44 am

#1994961
RE: When it comes to salaries, I'm not average

Andy Warren - Thursday, June 21, 2018 3:10 PM
Jeff, you're right that a lot of us are average. That's not bad, it's...
--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 21, 2018 at 7:50 pm

#1994932
RE: Get first date and last date of the current month base on Work Week

The problem is that that your presumption on what the current month is is incorrect. If you go back to May, the 28th should be a part of May. In...
--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 21, 2018 at 6:42 pm

#1994929
RE: Split a comma separated string without looping ( No while loops )

mw_sql_developer - Thursday, June 21, 2018 10:04 AM
mw_sql_developer - Thursday, June 21, 2018 10:02 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)

June 21, 2018 at 3:10 pm

#1994921
RE: Get first date and last date of the current month base on Work Week

I've got a possible "full monty" solution and explanation for this. I'll post it tonight after work.
--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 21, 2018 at 9:22 am

#1994847
RE: When it comes to salaries, I'm not average

The bad part about this advice is that I've heard it from a whole lot of people and they're correct... they definitely not "average" . They're actually quite a bit below...
--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 21, 2018 at 9:20 am

#1994845
RE: How to find the all table list in the order of reference

Sue_H - Wednesday, June 20, 2018 11:57 AM
binutb - Wednesday, June 20, 2018 11:49 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)

June 21, 2018 at 9:07 am

#1994838
RE: Violation of Primary Key Contraint

chad.m.holmes - Thursday, June 21, 2018 6:06 AM
USE
--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 21, 2018 at 9:05 am

#1994837

Viewing 15 posts - 12,031 through 12,045 (of 59,095 total)