ALTER PROCEDURE [dbo].[sp_GetOpeningStockDetails]      
    @itemcode NVARCHAR(255),
    @BranchCode NVARCHAR(500)
AS
BEGIN
    SELECT 
        OP.ItemCode,
        OP.ItemName,
        OP.OPStock,
        OP.OPCost 
    FROM 
        OPStockUpdatedDetails OP
    WHERE 
        (@itemcode IS NULL OR @itemcode = '' OR OP.ItemCode = @itemcode)
        AND (@BranchCode IS NULL OR @BranchCode = '' OR @BranchCode = '1' OR OP.BranchCode = @BranchCode)
    ORDER BY 
        OP.ItemCode;
END