error:
Violation of UNIQUE KEY constraint 'UQ__Resource__3552E9B6'. Cannot insert duplicate key in object 'dbo.Resource'.
The statement has been terminated.
USE [Resource Management]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Resource](
[OrganisationID] [int] NOT NULL,
[ID] [int] IDENTITY(1,1) NOT NULL,
[FirstName] [nvarchar](50) NOT NULL,
[LastName] [nvarchar](50) NULL,
[MiddleName] [nvarchar](50) NULL,
[Password] [nvarchar](50) NULL,
[PrimarySkill] [nvarchar](50) NULL,
[SecondarySkill] [nvarchar](50) NULL,
[Role] [nvarchar](50) NULL,
[JobTitle] [nvarchar](50) NULL,
[PrimaryEmail] [nvarchar](50) NOT NULL,
[ClientEmail] [nvarchar](50) NULL,
[Address] [nvarchar](max) NULL,
[JobType] [nvarchar](50) NULL,
[VisaStatus] [nvarchar](50) NULL,
[PersonalEmail] [nvarchar](50) NOT NULL,
[PrimaryPhone] [varchar](50) NULL,
[SecondaryPhone] [varchar](50) NULL,
[ResourceManager] [nvarchar](50) NULL,
[Customer] [nvarchar](50) NULL,
[StartDate] [datetime] NULL,
[TaxTerms] [nvarchar](50) NOT NULL,
[Reference1] [nvarchar](50) NULL,
[Reference2] [nvarchar](50) NULL,
[C2CEmployerName] [nvarchar](50) NULL,
[C2CEmployerAddress] [nvarchar](50) NULL,
[C2CEmployerTaxID] [nvarchar](50) NULL,
[C2CPhone] [varchar](50) NULL,
[C2CModeOfPayment] [nvarchar](50) NULL,
[C2CFaxNo] [nvarchar](50) NULL,
[C2CBankDetails] [nvarchar](50) NULL,
[BillRate] [varchar](50) NULL,
[PayRate] [varchar](50) NULL,
[WorkType] [nvarchar](50) NULL,
[EndDate] [datetime] NULL,
[SSN] [nvarchar](50) NULL,
[ModeOfPayment] [nvarchar](50) NULL,
[BankDetails] [nvarchar](50) NULL,
[W2ContractorPerDiem] [nvarchar](50) NULL,
[W2Amount] [nvarchar](50) NULL,
[Status] [int] NULL CONSTRAINT [DF_Resource_Status] DEFAULT ((1)),
CONSTRAINT [PK_Resource] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
CONSTRAINT [UQ__Resource__3552E9B6] UNIQUE NONCLUSTERED
(
[ClientEmail] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[Resource] WITH CHECK ADD CONSTRAINT [FK__Resource__Organi__24285DB4] FOREIGN KEY([OrganisationID])
REFERENCES [dbo].[Organisation] ([OrganisationID])
GO
ALTER TABLE [dbo].[Resource] CHECK CONSTRAINT [FK__Resource__Organi__24285DB4]