Was there some reason you couldn't have done this with a transformation that used a SQL Query, rather than a table, as its source?

Could you select the TOP COUNT(*)-3 using the reverse order by?  Might have to use a variable and an extra query to get the count... I doubt SQL would like ...

Check into Costa Rica!  I'm planning to go early spring.  Don't have any links for ya, but I'm sure Google will.

This line is bad, too:

set sqlstmt=nothing

sqlstmt isn't an object, so you don't "set" it.

I don't think you want this line in there:

conn.execute(sqlstmt)

If it isn't actually causing an error, it's not doing anything constructive, that's for sure.

Oh I don't agree with that... one could as easily say, "If you are tired of hearing people moan about the QOD, don't read the posts." 

But frankly I'm glad...

Hey Steve,  is there anything I can do to help with QA on the QOD?

My question is, in this line:

UpdateText tblEmailTemplate.EmailBody @ptrval 3831 0 '...remainder of French text to append to end of message...'

why is the insert_offset 3831?   What's so magical about that number? ...

Exactly.. I didn't see any rows in the table where ColumnA = "Where", so I was quite certain that it would return no rows. 

I don't think the wording of...

Well, of course there's the cube-browser that comes built in with Analysis Services.  The authors of the book I'm currently reading (which I won't recommend) are fond of Intellibrowser by...

This definitely sounds to me like a job for OLAP.  Once you have an OLAP representation of the database, there are a number of cube-browsers that savvy non-techies (sounds like...

Hey Steve is there any way that I can help out by doing the testing and QCing of the QOD?

Just wanna add a "Yeah!" to all the other voices saying "what a stupid question."   No MIDDLE JOIN in BOL...'nuff said.

Kinda depends where on the East Coast.  If it's the Carolinas, no problem.  New York, you might some extra time to get situated.  South Florida:  good luck!

Actually, there is one decent argument against storing files in the file system and just storing pointers to the files in SQL...and that is that if someone or something ever...