I have found the cause of the error. The problem was that more memory was being used that what was available in the procedure cache of SQL. The reason why...

Thanx RBarryYoung, that's exactly what I was looking for. Must have been having a slow brain day when I popped the question.... 😉

Here is the base table i'm working from plus some test data:

USE [Test]

GO

/****** Object: Table [dbo].[ITR1] Script Date: 06/23/2008 17:03:06 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING...

As stated earlier, my main aim is to retrieve the Amount Applied by each document to specific Invoices.

The Applied amount should be calculated by asking the Dcoment being processed the...

Hi Elmer,

I'm also not an SQL legend by any standards but you might try the following:

Select T.ID, max(T.Amount) as [MAX], min(T.Amount) as [Min],

(Select Sum(TP1.Amount)/count(TP1.ID) from ITR1 TP1 where TP1.ID...

Hi GSquared,

Yes there is a Document Date as well as a "LineNum"

(The Table makes use of a composite key existing out of ReconNum & LineID)

But I still don't...