Replacing:

SET @sql = @sql + 'AND ((SELECT count(a.DOCNUMBR) from ' + @gpdb + 'PM20501 a where a.DOCNUMBR = ' + @gpdb +...

Condolences are definintely on the menu. We get 100 million new records per day (fairly narrow records, thankfully) in one of our tables, and I don't really wish that on anyone.

Would using the "AT" command be considered an acceptable alternative to the Windows Scheduled Task method in your environment? If so, it would be much easier to disable them through a...

I'm very confused as to what you are trying to accomplish, unless you want detail records with a timeslot identifier added.

Why exactly are you wanting to remove the sum and...

The problem is with the way you are using @@ERROR. It only returns the error for the last SQL statement that was executed. What you want to do is store...

In addition to the method DBASkippack outlined, you can also drag the columns from the "Fields" window into the detail line of the table control, and it will automatically put...

Rob is correct in saying that MS is aware of this and plans on taking care of it in the future. As an aside, I've almost always been able to...

It sounds like your source data is a bit "dirty" and you want to clean it up to make it easier for them to work with while they are learning....

While this requires a UDF, it doesn't require a cursor.

Create the following UDF:

CREATE FUNCTION dbo.fn_GetBinList

        (

    @Loc varchar(50)

You can try Crystal Converter. I haven't used it and have no idea how well it performs, but there is a demo available.

The text datatype works quite a bit differently from varchar in SLQ Server 2000. The method it uses to store text columns is to store the actual text elsewhere, and...

The problem is that there are a ton of variables that come into play when making some of these types of decisions. As a start, I'd recommend you read this...

Bill's solution should work quite well if all of the 900 files have the same layout, so they could use the same format file. If not, I'd still try to...

That's the ASCII for a blank that we often use when we don't want spaces trimmed for various reasons. Try:

SELECT Replace(colname, Char(160),'')

...and if you still have problems, then you also have...

Ah, you're using SQL Server 2005 it appears. I don't use it in a production environment at this time, but I think Database mail is send only. I believe that...