12 lines
693 B
SQL
12 lines
693 B
SQL
select * from Pipeline_Pipeline where PipelineCode='EC-05216'
|
|
|
|
select * from Pipeline_WeldJoint where PipelineId='9fb23f07-2b01-4ca2-9532-40f4e707d092' and WeldJointCode in ('W30','W45')
|
|
|
|
select item.*,t.TrustBatchCode from Batch_BatchTrustItem item
|
|
left join Batch_BatchTrust t on item.TrustBatchId=t.TrustBatchId
|
|
|
|
where WeldJointId in ('476123d1-152b-4601-a7c3-300532c7bbad','966a29da-af76-4f89-9ee8-5c0c51dc956c')
|
|
|
|
select * from Batch_PointBatchItem where WeldJointId in ('476123d1-152b-4601-a7c3-300532c7bbad','966a29da-af76-4f89-9ee8-5c0c51dc956c')
|
|
|
|
delete from Batch_BatchTrustItem where TrustBatchItemId in ('bb845559-fe43-4750-b5f3-701b0e61a245','7c7e3d1d-d47f-4821-be34-0b95c8f2e907') |