Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,431 through 44,445 (of 59,097 total)

RE: Which country is best for Outsourcing?

Alan (3/25/2009)
I have worked with India, Indonesia, US and Korea.
My limited observations (a couple of hundred tasks):
India - we had 5 teams I would send the same task 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 27, 2009 at 5:35 pm

#967802
RE: Which country is best for Outsourcing?

umar iqbal (3/27/2009)
Doc,
I need to know this myself how can you stop companies from outsourcing. IBM recently fired 5000 US employees this thursday and hired 5000 in INDIA.
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 27, 2009 at 3:03 pm

#967757
RE: Are the posted questions getting worse?

Lynn Pettis (3/26/2009)
You must answer with no foul or abusive language.
BWAA-HAAA!!! ... who the hell made THAT rule? This IS the thread. 😉
--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 26, 2009 at 8:04 pm

#967182
RE: Are the posted questions getting worse?

Grant Fritchey (3/26/2009)
Three different single malts, some J&B and this funky Japanese stuff that a friend got me for my birthday, all downstairs, quietly whispering my name.
I didn't make it...
--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 26, 2009 at 8:01 pm

#967181
RE: Are the posted questions getting worse?

Lynn Pettis (3/26/2009)
Having found out he lives in Denver, we just need to get him to start attending the SQL Server Users Group meetings up there. Perhaps by interacting...
--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 26, 2009 at 4:05 pm

#967117
RE: Are the posted questions getting worse?

Chris Morris (3/26/2009)
Luke L (3/26/2009)
Best part is one of the local wineries grow radioactive grapes for their wines, or so the story goes... Never tested it to see if it...
--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 26, 2009 at 4:02 pm

#967115
RE: Are the posted questions getting worse?

Grant Fritchey (3/26/2009)
Bob Hovious (3/26/2009)
CONGRATULATIONS, ROY !!!!!
YOU are Mr. 3000.
In honor of this momentous occasion, you get to buy beers for the whole...
--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 26, 2009 at 3:58 pm

#967113
RE: Using xp_cmdshell

RBarryYoung (3/26/2009)
Jeff Moden (3/26/2009)
RBarryYoung (3/26/2009)
"Not working" doesn't tell us very much. Is there an error message?
Dang... now I'm disappointed... I was sure that you could read minds... 😛
Well, I do...
--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 26, 2009 at 3:52 pm

#967105
RE: Using xp_cmdshell

RBarryYoung (3/26/2009)
"Not working" doesn't tell us very much. Is there an error message?
Dang... now I'm disappointed... I was sure that you could read minds... 😛
--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 26, 2009 at 3:38 pm

#967097
RE: Using xp_cmdshell

krushnasahu (3/26/2009)
I have some more doubts.
Actually I need to run an exe file from stored proc.
So, I wrote the stored proc like:
create proc callExe
As
EXEC xp_cmdshell '\\192.10.10.245\E:\PrintToPDFConsole.exe'
In this 192.10.10.245 is another...
--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 26, 2009 at 3:37 pm

#967096
RE: Concatenating Field Values

mark_92708 (2/27/2009)
Thanks Jeff for the feedback. I did look over your article prior to coming up with the solution I used. My only challenge with the approach in the article,...
--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 26, 2009 at 3:05 pm

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

Viewing 15 posts - 44,431 through 44,445 (of 59,097 total)