* from Erp_InventoryVariant where InventoryId= 274859 and Variant2Id =94006

delete from Erp_InventoryVariant where RecId IN (1488680)


select * from Erp_InventoryVariant where Variant2Id= 94006 and Variant2Order=6


varyant 2 ama 3 gözüküyorsa


update Erp_InventoryVariant set Variant2Id= 94006 where RecId IN (1294552,1294563,1294574,1294585,1305710,1305721,1305732,1336798,1336809,1501042,1501065)


update Erp_InventoryVariant where Variant2Id = 94006 where  Variant2Order=4 

update Erp_InventoryVariant set Variant2Id= 94006 where Variant2Order =6

-------------------------------------------


select * from Erp_Inventory where InventoryCode = 'S0016406' and CompanyId =12

select * from Erp_InventoryVariant where InventoryId =274374


select * from Erp_VariantCard where VariantCardName LIKE '%XXS%42%'


RENK EKLENMEZSE ÇİFT BEDEN GELMİŞSE

select * from Erp_Inventory where InventoryCode = 'W0011222' and CompanyId =12

select * from Erp_InventoryVariant where InventoryId and Variant2Id=94006

delete from Erp_InventoryVariant where InventoryId =274374 and Variant2Id=94006


select * from Erp_InventoryVariant where InventoryId =275749

select * from Erp_VariantCard where RecId =793


select * from Erp_VariantItem where CardId =793


select * from Erp_VariantCard where VariantCardName LIKE '%XXS%42%'