1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| INSERT INTO [Cutting software].dbo.odl_printed(
fk_vh,
placement,
fk_tissu,
designation_tissu,
id_kanban_tissu,
placementB,
placementC,
placementD,
datetime_impression -- <=====================
)
SELECT relation_tissu_placement_veh.designation_veh,
relation_tissu_placement_veh.placement,
relation_tissu_placement_veh.fk_tissu,
relation_tissu_placement_veh.designation_tissu,
placement.id_kanban_tissu,
placement.PlacementB,
placement.PlacementC,
placement.PlacementD,
GETDATE() -- <=====================
FROM relation_tissu_placement_veh
INNER JOIN placement
ON relation_tissu_placement_veh.placement = placement.placement
WHERE (relation_tissu_placement_veh.designation_veh = 'letherette basic') |
Partager