Vamsi Mukkanti

How to generate orgpath as column of datatype hierarchyid.

Jan 31 2020 10:59 AM

Can anyone help regarding the scenario?

How to generate a script for orgpath as a column of datatype hierarchyid in companies table.

CREATE TABLE [dbo].[Companies](

[Company_ID] [uniqueidentifier] NOT NULL,

[CompanyName] [nvarchar](250) NOT NULL,

[ParentCompany_ID] [uniqueidentifier] NULL

)

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'826fdff6-e1fc-44ba-94a1-000aceaaa8d0', N'BAY', N'8edb58b8-7f5c-45d1-a1bf-0004da969109')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'89f2a314-2c1d-44bd-84ef-00120905b95d', N'Kuehne + Nagel AS, Stvg', N'671e53de-efbc-4d16-993b-a2bb99970a1e')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'088c557c-0b5f-4d9f-849e-002b3e19f8b2', N'Quasar Energy Services', N'69064f08-e87c-4219-9032-25e1084b25ab')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'd4add17d-d9d8-435e-af42-0036f67d07a7', N'Bryan District', N'e9762391-6a3a-4753-b545-0d83b6fddc1e')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'2f345cac-2951-4b1a-9036-0037a2e3cdce', N'BAY OFFSHORE', N'8c73a17c-a7f9-4e5f-b8c3-18fd8ad83216')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'5481f3fc-6384-4147-b3fb-0040bcffb7f6', N'CETCO/NEW IBERIA', N'49132bf4-2003-430e-96c8-112ee717659b')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'7abbc4c8-4196-45dc-8d05-005111bf5ddd', N'Houston Washline', N'a0f84712-5d0b-48a8-9c46-d76cdc38aaad')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'473689a9-deb3-4d6d-b6ac-005c607317be', N'Knight Oil Tools Middle East DMCC', N'ca7b6679-1101-4541-a3bf-a440649f17b6')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'dc4fd87c-72cf-4782-a98a-006c5fc32997', N'RIG 57', N'a622740e-1154-478d-b917-e29f4337f3cb')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'475d86fd-f8af-452b-8e91-0070925127f1', N'BP AMOCO', N'8c73a17c-a7f9-4e5f-b8c3-18fd8ad83216')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'fa18d821-0511-435f-bf3c-00777e691d0d', N'CATALYST RECOVERY OF LOUISIANA', N'a57c490a-7196-4117-a731-1cca8431d1ec')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'2c108dc4-afb2-4988-ad85-007cbba3ce3f', N'Aker West Sam Houston Pkwy', N'ea4bfbe2-e29e-4aea-8f60-a2d8091f84fe')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'5733000f-4728-40a3-988d-007f93daa123', N'KDM Constructions Pty Ltd', N'1b0ae3b8-1489-4e12-844a-5825346a098d')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'31d3cb24-2220-4829-95b2-008c625495ac', N'Cameron Intl Malaysia Sdn Bhd', N'7953a17d-c0a3-4315-99c2-b5c2cf9e60a9')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'44d1acf7-025e-4885-bbe4-0092426a075b', N'Logwin Air & Ocean Pty Ltd', N'1b0ae3b8-1489-4e12-844a-5825346a098d')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'f613da34-2a14-4148-9815-00958db7b4e8', N'Demo Companies', N'9d323770-750f-4860-829a-fc219743276b')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'7d6c582f-5947-40a8-a17b-009866f199ac', N'N/A', N'afdc6475-45c4-46ce-99b5-3925efbfc9f6')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'81f0bdee-64aa-4975-886e-009c3824db73', N'Injection Tank Demo', N'7e6db688-5f87-4c0a-9a9a-9b79cf117f8b')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'e120bd9b-ec53-4596-8813-009ec4957b27', N'BROUSSARD', N'527c2113-0a0d-4eb0-b3a9-be5aea7bd373')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'28e02863-4a7a-4a55-b8bb-00d365d11050', N'NRC Enviromental Services (UK) Ltd', N'399d88cb-cc90-4739-816b-611491267c5c')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'2e2a9a9a-3056-4a47-9f67-00e1b2a44460', N'AGC Industries Pty Ltd', N'1b0ae3b8-1489-4e12-844a-5825346a098d')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'b31b024a-e07c-417c-878e-00e4b3082e18', N'Shaunavon, SK Plant', N'288368af-4f50-4d83-a9e9-8c3b6b6ce994')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'ebdc1c9c-e0ff-48c1-845d-00e7f4d80e40', N'MAURICE', N'19c48d01-7233-446a-8b41-01ea216ab072')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'1df487d5-442a-4df1-a2b9-00ecbca573b3', N'TRUE CHEMICAL SOLUTIONS', N'457ba21e-7cb1-488c-8fbf-6c561ea20539')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'82048038-9de1-475e-95b1-00f0edee2985', N'COBALT/ATLANTIC MARITIME (82880)', N'1a9f05de-75c2-4bce-8771-d1195321b2dd')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'c9ea4fcb-372f-4fdf-928a-00f4df7bfcf5', N'Lifting By Design Pty Ltd', N'1b0ae3b8-1489-4e12-844a-5825346a098d')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'3bb9fef8-3f6a-43d1-a32d-00f5bf231c77', N'LA INTERNATIONAL MARINE LLC (22877)', N'1a9f05de-75c2-4bce-8771-d1195321b2dd')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'51a7878d-2066-4d98-8d57-00fd3e73ad1d', N'Leighton Offshore / Engineering & Constructions JV', N'7953a17d-c0a3-4315-99c2-b5c2cf9e60a9')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'73199c48-3017-4aac-b843-00fee20f48e2', N'P.T. Expro Indonesia', N'1b0ae3b8-1489-4e12-844a-5825346a098d')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'4e72fbab-d4ae-4323-abb6-010bf089ca8c', N'Pharmco-AAPER', N'33bf71da-de1a-4b96-b6db-ee82c6208c1d')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'172555c1-8906-44fb-ad3b-010d5867c70b', N'Metrol Technology Ltd', N'399d88cb-cc90-4739-816b-611491267c5c')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'224101ec-da5c-4c84-94ff-010ddb4073da', N'SUPERIOR PERFORMANCE/BROUSSARD', N'c1c544b0-4551-4c6b-aa40-368316c15267')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'70c83a85-7738-4a45-88d5-011628b801a5', N'PATTERSON TRUCK LINES/CHANNELVIEW TX', N'3b38e1b1-0bbb-4fd7-8392-60b4352cbfd0')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'd670c1a5-3241-4839-ac24-011b9ce40dc8', N'LAFAYETTE', N'60203810-156d-4524-815b-30b9f5442981')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'ffe11a53-e510-4e0b-90f6-011ce3ee3f99', N'RESOURCE RIG SUPPLY', N'da0d426f-72b0-4b26-b87c-a2da1158d2f6')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'70ded0f5-77ea-4876-a098-011fe29e0b15', N'MONCLA 118', N'2306f716-0c49-45af-895e-776c2a6dcebb')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'f7d52692-dab5-4b18-ad70-0122d5895632', N'KOSMOS ENERGY MAURITANIA', N'399d88cb-cc90-4739-816b-611491267c5c')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'aaaee24a-c7b9-4d4d-9d00-012c8024e182', N'AXXIS', N'1acc0789-414c-4248-9a90-7ee0967a6e04')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'fff9fae2-a15d-4ff6-92d0-012f23dcfd7d', N'TC621-2', N'8a689b56-80eb-4045-a93a-e228ccbd58cd')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'd1ebaf44-6298-4271-8dcc-012f2545375e', N'WEATHERFORD CC', N'08c9687f-eb7b-4ec0-ad4a-d88dff3b940e')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'8f4e4391-f04c-4a7e-b03e-012f677699a9', N'Diesel - Galveston', N'ded09976-4876-495f-8d22-28ca9fb75332')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'47f331fe-6d2c-43ed-ae98-0149593feb90', N'MI SWACO', N'51ace22c-1695-48f5-b972-7c5f29cd7806')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'f3ff0753-801d-4275-a026-0149f03815d5', N'WEEKS MARINE - channelview (81971)', N'1a9f05de-75c2-4bce-8771-d1195321b2dd')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'adc90aff-100c-44ca-a23f-014f027bf119', N'Cabot Specialty Fluids LTD', N'457ba21e-7cb1-488c-8fbf-6c561ea20539')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'483bb9fa-6370-41be-a7d9-015608e96915', N'CAMERON', N'88ff556c-ce52-4be3-a7e1-ae9e25f1bc5a')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'22f27aa0-6c6f-40d2-afc5-015a7f77b27e', N'BAKER SUPERCENTER/BROUSSARD', N'e6737850-ebdc-4e07-80f8-ef87cf8e8a2b')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'd6bfed25-6b6f-43d2-9642-015ada5188c0', N'Subsea 7 Malaysia Sdn Bhd', N'7953a17d-c0a3-4315-99c2-b5c2cf9e60a9')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'59c7d3d8-d062-4c1a-83bd-015b15aa9728', N'NEW IBERIA', N'0c7d6b11-60b4-4072-9db2-cbc93230206c')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'39c01cd1-de2e-45b4-8b7c-016178c536aa', N'Forum Energy Technologies', N'ca7b6679-1101-4541-a3bf-a440649f17b6')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'18b37bc0-949a-4410-aade-0170b0d3889a', N'CoilChem LLC', N'51ace22c-1695-48f5-b972-7c5f29cd7806')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'6fa7c00f-1970-47fe-87ea-017bba9297dd', N'N/A', N'317a58b7-6bc1-40b2-9bf2-f500e9e38dc7')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'af4fc29c-4a15-4546-966f-018046e08499', N'LJ SUPPLY & ENGINEERING SERVICES SDN BHD', N'29d0d5a7-4f0d-4975-bb14-3b52be6a13ac')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'b20ef788-b0d6-4e50-86a1-0184b079e97f', N'MES PORT ARTHUR (1.20361e+007)', N'1a9f05de-75c2-4bce-8771-d1195321b2dd')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'5e2173d7-bffe-45fd-8ed9-0184bcdd665f', N'Company0612', N'dc7b2126-7913-45f5-998c-18f89cde65f8')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'43db8d53-55e7-4c86-b871-0198756d1e3d', N'Returned PIBC', N'5a02a2ec-73d4-4fc8-905c-f68c4a4840ed')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'f9c05947-8e36-4f27-a733-01a31aeefb99', N'DEMO test', N'3c6870e0-c9c4-419e-98e0-ecc4a57a20e7')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'c71fc3a6-25e2-4dd0-b78f-01b62f41abb6', N'Solenis', N'33bf71da-de1a-4b96-b6db-ee82c6208c1d')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'f466c304-cb98-4483-bea0-01bc17b3bf99', N'(M) Vetco Gray Australia Pty Ltd', N'1b0ae3b8-1489-4e12-844a-5825346a098d')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'c16fe6a3-19a5-4e5c-ba08-01d45e3866df', N'ANADARKO - Galveston (81085)', N'1a9f05de-75c2-4bce-8771-d1195321b2dd')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'87c9d9f8-58c4-46c3-9051-01d64cfb1fa4', N'CGG servicesSA', N'ca7b6679-1101-4541-a3bf-a440649f17b6')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'dd908ead-c087-48f2-b03a-01e16fc5e525', N'GPS Units', N'7a0b7795-7c9d-44c3-9fb4-74d814318dd1')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'0a966fac-218c-4f5a-bf89-01e2352a9135', N'Shell', N'33bf71da-de1a-4b96-b6db-ee82c6208c1d')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'19c48d01-7233-446a-8b41-01ea216ab072', N'CONTROL CONCEPTS', N'c53a4398-fe51-4744-afee-2ca5115c9515')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'0630de4e-ad78-431e-9038-01f5568f2e1e', N'HOUMA', N'23d511e3-914a-4862-9076-f723d537d4db')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'd2263c2a-0b79-42ab-8bb0-01f6b0da4be1', N'North Atlantic Drilling', N'671e53de-efbc-4d16-993b-a2bb99970a1e')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'a102cef5-fc04-4954-9119-021a64fd3549', N'CAPROCK UK LTD', N'399d88cb-cc90-4739-816b-611491267c5c')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'b3bee7be-6deb-473d-84fe-02250bed4046', N'INTERMOOR', N'317f2aec-617e-48d3-8d43-a877a5bb91e0')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'e0b16876-7b48-4fc6-bfd9-02265854cc7b', N'Transocean', N'29fb61f1-e26a-4dac-af4b-65aee0bad084')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'6e69733e-fe04-4790-bf29-0229ab2c31f2', N'READ CASED HOLE LTD', N'399d88cb-cc90-4739-816b-611491267c5c')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'f0bfd35e-f77a-4719-8a3f-02347d5f343a', N'Hitec Products AS', N'671e53de-efbc-4d16-993b-a2bb99970a1e')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'fa8623c2-30d9-4f89-9bc3-023b74908687', N'TEK-Ocean', N'bea5defb-dbfa-44eb-b3f5-411923cb95fc')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'39bbf3dd-5ba7-4eb9-9ccd-023e119a30c6', N'EXXONMOBIL CORP (2756)', N'1a9f05de-75c2-4bce-8771-d1195321b2dd')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'03ffa14e-e465-4096-aa75-023f1e6c8bd8', N'1234-1', N'f2ad86a6-edf6-40a9-9ab0-f1ca8868fde9')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'14f8c59f-336a-479a-97ac-024bbe0f1ac5', N'BROUSSARD', N'bd81e8ce-5c5c-444b-803a-c792defbd517')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'acd3c2f7-56a7-49b0-a076-02534bdc6422', N'Plainville Jacam Chemicals 2013 Warehouse (PL)', N'abf0cb77-cfb9-4d17-a078-3f6130dc7a15')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'e8a2e860-2ce8-463f-b1b7-025bd0bae73f', N'Fourchon', N'f58f472f-f3b3-4e1a-b694-48375bb54574')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'80db6dcb-104c-4867-8fbc-02618372fe4c', N'DISCOVERY ', N'c305eb9b-98b3-41ca-89d7-ce237d79ab1f')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'aaa4b8f4-c876-464e-b045-0261aa2c7b26', N'datrrr', N'd0f5089c-5631-4671-acb8-4300ea0831e0')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'5f50a98b-96c3-4aa4-91e0-026a8b6426d1', N'Certified Clean - White - Harbor Island', N'9bee93d1-3b49-4bb8-9437-2d8405ab95c3')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'a96f0517-2d24-441e-9437-026bbf14952d', N'Owen Oil Tools', N'ca7b6679-1101-4541-a3bf-a440649f17b6')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'2c18d32c-19ca-420a-a5dc-026cb226e23a', N'Prime ECO Group', N'457ba21e-7cb1-488c-8fbf-6c561ea20539')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'4b2cf4d0-fcb0-4408-9c76-027a14ac4c4f', N'VERMILLION 380', N'08a8ce24-6359-4920-b32e-98de1dc5ac66')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'd7b9cddc-a235-4763-b025-0284e8f823b7', N'Opal Products Pty Ltd', N'1b0ae3b8-1489-4e12-844a-5825346a098d')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'363aa216-adac-4b98-8a33-0291a04d6d10', N'Domestic Assets', N'9ad71bb3-7793-44ae-a33c-26f8258e316a')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'ef96bf83-42cb-4e6f-a559-02a261eb09a3', N'McDermott', N'd9d3c269-78a1-4225-a7ae-c4c35bb8e670')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'0a09a1f5-57f9-4c21-a83d-02acb511f050', N'Nalco Demo', N'3c6870e0-c9c4-419e-98e0-ecc4a57a20e7')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'6e2015f0-cc3b-4c37-a13c-02af1112deaa', N'Consignment Locations', N'1271425d-5e33-4a33-bda6-b012a4a9f7ab')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'6b22d303-0d97-4c8d-a6d8-02c0184fd07f', N'ATR Equipment Solutions LTD', N'399d88cb-cc90-4739-816b-611491267c5c')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'30b5a8db-e5b5-4650-b54e-02c3180ade5f', N'MEDCO ENERGY', N'38f7bfd9-98cd-46a6-b47b-ee49dc7e8751')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'98d9a74b-1786-472a-b0e6-02c9dfebd87b', N'GRAND ISLE', N'94b23340-9d02-443b-91ee-628333a6fb74')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'8bab2ee3-54ef-4858-ae4e-02ecc0a3df72', N'DELMAR OFFSHORE INC(BROUSSARD) (22684)', N'317f2aec-617e-48d3-8d43-a877a5bb91e0')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'63318972-b962-47cd-b5ce-02f1da1ac8f6', N'BRAZOS HORIZON', N'fbbf3edc-75d3-4efa-968f-e076281f7a36')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'7fe1ba16-494a-4b38-8033-02fbc632e286', N'ENI', N'a57c490a-7196-4117-a731-1cca8431d1ec')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'544a47c3-2275-40ce-9757-02ffa6094e22', N'HB RENTALS', N'ba36c956-f116-4f04-9b36-b4424234b53f')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'9a0077d6-4342-4b68-b721-03055e25a2c5', N'FTSI', N'b1baabf6-c149-424d-b147-a13e0ec19a02')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'f39943ed-ede6-4c62-840a-0319a99c748f', N'Valero - Tim WIlson', N'9bfaa2e2-a37e-4a35-863a-c0b0005d8128')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'e69e97b7-04e3-4d77-a118-031a1490185a', N'Saipem LTD Norway Branch', N'671e53de-efbc-4d16-993b-a2bb99970a1e')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'0a7357fb-2cb8-45b3-b7f7-032937b21171', N'Atwood Advantage', N'd9453d0c-381b-4e5c-8f6e-2fb90f11ba94')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'a2fe2346-d721-4998-828e-0340e13d6458', N'Worley Parsons', N'1b0ae3b8-1489-4e12-844a-5825346a098d')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'6f8f52e2-45da-4fcc-9796-0341f8ef7a96', N'Athlon Solutions', N'457ba21e-7cb1-488c-8fbf-6c561ea20539')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'89f3b007-5988-492c-91e9-0660dc35c418', N'LONGHORN LEASING', N'83c51eb7-5a81-4edf-a8ec-62f8cef04cfc')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'5a546784-a3e2-4bda-b15f-066e9df943d2', N'HORNBECK OFFSHORE', N'ba36c956-f116-4f04-9b36-b4424234b53f')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'cd5fc604-9aed-4993-8a6b-06727a257a14', N'National Oilwell Pty Ltd', N'1b0ae3b8-1489-4e12-844a-5825346a098d')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'14a2a90e-7a2a-484d-b3ca-0673ca29ced5', N'ALM Offshore Pte Ltd', N'7953a17d-c0a3-4315-99c2-b5c2cf9e60a9')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'0dff0daa-7f95-448a-9510-06a9c7549d3c', N'Oceaneering', N'33bf71da-de1a-4b96-b6db-ee82c6208c1d')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'edb6d9fa-9f95-4ea0-85a8-06b38136abdc', N'SCOMI OILTOOLS (CAYMAN) LTD', N'ca7b6679-1101-4541-a3bf-a440649f17b6')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'bf67c030-c750-4a0f-91fe-06c09a910bbd', N'Songa Offshore Rig 3 AS', N'671e53de-efbc-4d16-993b-a2bb99970a1e')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'ca7de54a-2c49-40e5-86c1-06ceb9ab8083', N'Atlantic Marine Services Pte Ltd.', N'7953a17d-c0a3-4315-99c2-b5c2cf9e60a9')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'fcb2e7bf-df53-4707-8ab3-06d04ca9dee1', N'Shrieve Chemical Service', N'457ba21e-7cb1-488c-8fbf-6c561ea20539')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'd4892be8-3599-43b3-a81a-06d464d76fc1', N'BESCO TUBULAR', N'8c73a17c-a7f9-4e5f-b8c3-18fd8ad83216')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'5c26f292-c1fe-4bc3-bd7f-06d92e820699', N'At Balance B.V.', N'7953a17d-c0a3-4315-99c2-b5c2cf9e60a9')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'18c8907d-44b7-4c78-8abe-06de01d1f9a3', N'Geoforce, Skybitz, Flex test', N'3b09c9dc-83ed-4ab0-a853-8d7dc49a14b0')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'62147cdb-624a-4e75-aaf1-06f96092c90e', N'Pioneer Natural Resources', N'457ba21e-7cb1-488c-8fbf-6c561ea20539')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'9479ebdb-ce55-46e0-9681-0722722a97c0', N'JS CHEMICAL', N'a57c490a-7196-4117-a731-1cca8431d1ec')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'1f15dc43-acda-4f06-9d01-0724dd64e73c', N'Falcor Engineering & Contracting Service', N'ca7b6679-1101-4541-a3bf-a440649f17b6')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'79659772-12a3-49ce-8fc0-07264ed45fc1', N'SengS Subsea Engineering Solutions Ltd', N'399d88cb-cc90-4739-816b-611491267c5c')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'70aea982-7142-41ab-b6bf-072fd43764fd', N'Brazil Customer Companies', N'fa2b8138-d006-4ed3-8339-99d707c30e95')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'99000d9e-0ac6-4c4b-b9d2-0732a3f93ccb', N'LEBLANC & ASSOCIATES INC.', N'83c51eb7-5a81-4edf-a8ec-62f8cef04cfc')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'1158d613-55dc-469e-a9b1-074c49335fc3', N'American Coatings', N'33bf71da-de1a-4b96-b6db-ee82c6208c1d')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'0d6bceba-4d09-490a-b185-075d9d54ba22', N'PT ENSCO Sarida Offshore', N'7953a17d-c0a3-4315-99c2-b5c2cf9e60a9')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'0bb8441c-fcbc-4638-a4f5-075fca16cb68', N'PIPE PRO', N'6850b26d-afcd-441c-9c1a-5fa3b957c048')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'c522448b-3105-4677-af14-076fb87f30fb', N'ICY LA', N'88f1879f-38b5-4dd6-a5d7-daec3f66e80b')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'6b05e280-8542-4c5b-915d-078bb06138b6', N'Wash Facilities', N'bf6bdd09-427b-405f-a280-d6f84ef98d4a')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'6f6d9a52-6f41-4769-8bdb-079ad60422cb', N'Boskalis', N'ca7b6679-1101-4541-a3bf-a440649f17b6')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'8378d2b1-dbcc-4f15-a2d3-079cfa56bbd7', N'BENNU OIL & GAS (83054)', N'1a9f05de-75c2-4bce-8771-d1195321b2dd')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'8365e557-298a-455f-8e67-07a580fa5aac', N'Specialty Chemical - Port Fourchon Hub', N'53a9c910-9bcf-4b83-81b6-ab4e5b9777c9')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'11bb5c14-5fc3-4eb5-90ae-07b1db0b7458', N'LAMPRELL ENERGY', N'83c51eb7-5a81-4edf-a8ec-62f8cef04cfc')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'19979ea9-ed56-44c4-94e6-07ba593c5412', N'PENTAGON FREIGHT SERVICES LTD', N'399d88cb-cc90-4739-816b-611491267c5c')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'c0edff4b-8b26-41d6-924f-07bcf5b5418b', N'Ensco Australia Pty Ltd', N'1b0ae3b8-1489-4e12-844a-5825346a098d')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'c7e85c0b-cdcb-44a7-bf2d-07cb6d684653', N'MAIN PASS 265', N'317a58b7-6bc1-40b2-9bf2-f500e9e38dc7')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'9300e411-bfe0-46b8-8fe4-07ce9e4218fc', N'Cameron Australasia Pty Ltd', N'1b0ae3b8-1489-4e12-844a-5825346a098d')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'06e111c6-c305-402e-ad80-07df8184c870', N'Clough Projects Pty Ltd', N'7953a17d-c0a3-4315-99c2-b5c2cf9e60a9')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'4c85de2b-3cb5-4334-846f-07eba030e84d', N'WARING OIL COMPANY LLC (5428)', N'1a9f05de-75c2-4bce-8771-d1195321b2dd')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'451e9f03-ea18-4363-b00d-07f1d564f63f', N'SCHLUMBERGER TECH CORP (LA) (81988)', N'1a9f05de-75c2-4bce-8771-d1195321b2dd')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'2870b896-b22b-46fc-a9a7-07f4b7d2d4e9', N'Frames Energy System B.V.', N'7953a17d-c0a3-4315-99c2-b5c2cf9e60a9')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'c5b1080b-28c6-4c44-9462-07fcabe192ca', N'CONRAD SHIPYARD LLC (22657)', N'317f2aec-617e-48d3-8d43-a877a5bb91e0')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'1c40dca0-931f-4043-93b1-07ffdd7a832e', N'UNDERWATER CUTTING SOLUTIONS', N'399d88cb-cc90-4739-816b-611491267c5c')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'e4f47ddc-0672-48ec-9c99-08034441f9f6', N'GLOBAL ENERGY GROUP(ACCESS & COATINGS)LTD', N'399d88cb-cc90-4739-816b-611491267c5c')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'4737ce17-c1a7-4209-9d24-080b3f72af7d', N'Hoover Ferguson Malaysia Sdn. Bhd', N'29d0d5a7-4f0d-4975-bb14-3b52be6a13ac')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'deb8eed6-f041-44fc-bdc5-0818afa9bf1c', N'Swift Water Energy', N'457ba21e-7cb1-488c-8fbf-6c561ea20539')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'2bdfb148-6948-4640-92c9-08263e1dee86', N'Core Labs', N'39eb12ed-d5f2-4417-a59b-73a07ec79710')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'4c058dac-675a-4f88-bdd3-082e915aae95', N'Sandstorm', N'a4258fe5-2cc4-49e2-a6d1-2301d38ddb59')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'b5f8e66c-a54c-46a4-93eb-08335e85a599', N'BROUSSARD LA', N'5be20188-1f58-4e11-8254-735e74db9c7c')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'46808fef-329f-4de8-86f1-08376b5712b9', N'SP22B', N'17d1b070-271d-4289-b809-bc0ccee1fb39')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'094667a5-b470-44c3-abd5-11fdc5cb68b3', N'ENTERPRISE (83064)', N'1a9f05de-75c2-4bce-8771-d1195321b2dd')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'a01f97d6-3adb-4f55-a5f1-1210b9476284', N'White - Incoming Totes (Jennings)', N'd89ee97d-b310-4f2e-831a-a1e32aa8173f')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'96ddb0ac-298f-43ba-bae7-1214820a1b2d', N'BIBBY OFFSHORE LTD', N'399d88cb-cc90-4739-816b-611491267c5c')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'b7dfaf64-e941-4536-8bf4-122014de86fd', N'Oilfield And Resources Rentals', N'1b0ae3b8-1489-4e12-844a-5825346a098d')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'c515ebe5-bcae-43a6-bd0b-12364ebfed85', N'Midsouth', N'b8ff1168-1f7c-4235-b835-99a2432abbb7')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'd1bccf3b-a653-4cd9-b852-123f7b96c2e6', N'PRIDE RIG NEVADA', N'ce6cd0aa-23c1-499d-8e7a-9e253ac6dd1f')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'20580fd4-8137-4c4a-b2c6-124046b727b9', N'PeroxyChem', N'457ba21e-7cb1-488c-8fbf-6c561ea20539')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'4595f92f-7c10-4cd7-b081-1256a7f82222', N'BROUSSARD BROS/UNOCAL - CNAEP (83295)', N'1a9f05de-75c2-4bce-8771-d1195321b2dd')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'7de4d853-f030-44c2-aa2b-125d7d9c24cb', N'MONCLA 128', N'2306f716-0c49-45af-895e-776c2a6dcebb')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'5856656a-db22-47f7-8dca-12647119c66d', N'KS Deepsea Drilling Comp.', N'671e53de-efbc-4d16-993b-a2bb99970a1e')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'541d12d8-18f5-42b4-8589-126490600b5b', N'Specialty Chemical - Green - Jennings', N'ac725b18-c333-4618-a3c5-d91cce5535c1')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'c856dd6f-fb64-4309-879a-127a5dd4e55f', N'OEG Offshore Pty Ltd', N'1b0ae3b8-1489-4e12-844a-5825346a098d')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'40110e72-c9d6-4dec-b362-12939eac42fe', N'Nikiski, AK', N'e8109e7a-ec76-464a-8a89-d52d0ae83b05')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'6aa58503-097c-4a9a-a623-129d1f0a590d', N'SHELL PIPELINE CO-HELIPORT (23129)', N'1a9f05de-75c2-4bce-8771-d1195321b2dd')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'9cc5cc45-fb50-4674-ada6-12aa477d3366', N'DAVIS PETROLEUM CORP (3418)', N'317f2aec-617e-48d3-8d43-a877a5bb91e0')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'ab6be9f5-fd77-445f-92ff-12b38641e7b7', N'C&D WIRELINE/BROUSSARD', N'dfd80c0a-c04e-4ec4-abe1-dc76dbd1528b')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'71bfb4a7-69a6-4a53-8d27-12c4add451bb', N'Oasis', N'b1baabf6-c149-424d-b147-a13e0ec19a02')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'f8fc0ae0-ce32-431d-a087-12e6fc9a8d12', N'ASSOCIATED TECHNICAL SUPPORT', N'a57c490a-7196-4117-a731-1cca8431d1ec')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'025a6c67-2017-4984-9b68-1302dee0d598', N'CPD Oilwell International Pte Ltd', N'7953a17d-c0a3-4315-99c2-b5c2cf9e60a9')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'30702790-936c-4258-9c8e-1303e399cde6', N'STATS (UK) LTD', N'399d88cb-cc90-4739-816b-611491267c5c')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'b38903fd-095a-46b1-80f0-1307cf9e40b9', N'SPARROWS FLUID POWER LTD', N'399d88cb-cc90-4739-816b-611491267c5c')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'cced537d-d03e-43f0-92e3-130bff0df096', N'Netherlands', N'0d12847e-100a-4ace-99d1-781136e83066')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'24586bd5-22b0-41c4-834a-131f5d78a035', N'comp1701_3', N'd0f5089c-5631-4671-acb8-4300ea0831e0')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'4c4bbb3c-86cb-4778-95e0-132758311c3b', N'UMD SOLUTIONS', N'457ba21e-7cb1-488c-8fbf-6c561ea20539')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'aaf4a285-c40e-4844-a339-132dc7be748e', N'ERA Tanks Off-Rent', N'3c6870e0-c9c4-419e-98e0-ecc4a57a20e7')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'0cb65ba7-0647-49d1-9ca9-1332666c53a3', N'Bachman Services', N'33bf71da-de1a-4b96-b6db-ee82c6208c1d')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'76f02cdd-7549-4331-919e-1347b1d25f9d', N'VANTAGE SUPPLY & SERVICES LLC (60999)', N'317f2aec-617e-48d3-8d43-a877a5bb91e0')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'9275d35b-ad13-402f-bb22-134d816d719c', N'Arena Nord', N'671e53de-efbc-4d16-993b-a2bb99970a1e')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'fb74142b-6a6b-4c16-aef3-134f08596fa1', N'BAKER OIL TOOLS (3167)', N'1a9f05de-75c2-4bce-8771-d1195321b2dd')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'f57914a5-93e2-41ec-ad4d-1352135454b0', N'Strachans Limited', N'399d88cb-cc90-4739-816b-611491267c5c')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'b5e8f2e6-e812-4439-89b2-1358556c14c5', N'GE OIL & GAS PRESSURE CONTROL LIMITED', N'399d88cb-cc90-4739-816b-611491267c5c')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'14fd35a3-a5f2-4784-b456-135f4cb650ab', N'AXIS COMPRESSOR', N'1acc0789-414c-4248-9a90-7ee0967a6e04')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'579a20cd-a300-4f7a-9496-1363d72b2019', N'HOUMA ', N'aae88e59-0688-4738-b94d-334a5acbf0fc')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'57e9ed58-436a-4250-8053-1363debf4c99', N'STRIC-LAN', N'5773cd93-ebf9-4dfa-8346-88ff1f47060f')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'ef49318f-882d-41db-bc15-13643aae716b', N'Complex Chemical Co', N'b8ff1168-1f7c-4235-b835-99a2432abbb7')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'2f5379b6-d98e-417c-94b7-13828c565bac', N'UMD', N'a4258fe5-2cc4-49e2-a6d1-2301d38ddb59')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'0c3484a2-7b93-4f7a-b4ca-13882d4e56c2', N'UMO - Port Fourchon Hub', N'53a9c910-9bcf-4b83-81b6-ab4e5b9777c9')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'a5e186aa-eef2-4737-8e75-138863dc71dd', N'Brazil Yard Assets', N'fa2b8138-d006-4ed3-8339-99d707c30e95')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'1632e133-258c-4580-8b2c-13890b990781', N'WEEKS MARINE INC (3127)', N'1a9f05de-75c2-4bce-8771-d1195321b2dd')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'693bd192-eb1d-408f-b494-1389ab96bc1a', N'Baker Corp.(68606)', N'b8ff1168-1f7c-4235-b835-99a2432abbb7')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'2e8f9168-05a3-4aa0-8682-138f467b5b51', N'CRESSON/TX', N'99af93cb-6557-40f1-b4fa-365c04052917')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'89eafdcf-e50a-4d43-906d-13a59161a118', N'HP1 Green Canyon', N'17d1b070-271d-4289-b809-bc0ccee1fb39')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'65276f2e-7cbd-4c21-aa9a-13c2486d7b2c', N'Neptune Marine Services Pty Ltd', N'1b0ae3b8-1489-4e12-844a-5825346a098d')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'b493a6ca-4933-44e0-92a7-13ddb74f8d4c', N'Schlumberger D&M', N'bea5defb-dbfa-44eb-b3f5-411923cb95fc')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'b4793a91-cf3d-487d-8826-13f623a06cd6', N'Precsion Chemicals, LLC', N'33bf71da-de1a-4b96-b6db-ee82c6208c1d')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'61079035-1c30-443e-9887-13fd9be884f7', N'Oil States Industries UK Ltd', N'399d88cb-cc90-4739-816b-611491267c5c')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'9aa849ae-7b3d-4c5d-95bf-1401f63ede88', N'Norsea Group Norway', N'011f0e75-3e96-4758-966a-3912a7224bf3')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'4493c010-a089-4acd-bbff-140a8416b2be', N'Mintech Chemical Industries Pty Ltd', N'1b0ae3b8-1489-4e12-844a-5825346a098d')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'ea6bd3f3-207e-4c04-997d-140acf270243', N'CAMERON', N'c9b99844-31e5-47be-9f31-f383a307fafe')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'0791158c-8989-488b-9c3d-14156a5f2724', N'SG06', N'51da9f8b-73eb-43d5-ba84-fad564b687fe')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'5eed5c50-772a-455e-822c-141b5e7adf4c', N'Transocean, Mongstad', N'03e4d079-2e10-43e2-9691-d94f3b54e31c')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'bf685894-ab2b-41f8-84fe-1437b3b82850', N'D&B BOAT RENTALS INC (16352)', N'317f2aec-617e-48d3-8d43-a877a5bb91e0')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'ea6ea7bb-af08-4bc4-ab1d-143c8d6a2144', N'WILLLIAMS FIELD SERVICE (3610)', N'1a9f05de-75c2-4bce-8771-d1195321b2dd')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'e2a66bb5-a6ca-4486-8dfa-1441af83ce29', N'Third Party', N'dd61322a-7938-499b-901d-fd9e2d043a83')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'f7e4e928-f5ac-44c8-a9a2-144522d2c600', N'I', N'a57c490a-7196-4117-a731-1cca8431d1ec')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'cc6b418f-f57d-4e6b-990a-144677593e88', N'Santos Perth', N'c489a1e9-b2d5-44f9-8612-039fa709f7fc')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'0a546937-93b5-4919-a93c-14471dce9706', N'GPS holding hoover norway', N'8fd12f44-ba47-475e-b489-40bc8ad86fda')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'9083a5f5-cee7-46ba-867f-1454eff38f41', N'SMITH BITS', N'5773cd93-ebf9-4dfa-8346-88ff1f47060f')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'503d4259-3246-43c0-b235-14741fb21344', N'HTS - Tomball - US Well Consignment', N'6e2015f0-cc3b-4c37-a13c-02af1112deaa')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'f4d79a60-9911-4d7d-b796-1484db081098', N'Apache Oil', N'33bf71da-de1a-4b96-b6db-ee82c6208c1d')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'd9f29df4-456c-4fa6-b9c8-1489e655d9dc', N'BAKERSFIELD CA', N'46ba404b-99c6-4e92-8e63-2e94706e27f6')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'cafa120d-13f8-4fc9-a9c5-148d228338f9', N'MONCLA 108', N'2306f716-0c49-45af-895e-776c2a6dcebb')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'8416c082-21ac-435e-b89b-148f8189750f', N'EXTERRAN (22744)', N'1a9f05de-75c2-4bce-8771-d1195321b2dd')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'233dffd1-f745-4299-93f6-149a1e336c16', N'HOSPORT (85024)', N'1a9f05de-75c2-4bce-8771-d1195321b2dd')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'934b53d4-e55b-42ee-9e2e-149dfa054abb', N'B & W Fluid Dynamics Inc', N'33bf71da-de1a-4b96-b6db-ee82c6208c1d')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'9ade7261-e356-4ef4-a25b-14bb4ce7b73c', N'VR-131', N'17d1b070-271d-4289-b809-bc0ccee1fb39')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'b4f17b93-277e-464a-8809-14c190f66baa', N'Enermech', N'ca7b6679-1101-4541-a3bf-a440649f17b6')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'619597cc-f7b4-4b62-8c5c-14cdbd64ebbd', N'PEREGRINE OIL & GAS LP (16898)', N'317f2aec-617e-48d3-8d43-a877a5bb91e0')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'a80d4dc2-9981-472b-a8d3-14d29fea2e21', N'GIS/FOURCHON', N'8f2fe33c-a719-4adb-b176-2869d6d97542')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'5f9a67ba-072c-46b6-b428-14f64b7ae1a4', N'Modec Management Service Pty Ltd', N'1b0ae3b8-1489-4e12-844a-5825346a098d')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'c59982a9-6b2e-4af7-95e1-1510aae454d3', N'BHI AP General Non PO', N'457ba21e-7cb1-488c-8fbf-6c561ea20539')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'3077b02f-d748-4233-92ec-1513ce787e79', N'M21K/ENERGY 21', N'38f7bfd9-98cd-46a6-b47b-ee49dc7e8751')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'03420a4d-28f3-412a-be56-151593801294', N'Kristiansund Industriservice AS', N'671e53de-efbc-4d16-993b-a2bb99970a1e')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'14fb55ab-ff54-4916-bf1e-1516574bc3cc', N'INTERTEK/KCS (66524)', N'317f2aec-617e-48d3-8d43-a877a5bb91e0')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'c7e63230-1b88-48d8-a77c-152531b0d84d', N'Schlumberger Drilling Services Sdn Bhd (MI)', N'7953a17d-c0a3-4315-99c2-b5c2cf9e60a9')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'49d658f5-f5a3-4bf6-8506-15276596d844', N'AXIALL INC (84505)', N'1a9f05de-75c2-4bce-8771-d1195321b2dd')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'9d5dd3df-7245-4534-bf18-153e7d62b36e', N'Univar Demo', N'3c6870e0-c9c4-419e-98e0-ecc4a57a20e7')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'4058af38-ab16-4fed-9a71-154a09f7ea19', N'CONTANGO', N'c53a4398-fe51-4744-afee-2ca5115c9515')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'b5420dd0-0b25-48ce-8c39-154bd3adfae6', N'Ferguson Group Limited', N'ca7b6679-1101-4541-a3bf-a440649f17b6')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'7ea2b7e4-8d23-452d-b2eb-1559fda22057', N'WILLIAM STATION/ALABAMA', N'aaf7fd18-c72a-431b-8743-7504a26a650e')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'5d7a1f5c-f762-4795-8cf3-155bfec4c85d', N'CANRIG DRILLING/NABORS DRILLING (82898)', N'1a9f05de-75c2-4bce-8771-d1195321b2dd')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'3469f4bf-fca5-42d2-9c7d-156727036183', N'EGYPT', N'0032c9e4-8919-430f-b848-a233f456d179')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'c90d14f4-02f4-404f-b29d-156b4ab8e59d', N'FLOWCHEM LLC', N'457ba21e-7cb1-488c-8fbf-6c561ea20539')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'afa3a677-3e53-4738-9ded-158f173b500e', N'Sachem Inc.', N'33bf71da-de1a-4b96-b6db-ee82c6208c1d')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'837de803-da30-4f36-bd94-159dcecc06e7', N'BROUSSARD LA', N'7d778f65-16e6-4fd7-a5d7-1ac67abfcb8b')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'2eca557f-caff-4a78-82f2-159e06db9de7', N'Cetco Energy Services Limited', N'399d88cb-cc90-4739-816b-611491267c5c')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'2bf2bbce-1d44-4e9e-a22a-15a0118cb9ab', N'MI Swaco', N'e79b1a9f-4f7b-4622-9638-da25f36c7d22')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'58fb9e6c-59ad-4f28-a08d-15b57b88d14e', N'ORION MARINE CONSTRUCTION (84640)', N'1a9f05de-75c2-4bce-8771-d1195321b2dd')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'20c4b12c-ef22-4621-bc74-15ce24f52ea0', N'EXPRO/BP AMERICA (82974)', N'1a9f05de-75c2-4bce-8771-d1195321b2dd')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'044d8f54-0caa-426d-9867-15d3ec414e99', N'Anser Trading & Marine Pte Ltd', N'7953a17d-c0a3-4315-99c2-b5c2cf9e60a9')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'c3dc8d99-33be-48b4-91ba-15ddb39c196d', N'Marlog AS', N'671e53de-efbc-4d16-993b-a2bb99970a1e')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'705896a4-4a51-4312-83b2-15ee1aca2fde', N'EXXONMOBIL CORP (4287)', N'1a9f05de-75c2-4bce-8771-d1195321b2dd')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'0f31ac24-a40a-47fe-8cfb-15eeeb9c1c66', N'J. RAY MCDERMOTT', N'819930d1-02f1-41c0-843e-71af5fda90b2')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'd9af9f6e-48ad-493d-850e-15f13b69fa1e', N'DEVON ENERGY - OFFSHORE (83299)', N'1a9f05de-75c2-4bce-8771-d1195321b2dd')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'e09f4814-c741-4353-b8af-1603b3590cb6', N'Greenfield Global USA Inc.', N'33bf71da-de1a-4b96-b6db-ee82c6208c1d')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'750e0a36-60f4-42fa-8890-1603f0ed9741', N'Harbor Island', N'8c546bbd-d040-4c8c-b602-4fac952f18c9')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'26cd335b-da83-4998-b6db-16164a8e1eae', N'LCH Test Yard', N'13a65046-4a5d-4ea2-8d8a-e97a5f3a0808')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'1c951eec-35b6-4195-bf0d-162c62d186d8', N'Marathon GBR', N'33bf71da-de1a-4b96-b6db-ee82c6208c1d')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'd8d9ad92-6c70-44e0-9108-163671872a76', N'Macdermid Canning', N'457ba21e-7cb1-488c-8fbf-6c561ea20539')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'18f9140b-7128-4d88-9bb9-163a32aff76a', N'Tokai Carbon', N'33bf71da-de1a-4b96-b6db-ee82c6208c1d')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'53af111e-7f17-49f7-a58c-164f26c639c9', N'Coates Hire Operations Pty Limited', N'1b0ae3b8-1489-4e12-844a-5825346a098d')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'9af634df-4a06-4c5f-aa97-1654ad3667c6', N'2. Yellow - Pending Evaluation (Houston Washline)', N'9ff30ed9-3129-410e-85ec-70f437ba251f')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'2ebb0d30-49ae-43e7-acec-165b0f9f0a94', N'Multiple Sensors', N'acdc1b8c-ff33-4960-9024-197d1a727511')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'9e565159-dca1-4e40-8032-165c47ff17ec', N'AET OFFSHORE SERVICES INC (3311)', N'317f2aec-617e-48d3-8d43-a877a5bb91e0')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'5c95f262-3ad1-402e-84b0-1663ca3e60db', N'THRU TUBING SOLUTIONS', N'575a4105-f57c-4f58-8de9-44745e8751ef')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'a501e6f8-66f4-4fab-94b2-1666f748bb51', N'WEATHERFORD SOLID EXPANDABLES', N'08c9687f-eb7b-4ec0-ad4a-d88dff3b940e')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'46ea8895-0cef-4c48-87f6-167f16993d8e', N'Buzzard', N'8aec1d1e-c520-4e54-aa8a-cffc2b66f6c3')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'd7f4a5de-e328-4dab-9d94-168086a4eca8', N'Company07_1', N'd0f5089c-5631-4671-acb8-4300ea0831e0')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'de02055f-ef80-4309-8e29-168af1eb0e38', N'CRANE WORLDWIDE UK LIMITED', N'd7401882-ee58-449b-a807-60be386d9196')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'467175ce-0a23-4470-b88e-168f7b9d4fdb', N'Anadarko Petroleum Corporation', N'b8ff1168-1f7c-4235-b835-99a2432abbb7')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'a848ea29-68cd-4684-9957-16922f56b54c', N'Cutting Underwater Technologies UK LTD', N'399d88cb-cc90-4739-816b-611491267c5c')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'ccffb3da-b7c2-4d9c-823f-169fc98a232e', N'Jack Decker Distributing', N'33bf71da-de1a-4b96-b6db-ee82c6208c1d')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'396668c3-4a93-4c14-90c0-16a67a106671', N'Other Dedicated Use Totes - Green - Jennings', N'ac725b18-c333-4618-a3c5-d91cce5535c1')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'2750035a-e95d-479c-b498-16ae10718af9', N'NAS 6 - Theodore', N'1147ec84-66c2-4b5c-8a52-0f8e7a428966')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'072c7510-b7c2-4453-8e56-25eea8cf105c', N'LIMESTONE BRANCH DISTILLERS', N'33bf71da-de1a-4b96-b6db-ee82c6208c1d')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'a26eda9e-c12a-4865-8662-260058002b61', N'CESI', N'51ace22c-1695-48f5-b972-7c5f29cd7806')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'15527ab5-3279-491d-8ab3-2607d8f153b5', N'CSAM Integration', N'ecb43577-4c5b-4bf5-92c7-2d01163e6485')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'46554b4e-973a-4b50-8086-260cb0e52a6a', N'PEARLAND TX', N'a501e6f8-66f4-4fab-94b2-1666f748bb51')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'f1c9b0c5-fd21-4b64-96c5-261b381dcb78', N'TAQA Bratani Ltd', N'399d88cb-cc90-4739-816b-611491267c5c')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'89456de8-5b32-4445-8f33-261ed9bd2858', N'MARINE INDUSTRIAL FABRICATION (81343)', N'1a9f05de-75c2-4bce-8771-d1195321b2dd')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'e688df8e-0468-4685-87b6-26310237f1d4', N'EXXON NEFTEGAS (83645)', N'1a9f05de-75c2-4bce-8771-d1195321b2dd')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'94451021-c467-4032-a083-263a1ed7ad2a', N'ENGINEERED CONSTRUCTION & MAINTENANCE PTY LTD', N'1b0ae3b8-1489-4e12-844a-5825346a098d')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'3f69a52a-551a-46e8-980a-2654813e1915', N'FTSI', N'b1b07d38-7329-4120-9391-ce2aac1da26e')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'02a27241-26b0-459e-93eb-266acb184ea3', N'Theodore', N'8c546bbd-d040-4c8c-b602-4fac952f18c9')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'd54a2852-66fd-4176-ad68-266b4502efc9', N'ORION MARINE CONSTRUCTION INC (3262)', N'317f2aec-617e-48d3-8d43-a877a5bb91e0')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'ad83b06d-a95a-4234-b0ef-266fefca5de3', N'Genesis Energy', N'33bf71da-de1a-4b96-b6db-ee82c6208c1d')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'f70e90fd-7867-4bc0-a808-2671a5512ad8', N'Balcones Distilling Company', N'33bf71da-de1a-4b96-b6db-ee82c6208c1d')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'aafb1f51-5166-4b8e-afb4-267eb60110b7', N'TRANS GLOBAL PROJECT (S) PTE LTD', N'7953a17d-c0a3-4315-99c2-b5c2cf9e60a9')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'cbe0a197-567b-4098-83db-2683f6c4f3a1', N'Gearhart', N'70002304-d5bb-42a5-b41c-f25971188fac')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'ba761019-0923-498f-89ec-2696feb70c24', N'GRAND ISLE SHIPYARD INC (2793)', N'1a9f05de-75c2-4bce-8771-d1195321b2dd')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'a853a442-0fd3-4b78-92bd-26980e829749', N'EPIC OILFIELD SERVICES SDN BHD (TUBEX)', N'29d0d5a7-4f0d-4975-bb14-3b52be6a13ac')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'3aa3e3aa-3dcb-4727-be74-269a90a79f35', N'WST', N'457ba21e-7cb1-488c-8fbf-6c561ea20539')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'3617ca84-8edd-413c-8063-26a1eeca4c4c', N'A&B INDUSTRIES (82177)', N'1a9f05de-75c2-4bce-8771-d1195321b2dd')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'329a9ff2-144f-4e40-9b5b-26ab00420a9f', N'Aquatic Engineering & Construction', N'7953a17d-c0a3-4315-99c2-b5c2cf9e60a9')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'043052bb-d3c3-4d4f-8c63-26adef8eadd0', N'HALLIBURTON SERVICES TOOLS/NEW IBERIA', N'49132bf4-2003-430e-96c8-112ee717659b')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'56b6a6f6-366b-42f7-be06-26b28aa8c3b1', N'Demo Archives', N'7014e7ca-224d-4ef1-898c-5014c01e59e6')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'de6e1f03-af32-4b59-9a64-26bdcd5c68cb', N'LAKE MARY/FLORDIA', N'3abcbdfd-2faa-41d6-95de-3f132a152f10')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'e7abc091-2bd4-439d-9aad-26e7eff67861', N'LUBRICON LTD', N'0e598981-a5c4-42a0-bf84-5df56ed0b497')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'0ccf9696-66f6-42a7-abc7-26ee58d530af', N'Offshore', N'70c39f87-e0a5-4612-a998-ab615c399e52')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'8d77d2fa-14c0-457a-af02-26f39dc5fee0', N'Primero Group', N'bea5defb-dbfa-44eb-b3f5-411923cb95fc')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'9ad71bb3-7793-44ae-a33c-26f8258e316a', N'Internal Use Companies', N'a1133f3e-b1f4-4c84-a679-ed3880e5eb4e')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'146bf033-3ba4-4c9a-a6f5-26fe4b4f08d5', N'APEX Fracking Fluid Solutions', N'51ace22c-1695-48f5-b972-7c5f29cd7806')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'd34c4d01-5e2c-4a26-97ad-27011479b72a', N'Lube Oil - Red - Morgan City', N'b41e1471-1b7b-49b5-b5d2-748e2336b845')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'c906359b-181a-4904-8a03-270404291fea', N'MI SWACO NORTH/APACHE DEEPWATER (82879)', N'1a9f05de-75c2-4bce-8771-d1195321b2dd')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'a017b6d1-bfb8-4392-8d1c-270e17fda66d', N'Agility Shipping Pte Ltd/Agility Project Logistics', N'7953a17d-c0a3-4315-99c2-b5c2cf9e60a9')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'12e16680-c205-4eb4-a44e-272486e8a552', N'USVC', N'3e6c788e-11b4-4fcb-b69b-6cedc39ae234')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'19ab7aea-13a0-4a1c-a4fe-272811fce1ff', N'AMELIA', N'f798ad11-7c85-4d04-9946-7ab068f4513d')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'b1486755-f3bc-489e-9a22-272ab1c45b00', N'Hoover Ferguson Malaysia', N'3f01b8b4-c765-491d-a120-7a5d3a70e146')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'63f1db41-4ae3-4667-b6f3-272bd8b3e071', N'CHEVRON USA (20651)', N'1a9f05de-75c2-4bce-8771-d1195321b2dd')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'b3741aa9-917c-45e3-b7ff-272d095f0543', N'BROUSSARD', N'4d56394e-490a-44e5-b721-392789ae14b2')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'727b50e8-089b-436b-8971-27363e2af72f', N'ARKANSAS', N'f3d1e925-8098-41d7-b037-78e2f835d720')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'f1bec60c-6e6a-452f-8e64-2738e51c5977', N'Channelview', N'8c546bbd-d040-4c8c-b602-4fac952f18c9')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'1a061e3d-7f91-4633-b02a-2740e6bdcfa1', N'NAS 6 - Red - Harbor Island', N'71e1e186-f274-4b34-9b45-493086f9279d')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'ab1b6d35-3882-4691-bfdb-274128fd330f', N'Test0601', N'd0f5089c-5631-4671-acb8-4300ea0831e0')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'ec3389bb-3329-4ae4-938c-275598f5193f', N'Optiblend industries', N'457ba21e-7cb1-488c-8fbf-6c561ea20539')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'b24f306b-ae45-4a7e-b965-2755b1b43208', N'BJ Services International', N'7953a17d-c0a3-4315-99c2-b5c2cf9e60a9')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'240c9547-7297-43b8-bc39-2757c8a8131c', N'Nalco Champion North East', N'1438f516-6fde-4657-8f3a-e3fac4c19b55')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'a1695a18-deb6-4cec-9806-2765cac7f10c', N'BHPB (AMERICAS) PET INC (22546)', N'317f2aec-617e-48d3-8d43-a877a5bb91e0')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'a81f8c92-2232-4d76-a8dc-276b6860b6c5', N'SUPERIOR SLICKLINE', N'a57c490a-7196-4117-a731-1cca8431d1ec')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'ee049ca5-b755-4551-be76-27823d57e0f2', N'ENBRIDGE OFFSHORE GAS TRANSMIS (22723)', N'1a9f05de-75c2-4bce-8771-d1195321b2dd')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'782f81b3-77ad-41ed-9a99-278a5a70abf8', N'Baker Hughes Angola', N'457ba21e-7cb1-488c-8fbf-6c561ea20539')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'f9e2b3ef-5f89-4e0e-8c1b-2790401451ff', N'MARTIN ENERGY SERVICES', N'38f7bfd9-98cd-46a6-b47b-ee49dc7e8751')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'636ccc1d-c230-4af9-bc3c-279e722d7d9b', N'Orontide AlphaBlast Pty Ltd', N'1b0ae3b8-1489-4e12-844a-5825346a098d')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'ef0d19fb-6b47-4338-b12b-27b71f686d4a', N'HOUMA', N'04ffc8a6-130c-4db7-8a88-616077627e5d')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'c7aebfc0-71bf-461e-a124-27c670f174b4', N'MEXICO', N'1f697c52-467d-4e29-bcda-bbcb0bf0d364')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'93040e7b-b210-42bc-8e72-27ce4ccbae43', N'Port Fourchon Hub', N'277ab59a-d687-427e-854a-d1fd950ba739')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'20cef26a-1a6a-417d-b1c6-27d4cbc0e608', N'HI 309', N'317a58b7-6bc1-40b2-9bf2-f500e9e38dc7')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'14f7b28c-82c6-4e8c-b4fb-27d767d6d102', N'SMITH MARITIME (85146)', N'1a9f05de-75c2-4bce-8771-d1195321b2dd')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'e3e2fd1a-ba18-479c-a415-27d76cc80021', N'MCCLEARY OFFSHORE CONST/MANSON CONST (83310)', N'1a9f05de-75c2-4bce-8771-d1195321b2dd')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'de238fc2-ca54-4721-ac34-27e09fb1f696', N'Well Technology AS', N'671e53de-efbc-4d16-993b-a2bb99970a1e')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'91ce3542-9a1e-497f-8f8d-27e50ac7dc4d', N'Transocean Deepwater Mauritius', N'7953a17d-c0a3-4315-99c2-b5c2cf9e60a9')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'b4ac4d9d-a578-4d25-9518-27e80ad3da0d', N'Halfwave AS', N'671e53de-efbc-4d16-993b-a2bb99970a1e')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'13a1a770-dbc4-4261-91d2-27ebfa194769', N'SUPERIOR COMPLETION/LAFAYETTE', N'cdb7133d-6425-4059-b4d4-2eaec51428e1')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'53f7c65f-3b9a-46b8-8a9e-27ed43e7b9ea', N'Diesel - Channelview', N'f1bec60c-6e6a-452f-8e64-2738e51c5977')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'446ddc77-56d2-4c7a-b8ce-27f3bdec2ace', N'Certified Clean - Red - Jennings', N'47f5314c-f23e-4bfc-92d5-54e158a1b4b6')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'd46d8c84-e27a-4811-a22e-27fa28fdb067', N'NewWaves Solutions Ltd', N'399d88cb-cc90-4739-816b-611491267c5c')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'bde5c653-558a-4528-8264-27fe782a8ac3', N'Rigfit International LLc', N'ca7b6679-1101-4541-a3bf-a440649f17b6')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'0b92ef1d-79f1-4c6a-9a96-280f4c430a20', N'AIR POWER SERVICES (83616)', N'1a9f05de-75c2-4bce-8771-d1195321b2dd')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'b3c96cee-d899-49e8-ab1d-281c3747313d', N'Asset Systems Pty Ltd', N'1b0ae3b8-1489-4e12-844a-5825346a098d')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'f3db7548-0ec7-4c57-8f2a-281d5018b67e', N'Brenntag Pacific', N'b8ff1168-1f7c-4235-b835-99a2432abbb7')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'eb6f789a-571d-4050-b52b-28242ff77a23', N'K&B MACHINE/SCHERIVER', N'90999314-bcc8-42ca-99a7-5bcf1ce4102d')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'046da65f-d075-4664-a23b-28294028e0f2', N'Energy Services International', N'ca7b6679-1101-4541-a3bf-a440649f17b6')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'3c828be0-07d2-4a3b-96bb-282a590a8757', N'PBF Refinery', N'b8ff1168-1f7c-4235-b835-99a2432abbb7')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'8b7732b4-7879-4f5a-bc44-282b67ae4437', N'Hostile Environment Services', N'1b0ae3b8-1489-4e12-844a-5825346a098d')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'383e738d-acaf-4381-9f61-282d91633fde', N'HOUMA', N'7ab9cfce-1b6a-40fe-9f15-2bd48bba5440')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'da0a4290-5f4e-4bf6-acf4-28374a441290', N'Unassigned Totes', N'03a1721e-0a51-4d45-ba3e-b734b9f17488')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'6b5e28eb-bb38-4216-b17b-28479676c84e', N'Ferguson Modular', N'1b0ae3b8-1489-4e12-844a-5825346a098d')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'b396eb7e-6fba-41b0-80e9-28484c951060', N'Injection Tanks', N'186eaa77-7d60-4f1d-b4be-936599c71a49')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'724f3c64-fa14-4c46-acba-2850a8730752', N'CAPE INDUSTRIAL SERVICES LTD', N'399d88cb-cc90-4739-816b-611491267c5c')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'6bc93232-af7e-4707-9603-285330aa71ed', N'LAFAYETTE', N'24517a21-0eb8-41df-9583-ccf0d91575e5')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'8f2fe33c-a719-4adb-b176-2869d6d97542', N'DEEPWATER CORROSION', N'041e7d8d-7b10-4e43-b219-3f6f3eebb4f8')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'b86268ce-08e6-469c-922a-28751c7171c4', N'C-PORT 3 / NABORS (84316)', N'1a9f05de-75c2-4bce-8771-d1195321b2dd')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'b085895d-13d3-497f-a82c-2891bb46a998', N'M-I SWACO', N'b4077d1d-22a1-4630-b24b-6fce0cdb409c')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'18cf7bad-ba85-4286-9090-28a3be16717c', N'MP-72', N'17d1b070-271d-4289-b809-bc0ccee1fb39')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'35d2a936-6087-427b-b047-28b00e552af4', N'Kenergy', N'b8ff1168-1f7c-4235-b835-99a2432abbb7')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'208fe61d-0dfd-49e1-b6b2-28b1a3e2da72', N'WILKINSON TECH', N'08c9687f-eb7b-4ec0-ad4a-d88dff3b940e')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'20d95e7f-18ff-485d-bc59-28b5b22a6f86', N'Ekspan Limited', N'399d88cb-cc90-4739-816b-611491267c5c')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'09dad6ee-0044-472c-8f36-28bc1151a485', N'testcompany_1920_8', N'd0f5089c-5631-4671-acb8-4300ea0831e0')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'fc8d2acb-7234-40da-bf67-28bf2b68759d', N'HOUMA', N'52851b67-0f8c-499f-86a2-4bdfc40a144c')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'ded09976-4876-495f-8d22-28ca9fb75332', N'Galveston', N'ad1ec25c-dbc8-4904-a2b5-9de63c8e2a41')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'c36a1e52-8265-4ab8-8f2e-28d0318b6a0d', N'Ferguson', N'3c6870e0-c9c4-419e-98e0-ecc4a57a20e7')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'7b7314cd-2cc1-4afe-a3fe-28d1d5253c22', N'FOURCHON', N'aab58510-56be-4686-85f1-03befdc01316')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'ee0cf02b-a977-476d-9c68-29005b3805d8', N'HTS - Tomball - A', N'1271425d-5e33-4a33-bda6-b012a4a9f7ab')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'bbd57d6a-a137-4bb5-9d0d-290108571b0f', N'PIBC - Port Fourchon', N'b34b1d0c-17d3-427b-8375-6f5336fcb6f4')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'3c1bee51-5dcf-40f7-b3c0-290939ca6802', N'FOURCHON', N'd24a43ed-a0e9-4657-a09b-85fe9120be99')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'72c580cd-d03a-4939-99aa-290f8c2ad5d3', N'prod2505', N'd0f5089c-5631-4671-acb8-4300ea0831e0')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'ef422d87-34ae-4282-8f46-29216b5f4125', N'Other Dedicated Use Totes - Red - Morgan City', N'23af056d-d849-4c00-b1b3-854952b5fa2d')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'd5449c93-efe7-44b3-bbb4-292aa31dce1f', N'FRESHWATER CITY', N'a97e3bb3-ee50-495b-8e62-457bcbabc644')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'0b30f620-158a-42b1-8819-293530bc29ed', N'Hoover Ferguson Malaysia Sdn Bhd', N'ca7b6679-1101-4541-a3bf-a440649f17b6')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'2beec79a-0b61-4ad0-a0ec-29433df7c086', N'Deep Sea Stavanger Pte Ltd.', N'671e53de-efbc-4d16-993b-a2bb99970a1e')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'fc753a95-31c0-4316-84a5-2946c632401f', N'Barrow Island', N'4f2b9114-63d4-4cb2-94db-47a5e557d71a')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'9403961f-1fe9-42f7-a6a4-297a4331eef6', N'Specialised Oilfield Services Ltd', N'ca7b6679-1101-4541-a3bf-a440649f17b6')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'724b0906-0a09-42c0-86bc-29862f433856', N'HTS Gateways', N'570dae73-6ca0-42a8-907b-324daa3282a0')

INSERT [dbo].[Companies] ([Company_ID], [CompanyName], [ParentCompany_ID]) VALUES (N'ae18a644-5ee3-47f9-befa-298d28538df3', N'Al baddad International', N'ca7b6679-1101-4541-a3bf-a440649f17b6')

How to delete from table in case code type have value or not

i want to ignore values contains 0 zero

Vamsi Mukkanti

How to generate orgpath as column of datatype hierarchyid.

Answers (0)