Slexy.org is shutting down and stopped accepting new Pastes on May 4th, 2021.
Existing Pastes will stop being available on or after May 10th, 2021.
Author: Not specified Language: tsql
Description: Not specified Timestamp: 2017-08-03 18:01:01 +0000
View raw paste Reply
--17ABAB66-E354-4A35-951F-8B752BA221ED

SELECT * FROM order_sub_line WHERE cntnr_content_id in
  (SELECT cntnr_content_id FROM cntnr_content WHERE cntnr_id in
  (SELECT cntnr_id FROM cntnr_header WHERE cntnr_name = 'R000001312')) --only one '49D22AA2-6865-4408-BF4C-A7C3009A3EB1'

SELECT cntnr_id FROM cntnr_header WHERE cntnr_name = '100159'
SELECT destination_cntnr_id FROM order_sub_line WHERE order_sub_line_id = '49D22AA2-6865-4408-BF4C-A7C3009A3EB1'

--update order_sub_line set destination_loc_id = '17ABAB66-E354-4A35-951F-8B752BA221ED' where order_sub_line_id = '49D22AA2-6865-4408-BF4C-A7C3009A3EB1'
View raw paste Reply