insert into ProductCategory ( ProductCategoryID, ParentProductCategoryID, Name, rowguid, ModifiedDate ) values ( 1,NULL,'Bikes','CFBDA25CDF7147A7B81B64EE161AA37C','2002-06-01 00:00:00' ); insert into ProductCategory ( ProductCategoryID, ParentProductCategoryID, Name, rowguid, ModifiedDate ) values ( 2,NULL,'Components','C657828DD8084ABA91A3AF2CE02300E9','2002-06-01 00:00:00' ); insert into ProductCategory ( ProductCategoryID, ParentProductCategoryID, Name, rowguid, ModifiedDate ) values ( 3,NULL,'Clothing','10A7C342CA8248D48A3846A2EB089B74','2002-06-01 00:00:00' ); insert into ProductCategory ( ProductCategoryID, ParentProductCategoryID, Name, rowguid, ModifiedDate ) values ( 4,NULL,'Accessories','2BE3BE36D9A24EEEB593ED895D97C2A6','2002-06-01 00:00:00' ); insert into ProductCategory ( ProductCategoryID, ParentProductCategoryID, Name, rowguid, ModifiedDate ) values ( 5,1,'Mountain Bikes','2D364ADE264A433CB0924FCBF3804E01','2002-06-01 00:00:00' ); insert into ProductCategory ( ProductCategoryID, ParentProductCategoryID, Name, rowguid, ModifiedDate ) values ( 6,1,'Road Bikes','000310C0BCC842C4B0C345AE611AF06B','2002-06-01 00:00:00' ); insert into ProductCategory ( ProductCategoryID, ParentProductCategoryID, Name, rowguid, ModifiedDate ) values ( 7,1,'Touring Bikes','02C5061DECDC4274B5F1E91D76BC3F37','2002-06-01 00:00:00' ); insert into ProductCategory ( ProductCategoryID, ParentProductCategoryID, Name, rowguid, ModifiedDate ) values ( 8,2,'Handlebars','3EF2C72571354C859AE6AE9A3BDD9283','2002-06-01 00:00:00' ); insert into ProductCategory ( ProductCategoryID, ParentProductCategoryID, Name, rowguid, ModifiedDate ) values ( 9,2,'Bottom Brackets','A9E540898A1E4CF58646E3801F685934','2002-06-01 00:00:00' ); insert into ProductCategory ( ProductCategoryID, ParentProductCategoryID, Name, rowguid, ModifiedDate ) values ( 10,2,'Brakes','D43BA4A3EF0D426B90EB4BE4547DD30C','2002-06-01 00:00:00' ); insert into ProductCategory ( ProductCategoryID, ParentProductCategoryID, Name, rowguid, ModifiedDate ) values ( 11,2,'Chains','E93A7231F16C4B0F8C41C73FDEC62DA0','2002-06-01 00:00:00' ); insert into ProductCategory ( ProductCategoryID, ParentProductCategoryID, Name, rowguid, ModifiedDate ) values ( 12,2,'Cranksets','4F644521422B4F19974AE3DF6102567E','2002-06-01 00:00:00' ); insert into ProductCategory ( ProductCategoryID, ParentProductCategoryID, Name, rowguid, ModifiedDate ) values ( 13,2,'Derailleurs','1830D70CAA2A40C0A2715BA86F38F8BF','2002-06-01 00:00:00' ); insert into ProductCategory ( ProductCategoryID, ParentProductCategoryID, Name, rowguid, ModifiedDate ) values ( 14,2,'Forks','B5F9BA42B69B4FDDB2EC57FB7B42E3CF','2002-06-01 00:00:00' ); insert into ProductCategory ( ProductCategoryID, ParentProductCategoryID, Name, rowguid, ModifiedDate ) values ( 15,2,'Headsets','7C782BBE5A16495AAA5010AFE5A84AF2','2002-06-01 00:00:00' ); insert into ProductCategory ( ProductCategoryID, ParentProductCategoryID, Name, rowguid, ModifiedDate ) values ( 16,2,'Mountain Frames','61B21B65E16A4BE793004D8E9DB861BE','2002-06-01 00:00:00' ); insert into ProductCategory ( ProductCategoryID, ParentProductCategoryID, Name, rowguid, ModifiedDate ) values ( 17,2,'Pedals','6D24AC077A844849864A865A14125BC9','2002-06-01 00:00:00' ); insert into ProductCategory ( ProductCategoryID, ParentProductCategoryID, Name, rowguid, ModifiedDate ) values ( 18,2,'Road Frames','5515F857075B4F9A87B743B4997077B3','2002-06-01 00:00:00' ); insert into ProductCategory ( ProductCategoryID, ParentProductCategoryID, Name, rowguid, ModifiedDate ) values ( 19,2,'Saddles','049FFFA39D3046DF82F7F20730EC02B3','2002-06-01 00:00:00' ); insert into ProductCategory ( ProductCategoryID, ParentProductCategoryID, Name, rowguid, ModifiedDate ) values ( 20,2,'Touring Frames','D2E3F1A856C44F36B29D5659FC0D2789','2002-06-01 00:00:00' ); insert into ProductCategory ( ProductCategoryID, ParentProductCategoryID, Name, rowguid, ModifiedDate ) values ( 21,2,'Wheels','435212874B0B438EB80ED82D9AD7C9F0','2002-06-01 00:00:00' ); insert into ProductCategory ( ProductCategoryID, ParentProductCategoryID, Name, rowguid, ModifiedDate ) values ( 22,3,'Bib-Shorts','67B58D2B57984A908C6C5DDACF057171','2002-06-01 00:00:00' ); insert into ProductCategory ( ProductCategoryID, ParentProductCategoryID, Name, rowguid, ModifiedDate ) values ( 23,3,'Caps','430DD6A8A7554B23BB0552520107DA5F','2002-06-01 00:00:00' ); insert into ProductCategory ( ProductCategoryID, ParentProductCategoryID, Name, rowguid, ModifiedDate ) values ( 24,3,'Gloves','92D5657B00324E49BAD541A441A70942','2002-06-01 00:00:00' ); insert into ProductCategory ( ProductCategoryID, ParentProductCategoryID, Name, rowguid, ModifiedDate ) values ( 25,3,'Jerseys','09E91437BA4F4B1A821574184FD95DB8','2002-06-01 00:00:00' ); insert into ProductCategory ( ProductCategoryID, ParentProductCategoryID, Name, rowguid, ModifiedDate ) values ( 26,3,'Shorts','1A5BA5B303C3457CB11E4FA85EDE87DA','2002-06-01 00:00:00' ); insert into ProductCategory ( ProductCategoryID, ParentProductCategoryID, Name, rowguid, ModifiedDate ) values ( 27,3,'Socks','701019C309FE49498386C6CE686474E5','2002-06-01 00:00:00' ); insert into ProductCategory ( ProductCategoryID, ParentProductCategoryID, Name, rowguid, ModifiedDate ) values ( 28,3,'Tights','5DEB3E5598974416B18A515E970BC2D1','2002-06-01 00:00:00' ); insert into ProductCategory ( ProductCategoryID, ParentProductCategoryID, Name, rowguid, ModifiedDate ) values ( 29,3,'Vests','9AD7FE935BA04736B578FF80A2071297','2002-06-01 00:00:00' ); insert into ProductCategory ( ProductCategoryID, ParentProductCategoryID, Name, rowguid, ModifiedDate ) values ( 30,4,'Bike Racks','4624B5CE66D6496B9201C053DF3556CC','2002-06-01 00:00:00' ); insert into ProductCategory ( ProductCategoryID, ParentProductCategoryID, Name, rowguid, ModifiedDate ) values ( 31,4,'Bike Stands','43B445C8B820424EA1D590D81DA0B46F','2002-06-01 00:00:00' ); insert into ProductCategory ( ProductCategoryID, ParentProductCategoryID, Name, rowguid, ModifiedDate ) values ( 32,4,'Bottles and Cages','9B7DFF419FA347768DEF2C9A48C8B779','2002-06-01 00:00:00' ); insert into ProductCategory ( ProductCategoryID, ParentProductCategoryID, Name, rowguid, ModifiedDate ) values ( 33,4,'Cleaners','9AD3BCF0244D4EC4A6A0FB701351C6A3','2002-06-01 00:00:00' ); insert into ProductCategory ( ProductCategoryID, ParentProductCategoryID, Name, rowguid, ModifiedDate ) values ( 34,4,'Fenders','1697F8A20A084883B7DDD19117B4E9A7','2002-06-01 00:00:00' ); insert into ProductCategory ( ProductCategoryID, ParentProductCategoryID, Name, rowguid, ModifiedDate ) values ( 35,4,'Helmets','F5E07A33C9E0439CB5F39F25FB65BECC','2002-06-01 00:00:00' ); insert into ProductCategory ( ProductCategoryID, ParentProductCategoryID, Name, rowguid, ModifiedDate ) values ( 36,4,'Hydration Packs','646A8906FC874267A4439C6D791E6693','2002-06-01 00:00:00' ); insert into ProductCategory ( ProductCategoryID, ParentProductCategoryID, Name, rowguid, ModifiedDate ) values ( 37,4,'Lights','954178BA624F42DB95F6CA035F36D130','2002-06-01 00:00:00' ); insert into ProductCategory ( ProductCategoryID, ParentProductCategoryID, Name, rowguid, ModifiedDate ) values ( 38,4,'Locks','196469833FA047739A0CF34C49DF9BC8','2002-06-01 00:00:00' ); insert into ProductCategory ( ProductCategoryID, ParentProductCategoryID, Name, rowguid, ModifiedDate ) values ( 39,4,'Panniers','3002A5D5FEC3464BBEF3E0F81D35F431','2002-06-01 00:00:00' ); insert into ProductCategory ( ProductCategoryID, ParentProductCategoryID, Name, rowguid, ModifiedDate ) values ( 40,4,'Pumps','FE4D46F2C87C48C5A4A13F55712D80B1','2002-06-01 00:00:00' ); insert into ProductCategory ( ProductCategoryID, ParentProductCategoryID, Name, rowguid, ModifiedDate ) values ( 41,4,'Tires and Tubes','3C17C9AEE90648B4BDD360E28D47DCDF','2002-06-01 00:00:00' );