Advertisement
Guest User

Parent/Child

a guest
Dec 14th, 2016
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 3.80 KB | None | 0 0
  1. CREATE TABLE [dbo].[Temp_Steps](
  2.     [StepId] [int] NOT NULL,
  3.     [RUN_ID] [int] NULL,
  4.     [SERIAL] [varchar](255) NULL,
  5.     [PARENT] [int] NULL,
  6.     [STEPNAME] [varchar](255) NULL,
  7.     [Status] [varchar](255) NULL
  8. ) ON [PRIMARY]
  9. INSERT [dbo].[Temp_Steps] ([StepId], [RUN_ID], [SERIAL], [PARENT], [STEPNAME], [Status]) VALUES (171730,3101,'3030',171696,'6.9 - Load Program YXZ','Failed')
  10. INSERT [dbo].[Temp_Steps] ([StepId], [RUN_ID], [SERIAL], [PARENT], [STEPNAME], [Status]) VALUES (171740,3101,'3030',171730,'6.9.5 - Step Test. Program YXZ Error Code','Failed')
  11. INSERT [dbo].[Temp_Steps] ([StepId], [RUN_ID], [SERIAL], [PARENT], [STEPNAME], [Status]) VALUES (171741,3101,'3030',171730,'6.9.6 - Step Test. Program YXZ - Part 1','Failed')
  12. INSERT [dbo].[Temp_Steps] ([StepId], [RUN_ID], [SERIAL], [PARENT], [STEPNAME], [Status]) VALUES (171742,3101,'3030',171730,'6.9.7 - Step Test. Program YXZ - Part 2','Failed')
  13. INSERT [dbo].[Temp_Steps] ([StepId], [RUN_ID], [SERIAL], [PARENT], [STEPNAME], [Status]) VALUES (171743,3101,'3030',171730,'6.9.8 - Step Test. Program YXZ - Part 3','Failed')
  14. INSERT [dbo].[Temp_Steps] ([StepId], [RUN_ID], [SERIAL], [PARENT], [STEPNAME], [Status]) VALUES (171744,3101,'3030',171730,'6.9.9 - Step Test. Program YXZ - Part 4','Failed')
  15. INSERT [dbo].[Temp_Steps] ([StepId], [RUN_ID], [SERIAL], [PARENT], [STEPNAME], [Status]) VALUES (171745,3101,'3030',171730,'6.9.10 - Step Test. Program YXZ - Part 5','Failed')
  16. INSERT [dbo].[Temp_Steps] ([StepId], [RUN_ID], [SERIAL], [PARENT], [STEPNAME], [Status]) VALUES (171785,3102,'3030',171751,'6.9 - Load Program YXZ','Failed')
  17. INSERT [dbo].[Temp_Steps] ([StepId], [RUN_ID], [SERIAL], [PARENT], [STEPNAME], [Status]) VALUES (171788,3102,'3030',171785,'6.9.4 - Run Test - Monitor','Failed')
  18. INSERT [dbo].[Temp_Steps] ([StepId], [RUN_ID], [SERIAL], [PARENT], [STEPNAME], [Status]) VALUES (171789,3102,'3030',171788,'6.9.4.1 - Step Test. Program YXZ - Part 11','Failed')
  19. INSERT [dbo].[Temp_Steps] ([StepId], [RUN_ID], [SERIAL], [PARENT], [STEPNAME], [Status]) VALUES (171790,3102,'3030',171788,'6.9.4.2 - Step Test. Program YXZ - Part 12','Failed')
  20. INSERT [dbo].[Temp_Steps] ([StepId], [RUN_ID], [SERIAL], [PARENT], [STEPNAME], [Status]) VALUES (171791,3102,'3030',171788,'6.9.4.3 - Step Test. Program YXZ - Part 13','Failed')
  21. INSERT [dbo].[Temp_Steps] ([StepId], [RUN_ID], [SERIAL], [PARENT], [STEPNAME], [Status]) VALUES (171792,3102,'3030',171788,'6.9.4.4 - Step Test. Program YXZ - Part 14','Failed')
  22. INSERT [dbo].[Temp_Steps] ([StepId], [RUN_ID], [SERIAL], [PARENT], [STEPNAME], [Status]) VALUES (171793,3102,'3030',171788,'6.9.4.5 - Step Test. Program YXZ - Part 15','Failed')
  23. INSERT [dbo].[Temp_Steps] ([StepId], [RUN_ID], [SERIAL], [PARENT], [STEPNAME], [Status]) VALUES (171794,3102,'3030',171788,'6.9.4.6 - Step Test. Program YXZ - Part 16','Failed')
  24. INSERT [dbo].[Temp_Steps] ([StepId], [RUN_ID], [SERIAL], [PARENT], [STEPNAME], [Status]) VALUES (171795,3102,'3030',171785,'6.9.5 - Step Test. Program YXZ Error Code','Failed')
  25. INSERT [dbo].[Temp_Steps] ([StepId], [RUN_ID], [SERIAL], [PARENT], [STEPNAME], [Status]) VALUES (171796,3102,'3030',171785,'6.9.6 - Step Test. Program YXZ - Part 1','Failed')
  26. INSERT [dbo].[Temp_Steps] ([StepId], [RUN_ID], [SERIAL], [PARENT], [STEPNAME], [Status]) VALUES (171797,3102,'3030',171785,'6.9.7 - Step Test. Program YXZ - Part 2','Failed')
  27. INSERT [dbo].[Temp_Steps] ([StepId], [RUN_ID], [SERIAL], [PARENT], [STEPNAME], [Status]) VALUES (171798,3102,'3030',171785,'6.9.8 - Step Test. Program YXZ - Part 3','Failed')
  28. INSERT [dbo].[Temp_Steps] ([StepId], [RUN_ID], [SERIAL], [PARENT], [STEPNAME], [Status]) VALUES (171799,3102,'3030',171785,'6.9.9 - Step Test. Program YXZ - Part 4','Failed')
  29. INSERT [dbo].[Temp_Steps] ([StepId], [RUN_ID], [SERIAL], [PARENT], [STEPNAME], [Status]) VALUES (171800,3102,'3030',171785,'6.9.10 - Step Test. Program YXZ - Part 5','Failed')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement