Unless you've changed the recovery model of TempDB to something it shouldn't be (i.e. anything other than "simple") - it should automatically truncate as transactions commit.

So - the trick is...

I have both 2000 and 2005 on this box, and Xp_msver works under both. What error are you getting when you run it on 2000?

...all versions except the "plain jane" SQL Express... the SQL Express with Advanced services does have it.

Have you considered using XML to do this - it would be fairly easy to set up a standard "header" stucture in an XML file describing the rest of the...

For what it's worth - xp_MSVer returns the number of CPU COREs (since they are perceived as separate processors by the OS).

On a slightly different note - where...

I thought of that one, and from the little I can see - it looks like that .NET notation doesn't work.... Have you tried to throw on an ISNUMERIC thing...

What does the DB say is in the field erroring out? (i.e. what's the value causing the #error?)

Try this one on for size - use the new-fangled TRY/CATCH to do this.

Cut it into chunks and run the operation on a chunk at a time.

This presumes...

If you want to have both aspects covered - here's the extra info you might need:

select

so.name tablename,

sc.name columnname,

sc.colorder columnorder,

sc.length columnsize,

st.name columnType,

st.variable columnVarLength,

sc.isnullable columnIsNullable

from syscolumns sc

inner join sysobjects...

Pretty close to accurate too - disconnect the session and the table gets wiped:)

That's essentially how I coded it (after which a tie on quarters, it goes to the rep with the "lowest name" alphabetically).

A Primary key is the field used as the "anchor" for relations to other tables. In other words, it's the value that is put into a field in another...

I just double-checked - and the promote does work, no matter what the order is (meaning - int compared to varchar converts all values to INT, whether the varchar is...

Then unfortunately your choices get a bit harder.

The manual way to do that would be something like:

select name, code, T1 as Amount, 'T1' as type

from mytable

UNION ALL

select name, code, T2...

In order to make the results consistent, we'd need something reliable to tell us which of the two records is "first". Is there something like an identifier column that...