Jeff Moden

Forum Replies Created

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

RE: Are the posted questions getting worse?

Heh... I'm with Michael... you don't need to call someone a name to hit them with the pork chop that has the code stuffing.
--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 10:31 pm

#965780
RE: Is it possible to simulate the cross apply function?

Cool... would you mind posting your function... we may be able to make an improvement here and there.
--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 10:21 pm

#965778
RE: Convert alphanumeric to BigInt

Wow.... you're right. I've never seen the XML concatenation method run so slow. Now that we have the test data you want, I believe we can do 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)

March 24, 2009 at 10:18 pm

#965775
RE: Update column as an identity

Correct... ROW_NUMBER() does not exist in 2k.
Lowell's code looks good to accomplish what you want, I believe. The question would be, what's in the table with the number 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 8:04 pm

#965765
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

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