Here is a solution for your test data. However, it doesn't address the question of how to control the ordering of the [Text] column. Does this table have an identity...

Do you have any column that identifies the ordering of the [Text] column within the [File],Main columns, or is the [Text] column to be sorted alphabetically?

For those that enjoy this sort of thing, here is a pretty good comparison of the various running totals methods available.

http://www.sqlperformance.com/2012/07/t-sql-queries/running-totals

White

Edit: as to it's purpose... the intended purpose of...

This morning.

The newsletter says that he's on vacation.

SQLRNNR (8/8/2012)

Lynn Pettis (8/8/2012)

SQLRNNR (8/8/2012)

D.Oc (8/8/2012)

LOL, made me laugh 🙂 Although it is not appropriate for this kind of forum

Fox News neo-nazi propaganda, you gotta love...

Hugo Kornelis (8/6/2012)

I deliberately didn't include that link, as I think the information is presented there in a very confusing way....

I've sent Steve a PM about...

For those that don't get the simple-talk newsletter, Grant has an awesome article published in today's newsletter. Catch it at http://www.simple-talk.com/sql/performance/the-seven-sins-against-tsql-performance/L[/url].

First, I agree with A-D of what...

For what this question was intending to do, it was a good question. Too bad about the string length issue causing controversy.

bitbucket-25253 (8/3/2012)

WayneS

I was checking SQLSat156 (Providence, RI) to see if the speakers had been selected yet, and I count 5 Threadizens that have submitted for it. Sure would be nice...

I was checking SQLSat156 (Providence, RI) to see if the speakers had been selected yet, and I count 5 Threadizens that have submitted for it. Sure would be nice if...

Great article Dwain. I hadn't thought of trying the value constructor in the apply operator before... something new to play with.

Thanks!