Jeff Moden

Forum Replies Created

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

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
RE: find out who / what casued my database to increase in size?

If proc cache hasn't been cleared, it may show up in the built in reports as one of the queries that used the most I/O.
--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 2:59 pm

#1947644
RE: Are the posted questions getting worse?

Sean Lange - Wednesday, June 21, 2017 12:21 PM
Luis Cazares - Wednesday, June 21, 2017 10:32 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, 2017 at 2:49 pm

#1947642
RE: Using Ntile for fixed number of rows

Jason A. Long - Wednesday, June 21, 2017 1:42 PM
See if something like the following will work for you.
Test data...

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)

June 21, 2017 at 2:44 pm

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

I wouldn't put it anywhere in a PIVOT for the very reason of NULLs. If you use a CROSSTAB instead, it's all "auto-magic" and can be twice as fast, as...
--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 2:14 pm

#1947635

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