Jeff Moden

Forum Replies Created

Viewing 15 posts - 49,261 through 49,275 (of 59,091 total)

RE: Coming In August

That's all well and good... I guess people who are unaware could use the help of the Date and Time datatypes. What I'm waiting for is the people who...
--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)

July 11, 2008 at 10:30 am

#841686
RE: -dynamic- function to convert several rows of a table to a csv list

Of course your CLR function is going to beat the T-SQL function... you used RBAR on steriods... you need to test against a correctly written T-SQL function for this 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)

July 11, 2008 at 9:43 am

#841626
RE: Deadlocks

David Griffiths (7/11/2008)
BTW this happens even though the SELECT is the only statement in transaction.
Why on Earth would you put a single SELECT in an explicit transaction???
--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)

July 11, 2008 at 9:36 am

#841615
RE: Dumb Question!

GSquared (7/11/2008)
And now I know that you've seen "Harvey". And you know that I know that you've seen it. And I know that you know that 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)

July 11, 2008 at 9:32 am

#841610
RE: Coming In August

GilaMonster (7/11/2008)
A time table - Physics 101, Lecture room 2B, 9am every monday.
Movie schedules. Movie X shows every day this week at 17:00, 20:30 and 23:00
A store list with their...
--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)

July 11, 2008 at 9:31 am

#841608
RE: query tree, show tree structure

There is a method for this in Books Online called "expanding hierarchies"... it has about the same amout of RBAR as a recursive subquery (recursive subqueries are not set based...
--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)

July 11, 2008 at 9:24 am

#841592
RE: First and first character after space should be capital.

First, let me suggest a minor correction to your code... First, try this... (your original code with a twist on the data)...
[font="Courier New"]DECLARE @OutString NVARCHAR(MAX)
SELECT @OutString = ISNULL(@OutString, '') +...
--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)

July 11, 2008 at 8:46 am

#841559
RE: Coming In August

GilaMonster (7/11/2008)
I can see times when only a date is needed, or only a time...
It's probably because I've not had enough coffee this morning, yet... :hehe: can you tell me...
--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)

July 11, 2008 at 6:48 am

#841423
RE: -dynamic- function to convert several rows of a table to a csv list

Leo Mepham (7/10/2008)
Jeff, I work with TSQL all day long, and I do read & enjoy your pieces on here - But I don't see that you've solved his problem?...
--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)

July 11, 2008 at 6:38 am

#841414
RE: -dynamic- function to convert several rows of a table to a csv list

Sorry... I just couldn't imagine why anyone would want a dynamic solution for this... now I see one (pass multiple different CSR parameter lists back to a GUI). Still,...
--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)

July 11, 2008 at 6:35 am

#841408
RE: Dumb Question!

GSquared (7/10/2008)
No. Actually you are completely alone. The rest of us are just paranoid delusions. (By the way, the fact that you have imaginary friends as twisted...
--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)

July 10, 2008 at 8:32 pm

#841209
RE: Date Function

Aw crud... I've lost my mind... the method I was talking about doesn't have a thing to do with Float conversions... here's an (very) old set of tests I did....
--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)

July 10, 2008 at 8:28 pm

#841208
RE: Date Function

GilaMonster (7/10/2008)
Jeff Moden (7/9/2008)
Nicely done, Gail... It shows that the Convert method takes about 4 times longer than the DateAdd/DateDiff method...
If I hadn't done a test, you probably...
--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)

July 10, 2008 at 8:00 pm

#841199
RE: Date Function

AndyD (7/10/2008)
Heh... no wonder you're an MVP.
I think the saying goes, it takes one to know one....
Thanks Andy...
--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)

July 10, 2008 at 7:58 pm

#841198
RE: First and first character after space should be capital.

MentalWhiteNoise (7/10/2008)
I am personally trying to get some practice with a tally table, so here is what I came up with:
Nicely done... if I may suggest, let's simplify the code...
--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)

July 10, 2008 at 7:54 pm

#841197

Viewing 15 posts - 49,261 through 49,275 (of 59,091 total)