Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,446 through 44,460 (of 59,097 total)

RE: how to break phone and exension data

Hey Shamshad... any feedback on this?
--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 24, 2009 at 7:35 pm

#965763
RE: Hex to Decmial Conversion

C'mon Grady... the reason why I'm asking is because I believe you're getting the wrong answer. Besides, it's a two way street here. 😉
--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 24, 2009 at 7:32 pm

#965761
RE: Findstring question

ssexton (3/24/2009)
Instr is the PL/SQL equivalent of Substring. In SSIS try the Substring function.
Hope that helps.
Ummm..... no it's not... INSTR in PL/SQL is the equivalent of CHARINDEX...
--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 24, 2009 at 7:03 pm

#965751
RE: A Better English Query

BWAA-HAA!!! I guess "it depends" on who produces the non-Null/greater than zero result set to that query and when. 😀
--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 24, 2009 at 6:47 pm

#965747
RE: Are the posted questions getting worse?

But FG didn't... and won't. It's a waste of time and I'd rather spend the time helping people who don't need to be changed. Heh... pork chops are...
--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 24, 2009 at 5:07 pm

#965729
RE: Are the posted questions getting worse?

RBarryYoung (3/24/2009)
GilaMonster (3/24/2009)
RBarryYoung (3/24/2009)
It's like the old joke:
Q: How many psychiatrists does it take to change a light bulb?
A: Only one. But it takes a very long time 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)

March 24, 2009 at 4:54 pm

#965726
RE: Subtracting a row from the next row

notes4we (3/24/2009)
Lynn. Your code worked fine. I was a bit confused with few columns as the table is huge.
Anyways, I have figured out the reason why it did not work....
--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 24, 2009 at 4:47 pm

#965722
RE: Do DBAs Still Read Techincal Books?

dwithroder (3/24/2009)
I have an hour long commute, so I read.
BWAA-HAA!!! Hopefully, you're not the one driving. 😛
--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 24, 2009 at 4:41 pm

#965719
RE: Which country is best for Outsourcing?

GSquared (3/24/2009)
lmu92 (3/24/2009)
umar iqbal (3/24/2009)
But if you want cheap solution and ... want to save money then it would be INDIA the great. oooooo
We have a saying over here...
--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 24, 2009 at 4:36 pm

#965717
RE: Which country is best for Outsourcing?

karthikeyan (3/24/2009)
lmu92 (3/23/2009)
I'm just wondering:
is your question related to the country to outsource from or to outsource to? :hehe:
Aside of that, you're normally not outsorcing to a country but to...
--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 24, 2009 at 4:35 pm

#965714
RE: Convert alphanumeric to BigInt

One more thing.... can you post the code for the UDF that uses my method... and why are you using a UDF for this? It was meant to resolve...
--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 24, 2009 at 4:30 pm

#965712
RE: Convert alphanumeric to BigInt

And, yes... there's a few more tricks we can try.
--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 24, 2009 at 4:29 pm

#965710
RE: Convert alphanumeric to BigInt

jchandramouli (3/23/2009)
Jeff,
I have used your script both in UDF and as a query. But the problem is when the table records exceeds 10000, there is a performance issue. It takes...
--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 24, 2009 at 4:29 pm

#965709
RE: Convert alphanumeric to BigInt

Chirag (3/23/2009)
Jeff
I mistook this (1230-544,15C5487,132DE78) for a single value rather than 3 values that they are. I assume the op wanted to process one value.
Using a number table would...
--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 24, 2009 at 4:26 pm

#965704
RE: is possible thro a single query

S (3/23/2009)
Jeff, may i know what is the tweak and the failed scenario plz.
I had summed the column that came from the CTE... it caused wrong answers almost as if...
--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 23, 2009 at 10:22 pm

#964943

Viewing 15 posts - 44,446 through 44,460 (of 59,097 total)