Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,491 through 41,505 (of 59,102 total)

RE: Complete Newbie Needing Guidance...

Well done, Barry... that should be a "sticky note".
--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 18, 2009 at 8:04 pm

#1067486
RE: Afraid of Help

I agree with the others... personal experience or not, it's not something that should have been brought up because it was, in fact, sexist and inappropriate.
--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 18, 2009 at 7:57 pm

#1067484
RE: Please help me regarding xml output

Sorry... perhaps that was too short of a hint.
Perhaps something like this would do?
SELECT '<?xml version="1.0" ?>'
UNION ALL
SELECT '<?DOCTYPE Cxxxxxxxxxxxx "Cxxxxxxxxxxxx.dtd"?>'
UNION ALL
... your...
--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 18, 2009 at 7:50 pm

#1067482
RE: Please help me regarding xml output

UNION ALL
--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 18, 2009 at 7:46 pm

#1067480
RE: BULK INSERT DATE

You bet. Good luck with your training and thanks for the feedback.
I have to ask, what class are you taking and through which school? The reason I ask...
--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 18, 2009 at 7:44 pm

#1067479
RE: extact last 3 characters from a string

SALIM ALI (6/18/2009)
you could try this, it's a bit crude but works...
declare @string varchar(50)
SET @string = 'ABCDEFGHIJ123'
select reverse ( substring ( reverse ( @string ) , 1 , 3 )...
--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 18, 2009 at 7:30 pm

#1067478
RE: Scalability and performance?

Piotr.Rodak (10/18/2009)
To hire and to consider hiring are two different things Jeff 😉
Heh... one is a waste of time and effort without the other and both are a waste of...
--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 18, 2009 at 7:27 pm

#1067477
RE: Division Problem in SQL 2005

Also, I know it's unnatural, but for the best accuracy, multiply by 100 first, then divide. If you do that, them use 100.0 instead of just 100 and you'll...
--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 18, 2009 at 7:22 pm

#1067475
RE: Division Problem in SQL 2005

robertm-772679 (10/18/2009)
Thanks for the reply,
The numbers were just used as an example. I'm really using integer fields as part of the equation and your right, I did not have 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)

October 18, 2009 at 7:21 pm

#1067474
RE: BULK INSERT DATE

I'm not sure that BULK INSERT supports the DATE datatype. I've not been able to find any documentation one way or the other.
Shifting gears a bit... my recommendation is...
--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 18, 2009 at 7:18 pm

#1067473
RE: Add column to subscriber table

I'm a bit surprised that you could add a column without getting an error about the table being replicated.
--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 18, 2009 at 7:04 pm

#1067470
RE: Investing In Your Career

bitbucket-25253 (10/18/2009)
Charles Kincaid - let me take you further back onto memory lane, we replaced the 709 with a 1401... Remember when coding was not accomplished with a word processor,...
--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 18, 2009 at 6:50 pm

#1067468
RE: A Wish list for the Microsoft Flying Squad

Gift Peddie's good post brings up a real sore spot with me... why does everyone think that the Agile Manifesto says "[font="Arial Black"]No[/font] Documentation" whatsoever? Why does everyone think...
--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 18, 2009 at 6:38 pm

#1067467
RE: Scalability and performance?

"Yes" or "No" are the wrong answers... for the information given in the original post, the correct answer is "It Depends"... 😉
--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 18, 2009 at 6:25 pm

#1067464
RE: alternative for backup/restore for seperate Reporting DB

Jeffrey Williams-493691 (10/18/2009)
Jeff - without knowing which SAN it was, it's hard to say what is actually possible.
Heh... Agreed... Everything is impossible if you don't know what the possibilities 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)

October 18, 2009 at 6:13 pm

#1067463

Viewing 15 posts - 41,491 through 41,505 (of 59,102 total)