1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50
| CREATE TABLE [dbo].[BOM3](
[BOM Number] [int] NULL,
[Item] [int] NULL,
[Mat Number] [int] NULL,
[Qty] [int] NULL
) ON [PRIMARY]
BEGIN TRANSACTION;
INSERT INTO [dbo].[BOM3]([BOM Number], [Item], [Mat Number], [Qty])
SELECT 2000022, 20, 2001770, 1 UNION ALL
SELECT 2000022, 30, 2003496, 1 UNION ALL
SELECT 2000022, 50, 2001527, 1 UNION ALL
SELECT 2000022, 60, 2003495, 1 UNION ALL
SELECT 2000246, 0, 2000246, 1 UNION ALL
SELECT 2000246, 2, 2002005, 1 UNION ALL
SELECT 2000506, 0, 2000506, 1 UNION ALL
SELECT 2000506, 1, 2000246, 4 UNION ALL
SELECT 2000837, 0, 2000837, 1 UNION ALL
SELECT 2000837, 1, 2000246, 7 UNION ALL
SELECT 2001527, 0, 2001527, 1 UNION ALL
SELECT 2001527, 10, 2001528, 1 UNION ALL
SELECT 2001528, 0, 2001528, 1 UNION ALL
SELECT 2001528, NULL, 2001533, 1 UNION ALL
SELECT 2001533, 0, 2001533, 1 UNION ALL
SELECT 2001533, 10, 2000246, 14 UNION ALL
SELECT 2001770, 0, 2001770, 1 UNION ALL
SELECT 2001770, 10, 2001771, 1 UNION ALL
SELECT 2001771, 0, 2001771, 1 UNION ALL
SELECT 2001771, NULL, 2001772, 1 UNION ALL
SELECT 2001772, 0, 2001772, 1 UNION ALL
SELECT 2001772, NULL, 2001780, 1 UNION ALL
SELECT 2001780, 0, 2001780, 1 UNION ALL
SELECT 2001780, 10, 2000246, 4 UNION ALL
SELECT 2002292, 0, 2002292, 1 UNION ALL
SELECT 2002292, 8, 2000506, 1 UNION ALL
SELECT 2002395, 0, 2002395, 1 UNION ALL
SELECT 2002395, 1, 2002292, 1 UNION ALL
SELECT 2002565, 0, 2002565, 1 UNION ALL
SELECT 2002565, 2, 2000837, 1 UNION ALL
SELECT 2002566, 0, 2002566, 1 UNION ALL
SELECT 2002566, 1, 2002565, 1 UNION ALL
SELECT 2002875, 0, 2002875, 1 UNION ALL
SELECT 2002875, 1, 2002566, 1 UNION ALL
SELECT 2003495, 0, 2003495, 1 UNION ALL
SELECT 2003495, 10, 2002875, 1 UNION ALL
SELECT 2003496, 0, 2003496, 1 UNION ALL
SELECT 2003496, 10, 2002395, 1
COMMIT;
RAISERROR (N'[dbo].[BOM3]: Insert Batch: 1.....Done!', 10, 1) WITH NOWAIT;
GO |
Partager