Trans_ID is primary key in #tbl_transection,i could not more understand ,which you mentioned above.any query please ask to me.

HI Steve Collins,

can you use below date filter with above query then check correct output ,that query is giving same output

  Declare @startDate date='2021-01-19' 
 ...

• This reply was modified 1 year, 1 month ago by  akhterhussain80. Reason: More Detail define to understand me requirement

it is resolved

• This reply was modified 1 year, 1 month ago by  akhterhussain80.

Hi Steve Collins,

Below image , in which i mentioned in red ,that Data must display ,Item_Name A is repeating two time,which should not be repeated.

'In your query two issue i found.

First (If the opening is less than zero - it would show up in the Credit column and the opening balance would be negative.)...

in small bale weight column where 200 is coming ,there will come 0 and Mix Rummage weight will be 200..

there is not null weight in Probale table ...as it is coming in  small bale weight

thanks for your reply but i am still confuse that how it will use in my case.

You need to understand deeply

this stored procedure is separating INTIME and OUTTIME from column to rows.

January 25, 2019 at 11:17 pm

#2020190