select distinct bidMfrId from tbl_BID_Skus where ownerId = and ownerType =

select bidSku, count( bidSku ) bidSkuCount from tbl_BID_Skus where ownerId = and ownerType = and bidMfrId = group by bidSku having count( bidSku ) > 1 order by bidSku select bidSkuId, bidSkuStatus from tbl_BID_Skus where ownerId = and ownerType = and bidMfrId = and bidSku = select bidSkuId from qmd_bidSkuId where bidSkuStatus = 'A' select bidSkuId from qmd_bidSkuId where bidSkuId <> #qmd_keeperBidSkuId.bidSkuId# select bidSkuId from qmd_bidSkuId where bidSkuStatus <> 'A' update tbl_BID_BidLineProducts set bidSkuId = where bidSkuId = and ownerId = and ownerType = update tbl_BID_PriceListPrices set bidSkuId = where bidSkuId = and ownerId = and ownerType = update tbl_BID_CommodityPrices set bidSkuId = where bidSkuId = and ownerId = and ownerType = update tbl_BID_Skus set ownerId = * -1, ownerType = 'BRX' where ownerId = and ownerType = and bidSkuId = --->

[bidMfrId] #qmd_bidMfrId.bidMfrId#

[bidsku] #bidsku#

[bidSkuId]#_keeperBidSkuId#

[bidSkuId]#_loserBidSkuId#