Hi,

Im using a SAP Business One program in this program it will prompt for the dates and that dates will be the variable, it is a built command in SAP...

Hi Jeff,

That is a running balance, I have posted a much clearer data for you to understand better.

Thank you in advance.

REgards,

Clint

Hi Clive,

Im very sorry for the explanation, I have focus on the Running balance or Difference result : Here is the query,

CREATE TABLE [Query_Result] (

[DocEntry] INT,

...

Hi,

Its really amazing how it goes, I really appreciated it at last I can incorporated it with some of my query. How I wish I have a knowledge of yours,...

HI,

Yes im using SQL 2005, I dont have problem with code, my problem is the using Declare in the main query. I want just SELECT Statement in my query, is...

Hi,

Thank you very much for the fast reply, It seems I cant generate the sample table you gave it has an error.

Im new to this setup, Im purely an SQL...

Hi,

Sorry I make things complicated,

Its not allways the end of the month it depends on the date range being inputed example:

if date entered is 2/12/08 to 2/16/08 then the result...

Hi Jeff,

Sorry for the incomplete details. I have already posted a much clearer example hope that will be understand.

Thank you very much.

Regards,

Clint

Hi Dugi,

Sorry for the short details. Here's to elaborate :

Assuming the date range is from 2/1/08 to 3/1/08

Date DocNum ...

HI SSC,

At last you have solve the problem, the MAX(DocNum) must be in the WHERE clause statement not on the SELECT statement it filter it all.

Thank you very much!

regards,

Clint

Hi SSC,

If I will do the MAX(Price), the data will get the MAX(Value) of the field, example

1 4

1 5

2 ...

Hi SSC,

Sorry I mean row if you take you example it will take like this :

DocNum Price

1 ...

Hi Christo,

Yes that's my point at last I deliver it correctly for you to understand, I will try this query. Thats correct point of view of yours, I can get...

Hi,

Yes I know the function MAX, but it seems it cant get the correct data in the row of Price, If I will used the MAX in my Field DocNum...