For a fixed width file - you should never have a comma in the data.  If you have a comma then it is most likely because you have a column...

The same thing - either return a NULL or convert the date into a string.  Depending on the downstream systems that will be using this - it generally is much...

You cannot define an export that will be a fixed width from SSRS - in order for a fixed width file to be generated you need to know the length...

You are returning a numeric value - and '' is not a numeric value so it will be converted to the corresponding numeric value of 0.  You can either return...

Sorry - I don't understand.

Are you saying you are going to supply the min/max values each time?  If so - then why batch the process and create a loop?  Just...

You are restoring the database to a clean installation of SQL Server...and no, there will not be any cobwebs or dust bunnies in the database.

There will be - however -...

Thank you for your help. I, mistakenly, understood it as meaning that it would create separate transactions in each sub package. I set it to see if it would...

I think there is a problem with this portion:

DELETE TOP (@top)
FROM msdb.dbo.sysmail_mailitems
WHERE (mailitem_id >= 1 AND mailitem_id <= 12000);
SET @rc = @@ROWCOUNT;

Once this code deletes the mailitem_id's...

You have 2 separate statements here - the second statement doesn't know anything about the first statement.

There are 2 ways to do this...use a CTE or a derived table:

Jeffrey Williams

“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll
How to post questions to get better answers faster

Managing Transaction Logs