Like everything else, it depends... how are the underlying tables index and does the query use them? What size is TempDB and will it...

Heh... good thing the OP ignored your original suggestion right up to...

Heh... glad to see a kindred spirit.:)

True enough... but my big question would be, why would anyone store HTML in a database?

I missed this article when it was first published... Nicely done Jacob! Not only was it a good article, but the followup posts are great, as well. You...

Heh... only every other Tuesday. 😛

What is the basis of your Bi-Temporal design?

I'd question the database designer as to why decimal values were stored as strings to begin with.

OR!... you can simply concatenate the values together in a nice long string up to VARCHAR(8000) in SQL Server 2000... see the following link for both the method and some...

No... it should be ok.

Haven't tested it because no data... but this should work SELECT ID, Name,

CASE SUM(Revenue)

...

helloanam (8/12/2008)

---

I am facing a strange problem which i havent experienced before. I am importing a text file using SQL Server Import Export WIzard in Mgt Studio.

The columns in...

Heh... sorry Peter... I just wanted to make sure no one adopted recursion as a new paradigm because of...

Are you exporting any other columns with the HTML?

Paul DB (8/12/2008)

---

Jeff Moden (12/5/2007)

---

Heh... sorry about that, but at least I got your attention....:D

I should have mentioned that I'm working on an article (may end up being two) that...

andrew gothard (8/12/2008)

---

Once in v7 where I was doing some rather complex statistical work and the cursor was faster. Other than that quick and dirty DBA type rubbish looping...