Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,646 through 12,660 (of 59,102 total)

RE: Are the posted questions getting worse?

Sean Lange - Thursday, March 29, 2018 1:13 PM
Jeff Moden - Thursday, March 29, 2018 1: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)

March 29, 2018 at 1:35 pm

#1985043
RE: Are the posted questions getting worse?

Lynn Pettis - Thursday, March 29, 2018 12:57 PM
Any one hear from R Barry Young lately?
Now that you mention it, no. I...
--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 29, 2018 at 1:01 pm

#1985035
RE: Generate a unique number for a combination

komal145 - Thursday, March 29, 2018 11:10 AM
How do you generate unique number based on a Loannumber , Date columns
Example
Declare...
--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 29, 2018 at 12:48 pm

#1985030
RE: How would you parse 000.024.000 into 24H?

Yep... agreed. Performance is second only to accuracy and they're both extremely important.
I was mostly referring to the bloody PARSENAME and the NVARCHAR conversion. I do know that...
--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 29, 2018 at 12:40 pm

#1985029
RE: How would you parse 000.024.000 into 24H?

Jason A. Long - Wednesday, March 28, 2018 10:58 AM
Jeff Moden - Wednesday, March 28, 2018 7:44...
--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 28, 2018 at 4:23 pm

#1984900
RE: How would you parse 000.024.000 into 24H?

NineIron - Wednesday, March 28, 2018 7:41 AM
Nice. I'll use replace(PARSENAME(TextTime,
--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 28, 2018 at 7:44 am

#1984795

RE: Table partitioning question

Marius.D - Tuesday, March 27, 2018 8:45 AM

Standard steps for adding a new partition are create the file group, add the file,...

--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 28, 2018 at 7:39 am

#1984790