No... didn't think that would matter... Thought that was just for compares. I'll give it a try.

Tough client...

Does the client allow you to use temp tables?

The problem is with the data and BCP/Bulk Insert... it doesn't like it when the format changes like with some rows having a quoted first field and some not (because...

Sure... using slightly different method...

--Create a linked server.

EXEC sp_addlinkedserver txtsrv, 'Jet 4.0',

'Microsoft.Jet.OLEDB.4.0',

'c:\temp', --<<LOOK!!!! CHANGE TO DIRECTORY WHERE FILES ARE AT!

...

Heh... ye think? 😉

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