Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,831 through 10,845 (of 59,102 total)

RE: Split comma delimited field?

Jonathan AC Roberts - Wednesday, October 24, 2018 3:51 PM
Lynn Pettis - Wednesday, October 24, 2018 3:23...
--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 24, 2018 at 6:07 pm

#2011049
RE: NOT IN vs NOT EXISTS

Ask the ring knocker if he likes pork chops and then feed him your results.
Lordy, I hate such "experts". As always, one good test is worth 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)

October 24, 2018 at 6:04 pm

#2011048
RE: How to do a basic loop in SQL

jcelko212 32090 - Wednesday, October 24, 2018 2:15 PM
barry.nielson - Tuesday, October 23, 2018 3:55 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 24, 2018 at 5:20 pm

#2011044
RE: Prevent accidental DB drop\delete

Sue_H - Wednesday, October 24, 2018 11:52 AM
Subhash Chandra - Wednesday, October 24, 2018 9: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)

October 24, 2018 at 4:58 pm

#2011040
RE: Naming Conventions for SQL Server Objects

Jeffrey Williams 3188 - Wednesday, October 24, 2018 1:08 PM
xsevensinzx - Wednesday, October 24, 2018 4:27 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 24, 2018 at 4:01 pm

#2011031
RE: Are the posted questions getting worse?

Brandie Tarvin - Wednesday, October 24, 2018 11:24 AM
WHEE!
Just got a text from my mom, who is watching the munchkin.
Guess who...
--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 24, 2018 at 11:30 am

#2010978
RE: Coming from Oracle - How Do I Do This Date Conversion in SQLServer?

Lynn's method will not provide leading zeros for times < 10, which you seem to indicate is required in your original post. The following formula will.
--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 24, 2018 at 9:39 am

#2010966

RE: Index space

WhiteLotus - Wednesday, October 24, 2018 12:34 AM

Hi Guys

--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 24, 2018 at 9:33 am

#2010964

RE: Coming from Oracle - How Do I Do This Date Conversion in SQLServer?

Thom A - Friday, October 5, 2018 7:51 AM

SQL Server has a FORMAT function, so if you were doing this with a...

--Jeff Moden

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 24, 2018 at 9:21 am

#2010958

RE: Coming from Oracle - How Do I Do This Date Conversion in SQLServer?

I have to agree with Drew. I won't even post the FORMAT function as a possible solution until they fix the performance issues. I may, however, start off a posted...

--Jeff Moden

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 24, 2018 at 7:10 am

#2010918