Fixed format files with "ragged right data" are someones idea of a cruel joke.

One way to import these is to just import into a single column table and split the...

Thanks, Mike.

Heh... that's funny. Not what I intended but sure is true.

What's in the box with just a slider is a single line of code about 480 characters wide... totally...

Didn't see Kevin's latest post...

That'll be nice to have when 2k8 comes out. I thought you were saying that it's a viable 2k5 solution. Sorry for the...

TheSQLGuru (2/1/2008)

---

This just back from Itzik. He states that the running totals problem can be solved by this construct:

Yes, that would be the missing ORDER BY and ROWS subclauses...

TheSQLGuru (2/1/2008)

---

I posted about this topic on the SQL Server MVP private forum. I will follow-up if anyone there comes up with anything. I specifically asked Iztik Ben-Gan...

Carla Wilson (1/31/2008)

---

Jeff,

Thanks for the great examples on generating running totals. Question: You mentioned that you have to include the "anchor" (or dummy) in the update statement in...

Christian Buettner (2/1/2008)

---

Yet I am not convinced, even if you show me a thousand times that your code works. What I really would like to see is some documentation from...

Thanks for the code, Johan... I'll check it out! And thanks for taking...

Matt Miller (1/30/2008)

---

Well - now that you have SQL server doing your file maintenance - any chance you can figure out how it can turn the coffee on in...

I've gotta agree with that!

Darrin Blunt (1/31/2008)

---

Since you installed SQL 2K5, have you looked into the "OVER" clause (BOL reference: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/ddcef3a6-0341-43e0-ae73-630484b7b398.htm) and the Ranking Functions (BOL reference: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/e7f917ba-bf4a-4fe0-b342-a91bcf88a71b.htm)?

I am curious how...

RichardB (1/31/2008)

---

Pure Awesomeness!

Run over 1.4million records on a 6 level 'hierarchy' in about 10 s - compared to the 'set' solution that takes 1.5hrs...

:exclamationmark:

Oh yes, and validation against the...

Philippe Cand (1/31/2008)

---

I will derail this conversation and give it another spin.

Wether or not something is supported by Microsoft does not make it safer.

It is all about probability and bugs....

James Goodwin (1/31/2008)

---

Did you test using the Clustered Index with the ORDER BY subquery? It seems to me that the ORDER BY Would enforce the order, but since you...