Author: Not specified Language: tsql
Description: Not specified Timestamp: 2017-06-15 13:28:05 +0000
View raw paste Reply
SELECT cj.seq_num, cj.date_stamp, cj.cntnr_id, ch.cntnr_name, cj.activity_type, rh.resource_name--, cj.activity_data
FROM cntnr_journal cj
        INNER join cntnr_header ch ON ch.cntnr_id = cj.cntnr_id
        INNER join activity_config ac ON cj.activity_type = ac.activity_type
        INNER join resource_header rh ON ac.resource_id = rh.resource_id
WHERE cntnr_name
        in ('12 400290','12 400942','12 400841','12 400733','12 400189','12 401174',
                '12 400794','12 401495','12 401004','12 200667','12 201347','12 200765','12 401485','12 200004','12 201331')
and cj.activity_data.VALUE('(/xml/PRODUCT_NAME)[1]','varchar(100)')
        in ('S3FT030001','ZMT770T001','MXCT131001','M6JC278006','RMFC530001','YA6FC000003','6MNY018005','D65P010001','MM2Y210002','M3LN32000J','647J010009','6KN9018006','M022030006','M6JC390007')
and cj.activity_type = '30700'
View raw paste Reply