| http://www.w3.org/ns/prov#value | - iit depends on your data, if any status other than OK, then it fails, for example?With MyCTE (Product,Parts,Status)AS( SELECT 'Laptop1','mouse','OK' UNION ALL SELECT 'Laptop1','screen','OK' UNION ALL SELECT 'Laptop1','button','OK' UNION ALL SELECT 'Laptop2','mouse','OK' UNION ALL SELECT 'Laptop2','screen','OK' UNION ALL SELECT 'Laptop2','button','NOT OK' ) select T1.Product, CASE
|
