Christopher Ford (2/19/2008)

---

Eh.... What? :blink:

---

Frank & Kevin both bring up some very valid points though...

TheSQLGuru (2/19/2008)

---

Can't say I agree with that title. Just did a first visit at a new client last week for a performance review. They had a relatively new...

Heh... not quite that "whipped"... I've been offered the chance to do a remote thing... just not sure I want to... they pretty much put the screws to about 350...

Sure, Bob... If you know how to use a format file, you're well ahead of the game...

Take a look at the example data you gave...

1234, "some data here", "John "jack"...

You bet, Sengar... thank you for the feedback.

It would be interesting to know, though... just why do you need to force a format of 2 decimal places with truncation instead...

Try this... no "SA" privs required...

EXEC Master.dbo.xp_Dirtree 'C:\',1,1

... can be loaded into a table and filtered for use with something like BULK INSERT. Only advantage over what Doug posted...

Now, that's the way I like to see an article... "Alice's Restaurant" style... full of actual tests with "circles and arrows and a paragraph on the back".

Heh... LMAO! Now that's funny, Chris! Ya know... I bet it would sell like hotcakes with a title like that!

With some great mixed feelings, I won't be joining my outfit in NC... the love of my life for the last 22 years has followed me a couple of times......

I'd be real interested in knowing what kind...

Christopher Ford (2/18/2008)

---

BTW, wouldn't the RowID go increasing by date in this test case?

98% of the time, you wouldn't run into a situation where RowID 9876 is an earlier date...

Christopher Ford (2/18/2008)

---

For totals that involve groups, I wonder if you can split the work in half.

A multi-thread CLR?

Where the first query get the first half while the second query...

Matt Miller (2/18/2008)

---

Jeff Moden (2/18/2008)

---

Heh... do be a bit careful... my questions, although certainly appropriate, are likely to be taken as a high insult. 😉 I know this because...

Ummm... all of that's fine, but it's all RBAR (see my tagline for the explanation).

I assume that you're just a bit new to this. What would be...

First, I love your "handle"... "Ivana Noh"... that's outstanding. Someday, ya gotta tell me at least your first name.

Your observation is spot on... It would be MUCH better to...