Two things, unfortunately I don't have time to actually write it myself as I am trying to leave for work.

You need to convert the From datetime to a character string...

Problem I see is if you are basing this off the last payment. Do you ever look back at the initial payment date?

For the most part, Jeff, I agree. However, the new TIME and DATE data types in SQL Server 2008 will make it easier to build date and time dimensions...

Nevermind, Gail beat me to it.....

DECLARE @sql nvarchar(max);

DECLARE @FromDate char(8);

DECLARE @ToDate char(20);

DECLARE @PathFileName varchar(2000)

SET @FromDate = 20080101;

SET @ToDate = CONVERT(CHAR(20),GETDATE(),112);

SET @PathFileName = 'D:\SalesHis\SALES.'+@FromDate+'%''.txt'

IF @ToDate > @FromDate

BEGIN

...

First, by adding the DISTINCT to your select statement in your cursor definition, you eliminated all duplicates.

Second, this will not scale to very large tables, and there is most likely...

That makes sense. I guess I'll start following that lead as well.

First of all, put the criteria for the delete in the delete statement and do it in a set-based manner, not a RBAR (Row By Agonizing Row) method.

Here is a...

First, WHY?

Second, set based solutions in SQL Server will work faster and scale a lot better than a cursor based solution.

Please read the article below about how to post questions...

So, after all of this, you are actually trying to get the end of each month?

Go here: http://extras.sqlservercentral.com/prettifier/prettifier.aspx

Also, read this: https://www.sqlservercentral.com/blogs/philfactor/archive/2008/10/07/rendering-code-nicely-in-blogs-and-forums.aspx

Nice catch Sergiy! :w00t:

Based on what you provided, however, this is where I would start:

insert into dbo.table (

...

First, again, all the code is better than part of the code. In this case, however, I have a question, is this particular question based on a trigger fired...

I have to agree with Jeff. Keep the temporary tables and figure out how to get rid of the RBAR in your code. It's all the looping that...