ALTER PROCEDURE [dbo].[eBayInventory_s] @ProductID NVARCHAR(50) AS DECLARE @Numeric BIT DECLARE @CompanyID INT DECLARE @ChannelID INT = 1 --for ebay SELECT @ProductID = ISNULL(NULLIF(p.ShadowOf, ''), p.ID), @CompanyID = p.CompanyID FROM bvc_Product p WHERE p.ID = @ProductID SELECT @Numeric = ISNUMERIC(CartCode) FROM CompanyWarehouseCartCode WHERE CompanyID = @CompanyID AND Channel = @ChannelID SELECT CASE WHEN InventoryAvailableQty <= 0 THEN 0 WHEN @Numeric = 0 AND InventoryAvailableQty > 0 THEN InventoryAvailableQty WHEN @Numeric = 1 AND InventoryAvailableQty > 0 THEN --If there is 0.75 units after calculating percentage, then send 1. For example, available 3 and percentage set to 25% CASE WHEN (p.InventoryAvailableQty * cwcc.CartCode) >= 0 AND (p.InventoryAvailableQty * cwcc.CartCode) < 100 THEN 1 ELSE ((p.InventoryAvailableQty * cwcc.CartCode) / 100) END END AS Qty FROM dbo.bvc_Product p INNER JOIN dbo.CompanyWarehouseCartCode cwcc ON cwcc.CompanyID = p.CompanyID WHERE p.ID = @ProductID AND cwcc.Channel = @ChannelID