Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,956 through 11,970 (of 59,102 total)

RE: Efficient way to count distinct

ollyjolly - Tuesday, July 3, 2018 9:15 PM
As I was afraid....it looks like I am limited to SELECT permission. Attempted to create a...
--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)

July 4, 2018 at 7:12 am

#1996301
RE: Phone Number Validation

Jeff Moden - Tuesday, July 3, 2018 11:49 AM
N.B. - Friday, June 29, 2018 12:51 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)

July 4, 2018 at 7:10 am

#1996300
RE: Efficient way to count distinct

ollyjolly - Tuesday, July 3, 2018 6:50 PM
I am trying to come up with a more efficient method to count distinct values for two...
--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)

July 3, 2018 at 8:36 pm

#1996241
RE: Phone Number Validation

N.B. - Friday, June 29, 2018 12:51 PM
Greetings,
I'm working on a project where we have to take a list of unique phone...
--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)

July 3, 2018 at 11:49 am

#1996206
RE: Importing Tricky CSV Files with PowerShell

Stewart "Arturius" Campbell - Monday, July 2, 2018 11:04 PM
Comments posted to this topic are about the item Importing Tricky CSV...
--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)

July 3, 2018 at 8:59 am

#1996168
RE: Importing Tricky CSV Files with PowerShell

Jerry Kelk - Tuesday, July 3, 2018 2:43 AM
This has been a personal annoyance for years.
Surely, the import engine should properly respect...
--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)

July 3, 2018 at 8:25 am

#1996160
RE: After Insert trigger

Arsh - Tuesday, July 3, 2018 2:19 AM
Arsh - Sunday, July 1, 2018 12:01 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)

July 3, 2018 at 6:22 am

#1996121
RE: DevOps is Really Helpful

funbi - Tuesday, July 3, 2018 2:32 AM
Jeff Moden - Monday, July 2, 2018 1:31 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)

July 3, 2018 at 6:08 am

#1996117
RE: Phone Number Validation

Sergiy - Monday, July 2, 2018 2:31 PM
crmitchell - Monday, July 2, 2018 11:08 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)

July 2, 2018 at 3:00 pm

#1996069
RE: DevOps is Really Helpful

Steve Jones - SSC Editor - Monday, July 2, 2018 12:50 PM
Jeff Moden - Monday, July 2,...
--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)

July 2, 2018 at 1:31 pm

#1996062
RE: String or binary data would be truncated

Steve Jones - SSC Editor - Thursday, June 28, 2018 9:45 AM
Japie Botma - Thursday, June 28,...
--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)

July 2, 2018 at 12:56 pm

#1996059
RE: DevOps is Really Helpful

Steve Jones - SSC Editor - Monday, July 2, 2018 9:03 AM
I think you're being pendantic and picky, Jeff.
Hammers existed before we...
--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)

July 2, 2018 at 12:16 pm

#1996054
RE: Looking for TSQL Query to display Parent child relationships

If it's for a one-off task, you can use SQL Diagrams, which is a built in tool. It's fairly limited but for simple tasks such as you describe, it may...
--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)

July 2, 2018 at 7:10 am

#1996000
RE: Phone Number Validation

The whole purpose of the third party software is to do exactly what is being requested and it's being done for "legal reasons". Pre-filtering is not only more difficult than...
--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)

July 2, 2018 at 6:56 am

#1995998
RE: Move files without moving subfolder files

Brandie Tarvin - Monday, July 2, 2018 6:25 AM
I have been tasked with building a powershell file mover to move files (which...
--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)

July 2, 2018 at 6:49 am

#1995997

Viewing 15 posts - 11,956 through 11,970 (of 59,102 total)