Loading

Stored procedure to calculate Batch Wise Item Cost

Stored procedure to calculate Batch Wise Item Cost

Ramco Ramco

2y886.NET

Hi

Is there any Stored procedure to calculate Batch Wise Item Cost

Thanks

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Naveen Kumar2y ago
Please be more specific with your question.

As per my assumption, you will be having a tables like Batch and Item, joining those you can get the item cost.
```
SELECT
    B.BatchID,
    I.ItemID,
    I.ItemName,
    SUM(B.Cost) AS BatchTotalCost
FROM TBL_Batch B
INNER JOIN TBL_Items I 
ON B.ItemID = I.ItemID
GROUP BY B.BatchID, I.ItemID, I.ItemName
```