query
	unitOfMeasure	unitOfMeasureId	unitOfMeasurePlural
1	case	12051	cases

query
	unitOfMeasure	unitOfMeasureId	unitOfMeasurePlural
1	case	11606	cases

0 32

query
RESULTSET	query   CATALOGID CATALOGLEVEL OWNERID OWNERTYPE PRICE PRICEMODE PRICERAW UNITOFMEASURE 1 38236933 SKU 2142 MFR [empty string] hierarchy [empty string] cases
CACHED	false
EXECUTIONTIME	5
SQL	declare @catalogId int = ?; declare @ownerId int = ?; declare @ownerType varchar(3) = ?; with productData as ( select top 1 ownerId, ownerType, 'SKU' catalogLevel, skuId as catalogId, defaultUnitPrice_USD defaultUnitPrice, productLineUnitPrice_USD productLineUnitPrice, categoryUnitPrice_USD categoryUnitPrice, prodUnitPrice_USD prodUnitPrice, skuUnitPrice_USD skuUnitPrice, unitPrice_USD unitPrice, lower( qtyUOM ) as unitOfMeasure from tbl_DW_ProductHierarchy_MFR2142 ph with (nolock) where skuId = @catalogId and ownerId = @ownerId and ownerType = @ownerType ), priceRaw as ( select ownerId, ownerType, catalogId, catalogLevel, 'hierarchy' priceMode, unitPrice as priceRaw, unitOfMeasure from productData as ph ) select *, priceRaw as price from priceRaw
SQLPARAMETERS	array 1 38236933 2 2142 3 MFR

query
RESULTSET	query   CATALOGID CATALOGLEVEL OWNERID OWNERTYPE PRICE PRICEMODE PRICERAW UNITOFMEASURE 1 10078530 SKU 34 MFR 98.34 hierarchy 98.34 cases
CACHED	false
EXECUTIONTIME	3
SQL	declare @catalogId int = ?; declare @ownerId int = ?; declare @ownerType varchar(3) = ?; with productData as ( select top 1 ownerId, ownerType, 'SKU' catalogLevel, skuId as catalogId, defaultUnitPrice_USD defaultUnitPrice, productLineUnitPrice_USD productLineUnitPrice, categoryUnitPrice_USD categoryUnitPrice, prodUnitPrice_USD prodUnitPrice, skuUnitPrice_USD skuUnitPrice, unitPrice_USD unitPrice, lower( qtyUOM ) as unitOfMeasure from tbl_DW_ProductHierarchy_MFR34 ph with (nolock) where skuId = @catalogId and ownerId = @ownerId and ownerType = @ownerType ), priceRaw as ( select ownerId, ownerType, catalogId, catalogLevel, 'hierarchy' priceMode, unitPrice as priceRaw, unitOfMeasure from productData as ph ) select *, priceRaw as price from priceRaw
SQLPARAMETERS	array 1 10078530 2 34 3 MFR