locked
query RRS feed

  • Question

  • User-797751191 posted

    Hi

      I have below Data . Using Fifo i want to display output

    Code	Date	Debit Amount	Credit Amount
    			
    1	02-10-2019	20000	
    1	04-10-2019	10000	
    1	10-11-2019	15000	
    1	12-11-2019		40000
    1	14-11-2019	30000	
    			
    			
    3	04-10-2019	40000	
    3	10-10-2019	20000	
    3	10-11-2019		45000
    
    OUTPUT
    1	10-11-2019	5000	
    1	14-11-2019	30000	
    			
    3	10-10-2019	15000	
    

    Thanks

    Friday, December 13, 2019 4:49 PM

All replies

  • User288213138 posted

    Hi jsshivalik,

    Using Fifo i want to display output

    According to your data, I couldn’t understand your requirement clearly.

    Please describe your requirement as much detail as possible, How did you get this output data?

    Why Code 1 has two rows date and Code 3 only 1 row? and please post your table structure.

    Best regards,

    Sam 

    Monday, December 16, 2019 6:09 AM