Jeff Moden

Forum Replies Created

Viewing 15 posts - 32,791 through 32,805 (of 59,099 total)

RE: Are the posted questions getting worse?

Lynn Pettis (8/19/2011)
A beautiful last day of work. I was able to sleep in, and when I did get up I did laundry, got my referee gear out 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)

August 20, 2011 at 7:17 pm

#1371107
RE: Removing redundant information

doug 40899 (8/19/2011)
and then run it, here is a sample of some of the results I get:
HEART HOSP - MIDIDDODI 2011-08-19 07:00:00.0002011-08-19 13:00:00.000Added
HEART HOSP - MOORE 2011-08-19...
--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)

August 19, 2011 at 2:21 pm

#1370977
RE: How to convert this 'dd-mm-yyyy' to 'yyyy-MM-ddTHH:mm:ss.fff' string format?

forsqlserver (8/18/2011)
Thanks Rozema and chris: My requirement is:
I have two databases one is of HRMS application and another for forefront application.Now some table data comes from HRMS database to forefront...
--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)

August 19, 2011 at 2:15 pm

#1370975
RE: Hidden RBAR: Counting with Recursive CTE's

David Burrows (8/19/2011)
Another great article Jeff 🙂
Jeff Moden (8/8/2011)
... some would say that I, indeed, have no taste buds
Surely you meant 'no taste' 😛
heh... that, too! And don't call...
--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)

August 19, 2011 at 2:07 pm

#1370967
RE: Lower Tempdb Initial file size

abhishek_dwivedi03 (8/19/2011)
I am not able to do it even when i am trying to do it in my base machine
Assuming that you mean just changing the Initial Size as 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)

August 19, 2011 at 2:05 pm

#1370966
RE: Single row to multiple columns

Eugene Elutin (8/19/2011)
Jeff Moden (8/19/2011)
That's because someone made it difficult. See if you understand the following modifications...
Not at all...
It was because someone wanted to turn 1,2,3,4,5,6,7,8,... into 1,2,3,4,1,2,3,4,...
not 0,1,2,3,4,5,6,7,......
--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)

August 19, 2011 at 1:12 pm

#1370959
RE: Stored Procedure with Totals

Phil Parkin (8/19/2011)
..Please see the farticle at
Got a slight wind problem Jeff? 😀
Heh... I've made that recommendation so many times that it has, indeed, become a bit of a naturally...
--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)

August 19, 2011 at 1:06 pm

#1370954
RE: Are the posted questions getting worse?

WayneS (8/19/2011)
Jeff Moden (8/19/2011)
GSquared (8/19/2011)
Jeff Moden (8/18/2011)
I wonder if the new splitter from the "Tally OH!" article would have helped here. I've not done any heavy testing with 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)

August 19, 2011 at 1:03 pm

#1370953
RE: Are the posted questions getting worse?

Kiara (8/19/2011)
Jeff Moden (8/18/2011)
I wonder if the new splitter from the "Tally OH!" article would have helped here. I've not done any heavy testing with it against VARCHAR(MAX) but...
--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)

August 19, 2011 at 1:01 pm

#1370952
RE: Are the posted questions getting worse?

GilaMonster (8/19/2011)
Jeff Moden (8/18/2011)
I've never used them. I've always used something else because they didn't use to be available. Not sure I'd actually use them, either, beccause 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)

August 19, 2011 at 12:58 pm

#1370951
RE: Are the posted questions getting worse?

GSquared (8/19/2011)
Jeff Moden (8/18/2011)
I wonder if the new splitter from the "Tally OH!" article would have helped here. I've not done any heavy testing with it against VARCHAR(MAX) but...
--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)

August 19, 2011 at 11:58 am

#1370928
RE: If you could use xp_CmdShell securely, would you?

GSquared (8/19/2011)
Jeff Moden (8/18/2011)
@Gus,
Dang... I knew there was something else I wanted to ask and forgot it for a moment. If it's not obvious that I'm no SSIS-Ninja, let...
--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)

August 19, 2011 at 11:49 am

#1370926
RE: How to import multiple CSV files.

dji (8/18/2011)
... and many times quicker than using openrowset from within a vb.net programme to achieve the same results
Heh... just about anything is faster than that. Why on Earth...
--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)

August 19, 2011 at 2:04 am

#1370575
RE: Single row to multiple columns

That's because someone made it difficult. See if you understand the following modifications...
create table W
(
ID int,
acc_no varchar(5),
val varchar(255)
)
insert into W
select 100,'a1','D,20987987.5%,,A account is being linked to B account'
union...
--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)

August 19, 2011 at 1:52 am

#1370569
RE: Using Identity Field as my main relation in joins

Heh... I wondered what the withdrawal was. Now I know. 😀
--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)

August 19, 2011 at 12:59 am

#1370556

Viewing 15 posts - 32,791 through 32,805 (of 59,099 total)