TheSQLGuru (2/4/2008)

---

One more 'out-of-the-box' attempt for this topic: could an XML/XQuery guru out there try to tackle the running total problem from that perspective, if appropriate? I have...

Thanks for the compliment and the feedback, Sreejith.

toniupstny (2/4/2008)

---

Hi Jeff. I was challenged to explore using your method(s) as a less resource-intensive approach to the subquery method of getting the TOP n candidates from a...

Lowell...

You don't need to worry about other tables, FK's, and all of those concerns it you use the Celko's nested set model... you also don't have to worry about...

Hard to tell from here... you didn't post any piece of the source file. Recommend you attach the first 100 lines of the text file and post the create...

Hands down for me, the feature they should have spent much more time on is the OVER clause especially when it comes to aggregates. Current version cannot be made...

Heh... gotta love the simple stuff. 🙂 Wonder if it works for leap years...

If it's gotta be a hierarchy and it's gotta be fast, use Joe Celko's "Nested Sets"... Cool thing is, it fits all in one nice table...

Be careful, folks... IsNumeric allows for things like currency symbols, commas, periods, dashes, plus signs, and...

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...