Jeff Moden

Forum Replies Created

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

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
RE: Reaping the benefits of the Window functions in T-SQL

I thought you knew since you brought it up.
Did some research and found out the BIN2 stuff uses "Code Point Comparison Semantics" and the plain BIN stuff is backwards...
--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:54 am

#2012405
RE: OPENROWSET - issue with spaces in the file name

mr-967650 - Monday, November 5, 2018 8:08 AM
frederico_fonseca - Monday, November 5, 2018 7:06 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 8:30 am

#2012403
RE: Write Conflict

barry.nielson - Sunday, November 4, 2018 9:43 PM
Hi all,
So this issue is driving me bat guano insane.
I have MS Access linked to...
--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 7:30 am

#2012390
RE: OPENROWSET - issue with spaces in the file name

frederico_fonseca - Monday, November 5, 2018 7:06 AM
Jeff Moden - Sunday, November 4, 2018 5: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 5, 2018 at 7:24 am

#2012389

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