Thank you

Thank you for your interest. When there is a different issue, different values ​​come up. Success is achieved through a single code.

thanks

('0002','2024-11-01', 'IN', 10, 75, 750, 10),...

I am trying to find a solution in the first code I shared, but it is slow. I think it can be solved with WITH.

I reviewed the link. Thank you....

Excel

Thank you

---- 2024-12-16 00:00:00.000

---- (85 PRICE * 4 AMOUNT) + (77.8571428000*5)/ BALANCE=9     OUTCOST = 81.0317460000

---- 2024-12-18 00:00:00.000

---- (95 PRICE * 2 AMOUNT) + (81.0317460000*9)/ BALANCE=11     OUTCOST = 83.5714285455

Hi,

EXIT means exited amount

---
WITH CTE_LINES AS (
    SELECT 
        CODE, DATE_, TIP, AMOUNT, PRICE,OUTCOST,
   ...

• This reply was modified 6 months, 3 weeks ago by  meryemkurs072.

I WRITE A QUERY BUT IT RETURNED THE WRONG RESULT

help please

WITH CTE_LINES AS (
    SELECT 
        CODE,...

This code is working slowly on current system 2008, I changed the data type to decimal(20,10)

I am updating data to the OUTCOST field. Since I'm doing this in a loop,...

Thank you.

Under normal conditions, when a row goes negative, the query lists the rows before that row.

However, if a movement has never been negative, it does not bring the relevant...

Hi

Thank you

Non-negative Id not coming?

What would be the reason

ıd = 3

If(OBJECT_ID('tempdb..#DETAIL') Is Not Null)
Begin
    Drop Table #DETAIL
End
 

CREATE TABLE #DETAIL
   (
 ...

• This reply was modified 2 years, 4 months ago by  meryemkurs072.

Thank you for your interest.
The result of the query will be as follows. I want to close the debt.

TrxnID MarkedAmount                 MarkedTrxnID
1 ...

I am working on a complex problem - Bill Marking for Ageing Analysis. The data is like this :

Source Table :

TrxnID, Date, CustomerID, DebitCredit, Amount

Sorry.
I made a late return :crying:
Thank you really for your attention. 😉

Is there another way to secure the query ?     
I understand Clr...

Thank you so much.

I'm still not understanding how you read the ASSEMBLY code

Thank you Jeff, Solomon

Are there other solutions for query encryption?