select distinct bs.bidMfrId from tbl_BID_Skus bs with (nolock) inner join tbl_BID_Manufacturers bm with (nolock) on bm.ownerId = bs.ownerId and bm.ownerType = bs.ownerType and bm.bidMfrId = bs.bidMfrId inner join tblManufacturers mfr with (nolock) on mfr.mfr_id = bm.mfrId where bs.ownerId = and bs.ownerType = --and bm.bidMfrId = 1128

select bidSku, count( bidSku ) bidSkuCount from tbl_BID_Skus with (nolock) where ownerId = and ownerType = and bidMfrId = --and bidSku = '06605' group by bidSku having count( bidSku ) > 1 order by bidSku select skuId, bidSkuId, bidSkuStatus, dateCreated from tbl_BID_Skus with (nolock) where ownerId = and ownerType = and bidMfrId = and bidSku = select bidSkuId, dateCreated from qmd_bidSkus where skuId is not null select bidSkuId from qmd_keeperBidSku order by dateCreated desc select bidSkuId from qmd_bidSkus order by dateCreated desc select bidSkuId from qmd_bidSkus select bidSkuId from qmd_bidSkus where bidSkuId <> update tbl_BID_BidLineProducts set bidSkuId = where bidSkuId = and ownerId = and ownerType = select * from tbl_BID_PriceListPrices where bidSkuId = and ownerId = and ownerType = update tbl_BID_PriceListPrices set bidSkuId = where bidSkuId = and ownerId = and ownerType = update tbl_BID_PriceListPrices set ownerId = * -1, ownerType = 'BRX' where bidSkuId = and ownerId = and ownerType = select * from tbl_BID_SkusOverride where bidSkuId = and ownerId = and ownerType = update tbl_BID_SkusOverride set bidSkuId = where bidSkuId = and ownerId = and ownerType = update tbl_BID_SkusOverride set ownerId = * -1, ownerType = 'BRX' 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]#_loserBidSkuIds#