Jeff Moden

Forum Replies Created

Viewing 15 posts - 46,696 through 46,710 (of 59,095 total)

RE: Concatenate issue with datetime

Heh... "We don need no stinkin' cursors"... 😛 ... especially in SQL Server 2005. Look at all the difficulties you're having making one do the things you want....
--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)

December 10, 2008 at 7:57 pm

#910786
RE: Stored Procedure to generate work day prior?

Ron, just an FYI... the code came through with no carriage returns.
And thanks for the awesome compliment! :blush:
--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)

December 10, 2008 at 6:48 pm

#910769
RE: datetime and get date only

Yeah, but why do you want to format the code is SQL? Unless you're formatting to write to a file, then you should let the formatting be done in...
--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)

December 10, 2008 at 6:21 pm

#910766
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

ggraber (12/10/2008)
Jeff Moden (12/10/2008)
I already did such a comparison in Part 1 of this series, Goldie. 😉 Of course, I don't mind if someone else does a head-to-head comparison.
Jeff,...
--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)

December 10, 2008 at 6:07 pm

#910763
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Madhivanan (12/10/2008)
Nice Article Jeff
Here is mine
http://sqlblogcasts.com/blogs/madhivanan/archive/2008/08/27/dynamic-pivot-in-sql-server-2005.aspx
Thanks for the feedback and the link, Madhivanan.
--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)

December 10, 2008 at 5:22 pm

#910757
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

I already did such a comparison in Part 1 of this series, Goldie. 😉 Of course, I don't mind if someone else does a head-to-head comparison.
--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)

December 10, 2008 at 5:17 pm

#910755
RE: Concatenation of multiple records

Heh... nah... I've got a couple of folks like that at work... they're actually pretty nice if you can get them to stop talking about their damned hump! 😛
--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)

December 10, 2008 at 5:13 pm

#910753
RE: OPENROWSET - To use or not to use.

I concur... haphazard formatting is tough on anything that expects a consistant format. OPENROWSET and Text Linked Servers do a pretty job job there.
Of course, when you have haphazard...
--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)

December 10, 2008 at 5:06 pm

#910751
RE: Need to copy data from table to table with update statement

Garadin (12/10/2008)
Egad I hate those commas on the left.:hehe:
(I know I know, it makes it easier to comment out lines and such, but I still hate it)
I do put each...
--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)

December 10, 2008 at 5:02 pm

#910749
RE: Deleting rows and later reusing the Identiify value

Shoot (no pun intended)... it was the counseling that caused the disorder. 😛
--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)

December 10, 2008 at 4:57 pm

#910747
RE: Are the posted questions getting worse?

Amazing story, indeed. Lynn is lucky to be alive never mind without having any broken bones.
Me? I'd have just shot the car. 😉
--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)

December 10, 2008 at 4:48 pm

#910746
RE: Error processing

Patricia Monreal (12/10/2008)
Jeff and Jeffrey,
Thanks to both of you. That seems like a very doable solution that will avoid the duplication. I really appreciate your help.
Pat
Thanks for the feedback, Pat......
--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)

December 10, 2008 at 4:42 pm

#910743
RE: Error processing

Nah... I'm with ya, Jeff. Temporary insanity on my part. Ignoring the dupes is intentionally destroying data in an unaccountable fashion and shouldn't be used. Sorry 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)

December 10, 2008 at 6:20 am

#910278
RE: Database growth

madhu.arda (12/10/2008)
Hi Jeff,
Iam curious to know why the available space for the database was showed as zero in enterprise manager and negative value when I ran sp_spaceused before running DBCC...
--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)

December 10, 2008 at 6:03 am

#910267
RE: Are the posted questions getting worse?

Nah... the worst posts ever (there were 2 at the same time) both beat 209 by a mile. Remember {shudder} "Bankers Rounding"? Even some of the good guys...
--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)

December 10, 2008 at 5:55 am

#910257

Viewing 15 posts - 46,696 through 46,710 (of 59,095 total)