Yes, I shouldn't have doubted you. I'll have to re-think the approach to this procedure as I was not aware of the 8k restriction.

Thanks for your response and help.

Jeff:

I don't believe the 8k limit and SQL2 is the problem as in either scenario (starting at 10/01/2005 or 09/01/2005) no data exists for either of these months. In...

Jeff:

After further testing, I have found the following strange situation with the procedure edits you provided:

1) if I use a date range of start date: 10/03/2005 end date:...

Very nice!!! It worked perfectly and I really appreciate the assistance Jeff.

I would have never figured this out on my own and would have probably tried manipulating the records using...

Jeff:

I just read the article you referred to (http://www.sqlservercentral.com/articles/T-SQL/68467/) and I now have an appreciation for you plan to fix the running total by month procedure. You actually update...

Jeff, if you have a better approach, I am all ears at this point. I have been struggling with this procedure for about 4 days now. I also...

Thanks everyone for your help regarding the dynamic crosstab procedure. I was successful in modifying the section SQL3 to provide cummulative values by month using what Jeff provided as...

Jeff, thanks for generating the code to this point. What is missing is the "cummulative" total by month. For example if the following data exists:

ACCOUNT............DATE..............TOTAL

------------- ------------- ...

Jeff, much appreciated if you can help me achieve the desire result of a cummulative total by month for the networth table I require.

Hopefully others requiring cummulative totals will benefit...

Thanks Greg as your idea (END) solved the compilation issue.

I have modified the code and revised the "--===== Create the "static" section of the code (SQL3)" and when...

Thanks for the feeback. I have taken your recommendations and attached the revised MS-Word document in a more standard format and added a section at the beginning for sample...

I made an attempt at modifying the code suggested to support the cummulative monthly networth table but I receive an error when I Execute the procedure -- Msg 102, Level...

Thanks for the information. I believe I would simply need to modify this section of the article with the query content I referenced earlier:

--===== Create the "Mostly Static" section...