select 'catalog/product' ATTRIBTYPE , 'cost' ATTRIBNAME, 'catalog_product_entity_decimal' TABLENAME
 
 , 0 STORE_ID, a.FUNITCOST * coalesce(unit.FUNITQTY,1) COLVALUE
 from stock a
 left join UNIT on unit.WUNITID = a.WUNITID

 where a.wstockid = <@WSTOCKID@>
union
select 'catalog/product' ATTRIBTYPE , 'price' ATTRIBNAME, 'catalog_product_entity_decimal' TABLENAME
 , 0 STORE_ID, a.FSELLINGPRICE1 * coalesce(unit.FUNITQTY,1) COLVALUE
 from stock a
 left join UNIT on unit.WUNITID = a.WUNITID

 where a.wstockid = <@WSTOCKID@>
union
select 'catalog/product' ATTRIBTYPE , 'msrp' ATTRIBNAME, 'catalog_product_entity_decimal' TABLENAME
 , 0 STORE_ID, a.FSELLINGPRICE1 * coalesce(unit.FUNITQTY,1) COLVALUE
 from stock a 
 left join UNIT on unit.WUNITID = a.WUNITID

 where a.wstockid = <@WSTOCKID@>
union
select 'catalog/product' ATTRIBTYPE , 'weight' ATTRIBNAME, 'catalog_product_entity_decimal' TABLENAME
 , 0 STORE_ID, a.FNETTOWEIGHT COLVALUE
 from stock a where a.wstockid = <@WSTOCKID@>

