Anzio,

If you get the chance, could you test MY code against that same 1 million records? I'd love to know a) if it produces the same result, and...

Jeff,

Thanks for the feedback. I'll be referring back to your example code now rather than trying to remember it from scratch. There was a time (back...

UPDATE: just got lucky and generated a 13ms execution time on pattern 1. Subsequent attempts went right back to zero, despite changing to other patterns. I...

Dan,

Despite your explanation, I'm still not sure I completely understand the requirements, but I now have what I think is a solution. I'm not too sure on the...

While that's a nice idea that I prefer to agree with, it fails to account for the DEPTH of the stupidity I encountered, which simply cannot be "explained away" by...

If only I had some evidence for that... Unfortunately, the truth is that it was NEVER going to be easy, so the concern about "making it easy" wasn't...

I agree, although their position isn't surprising when you consider that such advocacy being listened to would result in more jobs for the O-S community.

Steve

(aka smunson)

:):):)

jgrubb (10/27/2008)

---

Amen about the talent...

As rbarryyoung posted, we need more detail on how your data is structured. I look at your "datagrid", and can't determine if the column headings are part of...

I continue to think that a complete statement of the problem coming from the OP has yet to occur. There is no written description of the EXACT process...

Jeff,

Thanks for acknowledging. The only reason I chose to use a loop is because I just didn't have time to go look up the technique that selects from...

Holy OLE_DB, Batman! Looks like I'm way off here. I'd been led to believe by other sources in the past that this wasn't realistic... Mucho...

I'm not sure this is realistic. The nature of a chart is such that it has to expect the specific fields it was designed to look at. ...

It's good to have a working solution, but the performance of a WHILE loop construct for splitting strings could have problems with performance when dealing with a large number of...

I'm pretty sure there's a typo in the previously supplied solution...

Considering your scenario, I AM ASSUMING THAT YOU ARE SURE THAT YOUR QUERY WILL RETURN ONLY ONE VALUE, you can...

I would have thought that installing SQL 32-bit on a 64-bit OS wouldn't have worked at all, but regardless of that, you can't expect a 32-bit ODBC driver to work...