Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,881 through 14,895 (of 59,101 total)

RE: Microsoft SQL Server Utilities and Tools

Awesome. Thanks for taking the time to post this.
--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 23, 2017 at 9:04 am

#1947972
RE: Are the posted questions getting worse?

Grant Fritchey - Friday, June 23, 2017 7:42 AM
Thom A - Friday, June 23, 2017 6:52 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 23, 2017 at 8:58 am

#1947970
RE: How to get the monday of every week

Ed Wagner - Thursday, June 22, 2017 3:42 PM
Jeff Moden - Thursday, June 22, 2017 1:57 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)

June 22, 2017 at 8:44 pm

#1947876
RE: How to get the monday of every week

komal145 - Thursday, June 22, 2017 1:55 PM
Thanks everyone was able to get the monday's from Getdate()
SELECT DATEADD(wk, -5, DATEADD(DAY, -5-DATEPART(WEEKDAY, GETDATE()),...
--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, 2017 at 3:09 pm

#1947851
RE: How to get the monday of every week

jcelko212 32090 - Thursday, June 22, 2017 12:43 PM
For example, you might be coded "MP" and not be a Member 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 22, 2017 at 1:57 pm

#1947835
RE: Where to use ISNULL to convert NULL in PIVOT result set

Chris Harshman - Thursday, June 22, 2017 8:49 AM
r.gall - Thursday, June 22, 2017 2:13 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 22, 2017 at 11:36 am

#1947822
RE: How to get the monday of every week

Jacob Wilkins - Thursday, June 22, 2017 9:07 AM
Jeff Moden - Wednesday, June 21, 2017 8: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)

June 22, 2017 at 11:33 am

#1947819
RE: How to get the monday of every week

jcelko212 32090 - Thursday, June 22, 2017 9:02 AM
komal145 - Tuesday, June 20, 2017 8:59 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)

June 22, 2017 at 11:28 am

#1947816
RE: Tsql Query help

sqlenthu 89358 - Wednesday, June 21, 2017 9:34 PM
Thanks Jeff. Very helpful and interesting.
Thanks for the feedback. Just to add to 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)

June 22, 2017 at 7:45 am

#1947759
RE: Using Ntile for fixed number of rows

Jason A. Long - Wednesday, June 21, 2017 2:59 PM
Jeff Moden - Wednesday, June 21, 2017 2:44...
--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, 2017 at 7:41 am

#1947757
RE: Where to use ISNULL to convert NULL in PIVOT result set

r.gall - Thursday, June 22, 2017 4:51 AM
Chris Harshman - Wednesday, June 21, 2017 12: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)

June 22, 2017 at 7:33 am

#1947749
RE: How to get the monday of every week

The question that I have is, should 15 or 16 Mondays be returned?
--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, 2017 at 8:20 pm

#1947675
RE: How to get the monday of every week

Joe Torre - Wednesday, June 21, 2017 9:50 AM
SELECT
DateAdd(WEEK,number*-1,DateAdd(DAY, 2, DateAdd(WEEK, DateDiff(WEEK,0,GetDate()), '19000101')))
FROM master.dbo.spt_values sv
WHERE sv.type='P'
AND sv.number BETWEEN...
--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, 2017 at 8:16 pm

#1947674
RE: How to get the monday of every week

Thought I'd throw my hat into the ring. Might as well make the functionality reusable in case requirements change or you someday need to go in the other direction. Further...
--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, 2017 at 8:08 pm

#1947673
RE: Tsql Query help

sqlenthu 89358 - Wednesday, June 21, 2017 10:26 AM
Thom, both urs and Luis' query gave me a fair idea of how I...
--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, 2017 at 3:03 pm

#1947648

Viewing 15 posts - 14,881 through 14,895 (of 59,101 total)