Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,801 through 10,815 (of 59,095 total)

RE: Can't remove multiple char(32) strings

ChrisM@Work - Friday, October 26, 2018 6:59 AM
Unusually complicated for a simple update:
UPDATE
--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)

October 26, 2018 at 9:05 am

#2011363
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor - Friday, October 26, 2018 8:10 AM
I'd argue the main problem is the MS developers don't...
--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)

October 26, 2018 at 8:48 am

#2011359
RE: How to build an app with GUI that works with SQL Server?

patrickmcginnis59 10839 - Friday, October 26, 2018 7:12 AM
sgmunson - Friday, October 26, 2018 6:58 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)

October 26, 2018 at 8:29 am

#2011355
RE: Can we do the Group by with Like + % in the SQL Query?
The next thing they'll ask for is to....
1. Calculate the total number of nodes in each person's downline including that person.
2. Calculate...
--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)
October 25, 2018 at 11:20 pm

#2011287
RE: NOT IN vs NOT EXISTS

jcelko212 32090 - Thursday, October 25, 2018 3:46 PM
The [NOT] EXISTS() is one of the few we've got in SQL. The can...
--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)

October 25, 2018 at 8:38 pm

#2011279
RE: Split comma delimited field?

ScottPletcher - Thursday, October 25, 2018 4:42 PM
Jeff Moden - Thursday, October 25, 2018 3:06 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)

October 25, 2018 at 6:24 pm

#2011274
RE: Are the posted questions getting worse?

GilaMonster - Thursday, October 25, 2018 1:20 PM
jasona.work - Thursday, October 25, 2018 12:15 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)

October 25, 2018 at 3:08 pm

#2011260
RE: Split comma delimited field?

ScottPletcher - Thursday, October 25, 2018 9:49 AM
Jeff Moden - Wednesday, October 24, 2018 6:07 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)

October 25, 2018 at 3:06 pm

#2011258
RE: Split comma delimited field?

sgmunson - Thursday, October 25, 2018 12:45 PM
Lynn Pettis - Wednesday, October 24, 2018 3:23 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)

October 25, 2018 at 2:56 pm

#2011254
RE: How to build an app with GUI that works with SQL Server?

patrickmcginnis59 10839 - Thursday, October 25, 2018 10:26 AM
Jeff Moden - Thursday, October 25, 2018 8:33 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)

October 25, 2018 at 10:42 am

#2011189
RE: Encrypted Password

SATYA R - Wednesday, October 24, 2018 12:29 AM
Hi Guru's,
I have weird situation while passing username and password in BCP command. Can...
--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)

October 25, 2018 at 9:39 am

#2011175
RE: increment months for two dates combination as a new label column

hegdesuchi - Monday, October 22, 2018 1:22 PM
I have to calculate a new Label column for each combination of Start Date and...
--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)

October 25, 2018 at 9:29 am

#2011174
RE: Naming Conventions for SQL Server Objects

drew.allen - Thursday, October 25, 2018 8:31 AM
Jeff Moden - Thursday, October 25, 2018 8: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)

October 25, 2018 at 8:42 am

#2011157
RE: How to build an app with GUI that works with SQL Server?

andycadley - Thursday, October 25, 2018 12:33 AM
Having worked in a university previously, I can tell you that a lot of GUI...
--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)

October 25, 2018 at 8:33 am

#2011154
RE: Naming Conventions for SQL Server Objects

David Burrows - Thursday, October 25, 2018 1:53 AM
Jeff Moden - Wednesday, October 24, 2018 4:01 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)

October 25, 2018 at 8:01 am

#2011141

Viewing 15 posts - 10,801 through 10,815 (of 59,095 total)