Minigrip de México

SELECT 

    OrdenVenta        = tblShopOrder.OrderNumber,

    OrdenDetalle    = tblShopOrder.OrderDetailNumber,

    Glo    = (CASE WHEN tblShopOrder.CustomerProcessName = 'Extrusion Globo'   THEN 'SI' ELSE '' END),

    Cas    = (CASE WHEN tblShopOrder.CustomerProcessName = 'Extrusion Cast'    THEN 'SI' ELSE '' END),

    Mon    = (CASE WHEN tblShopOrder.CustomerProcessName = 'Montaje'           THEN 'SI' ELSE '' END),

    Imp    = (CASE WHEN tblShopOrder.CustomerProcessName = 'Impresión'         THEN 'SI' ELSE '' END),

    Lam    = (CASE WHEN tblShopOrder.CustomerProcessName = 'Laminación'        THEN 'SI' ELSE '' END),

    Tub    = (CASE WHEN tblShopOrder.CustomerProcessName = 'Tubeo'             THEN 'SI' ELSE '' END),

    Taj    = (CASE WHEN tblShopOrder.CustomerProcessName = 'Tajado'            THEN 'SI' ELSE '' END),

    Ref    = (CASE WHEN tblShopOrder.CustomerProcessName = 'Refinado'          THEN 'SI' ELSE '' END),

    Bol    = (CASE WHEN tblShopOrder.CustomerProcessName = 'Bolseo'            THEN 'SI' ELSE '' END),

    Reb    = (CASE WHEN tblShopOrder.CustomerProcessName = 'Rebobinado'        THEN 'SI' ELSE '' END),

    Emp    = (CASE WHEN tblShopOrder.CustomerProcessName = 'Empaque'           THEN 'SI' ELSE '' END),

    Rec    = (CASE WHEN tblShopOrder.CustomerProcessName = 'Reciclado'         THEN 'SI' ELSE '' END)

FROM 

    tblShopOrder

GROUP BY

    tblShopOrder.OrderNumber,

    tblShopOrder.OrderDetailNumber,

    (CASE WHEN tblShopOrder.CustomerProcessName = 'Extrusion Globo'   THEN 'SI' ELSE '' END),

    (CASE WHEN tblShopOrder.CustomerProcessName = 'Extrusion Cast'    THEN 'SI' ELSE '' END),

    (CASE WHEN tblShopOrder.CustomerProcessName = 'Montaje'           THEN 'SI' ELSE '' END),

    (CASE WHEN tblShopOrder.CustomerProcessName = 'Impresión'         THEN 'SI' ELSE '' END),

    (CASE WHEN tblShopOrder.CustomerProcessName = 'Laminación'        THEN 'SI' ELSE '' END),

    (CASE WHEN tblShopOrder.CustomerProcessName = 'Tubeo'             THEN 'SI' ELSE '' END),

    (CASE WHEN tblShopOrder.CustomerProcessName = 'Tajado'            THEN 'SI' ELSE '' END),

    (CASE WHEN tblShopOrder.CustomerProcessName = 'Refinado'          THEN 'SI' ELSE '' END),

    (CASE WHEN tblShopOrder.CustomerProcessName = 'Bolseo'            THEN 'SI' ELSE '' END),

    (CASE WHEN tblShopOrder.CustomerProcessName = 'Rebobinado'        THEN 'SI' ELSE '' END),

    (CASE WHEN tblShopOrder.CustomerProcessName = 'Empaque'           THEN 'SI' ELSE '' END),

    (CASE WHEN tblShopOrder.CustomerProcessName = 'Reciclado'         THEN 'SI' ELSE '' END)