BULK INSERT is absolutely the fastest... but I don't believe that it supports importing Excel Spreadsheets.

Even if it did, if someone has the spreadsheet open, SQL Server will not...

Antonio...

When you say ".RDL", are you talking about a "CLR"?

This is actually very similar to the classic "paging problem"... I'll see if I can whip up an example tomorrow (today actually... it's after midnight here) ...

lalonacademy,

I'm not sure how you got the data into the table, but consider this... BULK INSERT with a format file to handle your strange delimiters will load 5.1 MILLION 20...

Ok... here's my entry for the virtual beer...

1 million rows... half are the first row and half are the second row that the Op posted. My goal was to...

Thanks guys... I knew it had to be something simple :blush:

Sure, I'm good for a virtual beer and pretzels... Million rows ok with you? 🙂

lalonacademy (4/1/2008)

---

I need help to create a script that would perform text parsing from a table.

I have a text (words separated by the symbol '&' (symbol ampersand). I need...

Heh... I love it... someone gave me the ultra low mark of 1 star and didn't even have the nerve to tell me why.

Would it help if I told you...

Thanks, Antonio...

While I agree that the XML concatenation method is very fast, I've found that the XLM parsing method is a bit slow compared to a Tally Table or cteTally...

Just checking to be sure... do all the rows have exactly the same number of "fields" and all the rows are always in the same basic format?

Gosh, I hate the idea of replacing one form of recursion with another, but the recursive CTE will at least handle a set even if it is hidden RBAR.

GSquared (4/1/2008)

---

The nested sets version is very fast on queries, but essentially requires either the ability to see the future, or immensely complex rebuilds to deal with that kind of...

Heh... you can tell I've watched way too many info-mercials! 😛

No... disparate transaction types should live in their own tables. Rules of normalization such as no duplicates and no nulls should...