Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,696 through 10,710 (of 59,099 total)

RE: While Loop Stored Procedure

Daniel.Bayliss - Tuesday, November 6, 2018 8:59 AM
Hi,
Can help me with an issue I am facing. I need to create a single...
--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)

November 6, 2018 at 7:35 pm

#2012645
RE: Caution about Restoring via SSMS v17

ScottPletcher - Tuesday, November 6, 2018 12:15 PM
Wow, I'm surprised. That's certainly interesting, and not what I expected.
I agree to both...
--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)

November 6, 2018 at 6:39 pm

#2012643
RE: Explaining Our Professions to Our Parents

skeleton567 - Tuesday, November 6, 2018 6:40 AM
Well, I know that my parents would thoroughly understand my career, even though I lost...
--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)

November 6, 2018 at 5:58 pm

#2012642
RE: Insert Date from integer month and year columns in the same table

Eirikur Eiriksson - Monday, November 5, 2018 10:59 PM
Jeff Moden - Monday, November 5, 2018 8:25 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)

November 6, 2018 at 5:43 pm

#2012640
RE: How can I get a set Date and Time Range between Yesterday and Today?

drew.allen - Tuesday, November 6, 2018 12:25 PM
ScottPletcher - Tuesday, November 6, 2018 7:46 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)

November 6, 2018 at 5:38 pm

#2012638
RE: Insert Date from integer month and year columns in the same table

Jeffrey Williams 3188 - Monday, November 5, 2018 3:51 PM
How about EOMONTH(InvoiceDate)? Probably won't notice any performance issues with this - but...
--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)

November 5, 2018 at 8:25 pm

#2012478
RE: File could not be opened

chuck.forbes - Monday, November 5, 2018 3:37 PM
So I am a bit baffled. We have a process that we're moving from one...
--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)

November 5, 2018 at 8:21 pm

#2012477
RE: get qtr,month and year from start date

Papil - Monday, November 5, 2018 5:05 PM
I have start date column. how can i get rest of 4 columns 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)

November 5, 2018 at 8:00 pm

#2012476
RE: Today's Random Word!

below86 - Monday, November 5, 2018 1:08 PM
Jeff Moden - Monday, November 5, 2018 11:03 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)

November 5, 2018 at 4:56 pm

#2012463
RE: Today's Random Word!

saravanatn - Monday, November 5, 2018 10:42 AM
Ed Wagner - Monday, November 5, 2018 9:39 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)

November 5, 2018 at 11:03 am

#2012432
RE: DT_BYTE to DT_DBDATE

David Burrows - Monday, November 5, 2018 9:21 AM
Jeff Moden - Monday, November 5, 2018 9:00 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)

November 5, 2018 at 10:57 am

#2012430
RE: Reaping the benefits of the Window functions in T-SQL

Lynn Pettis - Monday, November 5, 2018 10:29 AM
Jeff Moden - Monday, November 5, 2018 8:54 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)

November 5, 2018 at 10:48 am

#2012428
RE: Today's Random Word!

Ed Wagner - Wednesday, October 31, 2018 1:49 PM
ManicStar - Wednesday, October 31, 2018 12:47 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)

November 5, 2018 at 9:10 am

#2012411
RE: Group By in a sub query

drew.allen - Monday, November 5, 2018 7:32 AM
solus - Monday, November 5, 2018 3:18 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)

November 5, 2018 at 9:04 am

#2012408
RE: DT_BYTE to DT_DBDATE

David Burrows - Monday, November 5, 2018 8:30 AM
Jeff Moden - Monday, November 5, 2018 7:23 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)

November 5, 2018 at 9:00 am

#2012406

Viewing 15 posts - 10,696 through 10,710 (of 59,099 total)