Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,181 through 36,195 (of 59,067 total)

RE: Count the number of rows with same last part

If you always have 3 parts, the following will do the trick. I've not tested it to see if it's any faster but I do know that 3 REVERSEs...
--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 29, 2010 at 6:21 pm

#1244485
RE: 100 Years Ago, What Would You Be?

I wouldn't "be" a 100 years ago... I would have died 148 years ago from blood poisoning or 146 years ago from a really nasty case of double Pneumonia.
--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 29, 2010 at 6:08 pm

#1244484
RE: Hidden or Unknown Job Perks

Craig Farrell (10/29/2010)
I've been through four, but only managed to find *one* auditor who would actually talk to me. They tend to be incredibly tight lipped, but we smoked...
--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 29, 2010 at 5:41 pm

#1244481
RE: Are the posted questions getting worse?

Grant Fritchey (10/29/2010)
Jeff Moden (10/28/2010)
Brandie Tarvin (10/28/2010)
FYI: Aside from Demo-titis, Grant had a pretty good presentation. Wish I could go to PASS and see the full 90 minute one.
Now I'm...
--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 29, 2010 at 8:42 am

#1244243
RE: Are There That Many GUIDs?

GSquared (10/29/2010)
Jeff Moden (10/29/2010)
Paul White NZ (10/27/2010)
Jeff Moden (10/27/2010)
Steve Jones - SSC Editor (10/27/2010)
Some of the smaller manufacturers aren't careful. In the 90s we had two separate NICs have duplicate...
--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 29, 2010 at 8:23 am

#1244229
RE: How reformat the date - Newbee

Lynn Pettis (10/29/2010)
The OP is generating a flat file, so in my opinion formatting the date in T-SQL is acceptable as there is no GUI or reporting tool.
Just for the...
--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 29, 2010 at 8:16 am

#1244221
RE: Hidden or Unknown Job Perks

I'll certainly Google it but we know how that sometimes goes... so let me ask... for those of you who have gone through a SOX audit on SQL Server (or...
--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 29, 2010 at 6:26 am

#1244098
RE: How reformat the date - Newbee

{Flat file} Ah... so I see. I missed that in the OP. Thanks, Lynn.
It really is still an issue that the original data has a non-DATETIME column...
--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 29, 2010 at 6:11 am

#1244087
RE: Why doesn’t ISNUMERIC work correctly?

WayneS (10/28/2010)
So you've got two SQL Spackle articles already done?
I do. I also ran into a couple of problems at work recently and solved them. They're also something...
--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 29, 2010 at 6:08 am

#1244084
RE: Are There That Many GUIDs?

Paul White NZ (10/27/2010)
Jeff Moden (10/27/2010)
Steve Jones - SSC Editor (10/27/2010)
Some of the smaller manufacturers aren't careful. In the 90s we had two separate NICs have duplicate MACs when 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)

October 29, 2010 at 6:04 am

#1244081
RE: How reformat the date - Newbee

nshah6 (10/28/2010)
Thank you !
You guys are Great. I really appreciate this ! 🙂
I consider this problem RESOLVED !
Maybe so but you should consider it to be just a temporary...
--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 28, 2010 at 6:28 pm

#1243946
RE: Are the posted questions getting worse?

Brandie Tarvin (10/28/2010)
FYI: Aside from Demo-titis, Grant had a pretty good presentation. Wish I could go to PASS and see the full 90 minute one.
Now I'm obsessing about my latest...
--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 28, 2010 at 6:07 pm

#1243942
RE: Are the posted questions getting worse?

Alvin Ramard (10/28/2010)
Grant Fritchey (10/28/2010)
Brandie Tarvin (10/28/2010)
Waving to Grant across the interwebs while listening to him present on execution plans!
Oh, that was you? Sorry I didn't wave back. Man, 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)

October 28, 2010 at 6:03 pm

#1243941
RE: Are the posted questions getting worse?

Roy Ernest (10/28/2010)
Grant Fritchey (10/28/2010)
Brandie Tarvin (10/28/2010)
Waving to Grant across the interwebs while listening to him present on execution plans!
Oh, that was you? Sorry I didn't wave back. Man, 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)

October 28, 2010 at 5:56 pm

#1243939
RE: Are the posted questions getting worse?

Brandie Tarvin (10/28/2010)
<snicker> Today's Sandra and Woo[/url] offers a reversal of the Dilbert paradigm.
BWAA-HAA!!! What makes that so incredibly funny is that it's so incredibly true.
--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 28, 2010 at 5:48 pm

#1243936

Viewing 15 posts - 36,181 through 36,195 (of 59,067 total)