This part is Dynamic SQL:

Select @sql = "Update " + @Tablename + " Set LastNumber ="

+ Cast(@LastNumber as varchar(10)) +

" Where CODE ='" + @secondType +...

Or... If you do this on a regular basis and don't want to keep having to remember the FLOOR(CONVERT(FLOAT,var)) syntax you can write a...

Make sure you close all result sets and your connection and that you destroy the object after closing it:

rsLookup.close

set rsLookup = nothing

rsMain.close

set rsMain = nothing

conn.close

set conn = nothing

These are the...

I answered my own question. I found the following while searching on Google:

http://support.microsoft.com/?kbid=247527

I used the following from that article and it fixed the...

Also, delete a bunch of the columns to the right of your data. Someone may have used a column to the right temporarily and then cleared the data, but Excel still lists...

Converting a string date to datetime format always yields a datetime field where the time portion is '00:00:00.000'. If your ReportedDate field on the database contains full date/time values (i.e....

That trick works because it causes all the rows in the table to be read. "Firehose" mode is in play in EM when you have more rows in the table...

Are you running IIS? When you bought IIS did MS include a free tool for development of web pages? I think not. Have you ever written or updated HTML in Notepad? I...

You don't want to buy VS.Net? Have you priced Crystal Reports Developer lately? And that doesn't include the Crystal Reports Enterprise Server if you want to have automated scheduling and...

Set rstLocations.ActiveConnection = Nothing

    conn.Close

I believe you have to reverse the above statements. You close the connection THEN destroy it. I'm not sure what the effect is of trying...

You know, he's right. The ASP is all server-side. If the concern is that the SQL connection userid and password is being sent...

Interesting idea Tobie, but it wouldn't really work in my particular situation. I have a package that has a workflow like A->B->C->D->E. At step C I want to look at...

Unfortunately the keepers of the web world at our company do not allow application-specific DLL's.

Also, don't use a UDF to convert dates to YYYYMMDD, just CONVERT(char(8),YourDate,112).  The native function (and implicit conversion if the result is going into an int column)...

Also, I'm not sure if the Bulk Insert task automatically sets the database into Bulk-Logged recovery mode, but if not you need to do that else you are logging every...