TRUNCATE table [dbo].[pal_BusinessType]

SET IDENTITY_INSERT [dbo].[pal_BusinessType] ON 

INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (1, N'AC & Heating', 1, 1)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (2, N'Accounting Services', 1, 2)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (3, N'Architect', 1, 3)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (4, N'Attorney', 1, 4)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (5, N'Auctioneer', 1, 5)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (6, N'Auditing', 1, 6)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (7, N'Bakery', 1, 7)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (8, N'Beauty Salon', 1, 8)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (9, N'Body Guard Services', 1, 9)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (10, N'Bookkeeping', 1, 10)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (11, N'Building Construction', 1, 11)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (12, N'Building Inspection', 1, 12)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (13, N'Car Wash', 1, 13)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (14, N'Carpentry', 1, 14)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (15, N'Catering', 1, 15)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (16, N'Construction', 1, 16)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (17, N'Consultant', 1, 17)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (18, N'Contractor', 1, 18)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (19, N'Day Care', 1, 19)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (20, N'Diet Center', 1, 20)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (21, N'Distribution', 1, 21)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (22, N'Dry cleaning/Laundry', 1, 22)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (23, N'Electrician', 1, 23)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (24, N'Engineering/Drafting', 1, 24)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (25, N'Entertainment/Party Rentals', 1, 25)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (26, N'Environmental Health', 1, 26)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (27, N'Event Planning', 1, 27)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (28, N'Extermination/Pest Control', 1, 28)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (29, N'Fitness Center', 1, 29)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (30, N'Florist', 1, 30)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (31, N'Guest House', 1, 31)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (32, N'Hair Dressor ', 1, 32)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (33, N'Handy Man', 1, 33)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (34, N'Home Inspection', 1, 34)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (35, N'Hotels/Motels', 1, 35)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (36, N'Interior Design', 1, 36)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (37, N'Janitorial/Cleaning Services', 1, 37)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (38, N'Land Surveying', 1, 38)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (39, N'Landscape Services', 1, 39)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (40, N'Lawn care Services', 1, 40)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (41, N'Limousine Services', 1, 41)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (42, N'Locksmith', 1, 42)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (43, N'Manufacturing', 1, 43)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (44, N'Marketing/Advertising', 1, 44)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (45, N'Massage/Day Spa', 1, 45)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (46, N'Motor Vehicle Rental', 1, 46)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (47, N'Motor Vehicle Repair', 1, 47)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (48, N'Motor Vehicle Sales', 1, 48)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (49, N'Nail Salon', 1, 49)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (50, N'Painting', 1, 50)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (51, N'Part Sales', 1, 51)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (52, N'Photography', 1, 52)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (53, N'Plumbing', 1, 53)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (54, N'Private Investigator', 1, 54)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (55, N'Property Management', 1, 55)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (56, N'Publishing Services', 1, 56)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (57, N'Real Estate Broker/Agent', 1, 57)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (58, N'Rental Business (Rental off any product / asset)', 1, 58)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (59, N'Repair/Maintenance', 1, 59)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (60, N'School', 1, 60)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (61, N'Sports Club (Membership)', 1, 61)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (62, N'Tanning Salon', 1, 62)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (63, N'Tax Preparation', 1, 63)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (64, N'Taxi Services', 1, 64)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (65, N'Technology Services', 1, 65)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (66, N'Towing', 1, 66)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (67, N'Travel Agency', 1, 67)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (68, N'Veterinary', 1, 68)
INSERT [dbo].[pal_BusinessType] ([recId], [businessType], [isActive], [sequence]) VALUES (69, N'Warehouse/Storage', 1, 69)
SET IDENTITY_INSERT [dbo].[pal_BusinessType] OFF
