Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,391 through 15,405 (of 59,063 total)

RE: Encapsulating complex logic without using a scalar UDF

While the conversation on a workdays cumulative column and some of its permutations is certainly a good one, it has nothing to do with the original post of how 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)

March 17, 2017 at 6:01 pm

#1933850
RE: Are the posted questions getting worse?

Sean Lange - Friday, March 17, 2017 7:56 AM
Luis Cazares - Thursday, March 16, 2017 3:16 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)

March 17, 2017 at 9:39 am

#1933775
RE: Windows Functions: Tell me when that changes.

adame - Thursday, February 18, 2016 1:38 AM
Agreed, always look to use new features.
Nah...you did good. I agree that there have been...
--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)

March 17, 2017 at 9:14 am

#1933770
RE: Windows Functions: Tell me when that changes.

ChrisM@Work - Friday, March 17, 2017 2:54 AM
davidawest00 - Wednesday, February 17, 2016 10:35 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)

March 17, 2017 at 8:57 am

#1933765
RE: A full and a diff

Heh... for me, the correct answer for me is there would be no files because I don't use PoSh to do backups. 😉
--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)

March 16, 2017 at 7:18 am

#1933458
RE: Day-of-week to Week-Number mapping

Cross Join with a list of weeks? Don't forget to compensate for laundry day offsets. 😉
--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)

March 16, 2017 at 7:06 am

#1933453
RE: Are the posted questions getting worse?

Hugo Kornelis - Thursday, March 16, 2017 2:47 AM
Jeff Moden - Wednesday, March 15, 2017 8:49 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)

March 16, 2017 at 6:47 am

#1933449
RE: Getting Data and Headers

Ed Wagner - Thursday, March 2, 2017 6:25 AM
Luis Cazares - Wednesday, March 1, 2017 6:53 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)

March 15, 2017 at 9:06 pm

#1933393
RE: Encapsulating complex logic without using a scalar UDF

jcelko212 32090 - Wednesday, March 15, 2017 7:40 PM
Lynn Pettis - Wednesday, March 15, 2017 9:38 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)

March 15, 2017 at 9:02 pm

#1933392
RE: Are the posted questions getting worse?

Alan.B - Wednesday, March 15, 2017 3:01 PM
Lowell - Wednesday, March 15, 2017 1:32 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)

March 15, 2017 at 8:49 pm

#1933391
RE: How to allow a user to consult all jobs in my server, using SSMS?

Haley - Wednesday, March 15, 2017 10:38 AM
Hello,
I need some help with SQL Server 2012, please!
How to allow a user 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)

March 15, 2017 at 6:39 pm

#1933388
RE: Encapsulating complex logic without using a scalar UDF

jcelko212 32090 - Tuesday, March 14, 2017 2:04 PM
Jeff Moden - Tuesday, March 14, 2017 11:25 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)

March 15, 2017 at 6:23 pm

#1933387
RE: Encapsulating complex logic without using a scalar UDF

The single update on a calendar table to renumber the working day enumerations is a no brainer, folks. And, like anything else, it needs to be written correctly. It's not...
--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)

March 15, 2017 at 6:21 pm

#1933386
RE: 'Spell check' a string-valued field

First, apologies for thinking it was XML. Jason is correct. I got the word "tags" and the <somestring> format stuck in my head. Shifting gears to your problem...
Try...
--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)

March 14, 2017 at 10:05 pm

#1933171
RE: Clustered scan vs Non-clustered Seek with lookup

ScottPletcher - Tuesday, March 14, 2017 4:35 PM
Jeff Moden - Tuesday, March 14, 2017 11: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)

March 14, 2017 at 7:59 pm

#1933167

Viewing 15 posts - 15,391 through 15,405 (of 59,063 total)