Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,061 through 45,075 (of 59,101 total)

RE: "Select Where In" using a parameter?

Jeff Moden (3/31/2008)
GSquared (3/3/2008)
Just did some tests.
The XML version is faster, significantly so, than the Numbers table version, for parsing out a string.
Any bets? 😉 Post your test data...
--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)

February 21, 2009 at 12:03 pm

#948194
RE: Are the posted questions getting worse?

BWAAS-HAA!!! Now you know why I like Tinker Toys... it's real easy to find the red sticks. 😛
--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)

February 21, 2009 at 11:51 am

#948191
RE: Are the posted questions getting worse?

I agree with that... searchs on this forum, ummm... suck. (Sorry, no nicer way to say it). How can we tell the users to do a search when we...
--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)

February 21, 2009 at 10:55 am

#948184
RE: Are the posted questions getting worse?

In high school and before, we'd play a bazillion different card games... mostly Poker, Spades, and HiLoJack. At home, it was Pinochle, graph paper battleship, graph paper road race,...
--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)

February 21, 2009 at 9:53 am

#948176
RE: Are the posted questions getting worse?

GilaMonster (2/21/2009)
After yet another case of someone just posting a query and asking why it was slow (If I could tell, I'd have some really, really happy clients), I'm contemplating...
--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)

February 21, 2009 at 8:23 am

#948166
RE: comma seperated parameter

Ninja's_RGR'us (2/21/2009)
Credit is due and all good, but that still does not answer the question....
True enough... we were waiting on some test data so we could show some tested code.
[font="Arial...
--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)

February 21, 2009 at 8:18 am

#948165
RE: Are the posted questions getting worse?

Lynn Pettis (2/20/2009)
I'm at an AFA v Holy Cross Hockey game (4 - 1 AFA after 2 periods) and reading this thread on my BlackBerry. Talk about needing 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)

February 20, 2009 at 10:34 pm

#948106
RE: comma seperated parameter

Thanks for the kudo, Grant. 🙂
--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)

February 20, 2009 at 9:51 pm

#948103
RE: calculate Time Hours

So, does it actually work for...
Admin 2009-02-18 18:23:43.437 2009-02-19 12:12:19.357
--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)

February 20, 2009 at 9:48 pm

#948102
RE: How can i split my input variable string and compare?

Recursion is sexy... and, recursion is slow. I recommend avoiding it whenever you can. The following code takes 93 CPU milliseconds to parse 1821 elements on my humble...
--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)

February 20, 2009 at 9:42 pm

#948099
RE: How can i split my input variable string and compare?

Edward Boyle (2/18/2009)
Below is a function based on recursion for parsing a string with a specfied delimiter
Go
If Object_id('GmtGetTokens') is not null drop Function GmtGetTokens
GO
Create Function dbo.GmtGetTokens(
@AllElse Varchar(8000),
...
--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)

February 20, 2009 at 9:08 pm

#948095
RE: Statistics calculation

Simple aggregates with GROUP BY should do the trick.
--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)

February 20, 2009 at 8:46 pm

#948093
RE: Are the posted questions getting worse?

Bob Hovious (2/20/2009)
I pay them no mind. It's always good for ME 😉
It's Friday night and we're online. We have GOT to get lives, Jeff.
Heh......
--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)

February 20, 2009 at 8:37 pm

#948088
RE: Are the posted questions getting worse?

Bob Hovious (2/20/2009)
Venting is always good.
Then why are so many shocked at a "lift your leg and let it rip" fart in public? 😀
--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)

February 20, 2009 at 8:21 pm

#948085
RE: How to add cost percentage to product

Sorry... I got a little busy... looks like you've got a good answer with the UNPIVOT solution.
--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)

February 20, 2009 at 7:27 pm

#948069

Viewing 15 posts - 45,061 through 45,075 (of 59,101 total)