
Declare @StatCount as int
SET @StatCount = (select count(*) FROM [pal_CalendarStatus])

IF @StatCount = 0
BEGIN
SET IDENTITY_INSERT [dbo].[pal_CalendarStatus] ON 

INSERT [dbo].[pal_CalendarStatus] ([recId], [status], [icon], [isActive]) VALUES (1, N'Scheduled', N'fa fa-calendar', 1)

INSERT [dbo].[pal_CalendarStatus] ([recId], [status], [icon], [isActive]) VALUES (2, N'Late', N'fa fa-clock-o', 1)

INSERT [dbo].[pal_CalendarStatus] ([recId], [status], [icon], [isActive]) VALUES (3, N'Attending', N'fa fa-smile-o', 1)

INSERT [dbo].[pal_CalendarStatus] ([recId], [status], [icon], [isActive]) VALUES (4, N'Done', N'fa fa-check-square-o', 1)

INSERT [dbo].[pal_CalendarStatus] ([recId], [status], [icon], [isActive]) VALUES (5, N'Cancelled', N'fa fa-times', 1)

INSERT [dbo].[pal_CalendarStatus] ([recId], [status], [icon], [isActive]) VALUES (6, N'Rescheduled', N'fa fa-repeat', 1)

INSERT [dbo].[pal_CalendarStatus] ([recId], [status], [icon], [isActive]) VALUES (7, N'Missed', N'fa fa-exclamation', 1)

--INSERT [dbo].[pal_CalendarStatus] ([recId], [status], [icon], [isActive]) VALUES (8, N'Billed', N'fa fa-money', 1)

SET IDENTITY_INSERT [dbo].[pal_CalendarStatus] OFF

END