DDL:

USE [PalladiumShare]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[WI_Projects](

[ProjectID] [bigint] IDENTITY(11111,1) NOT NULL,

[ProjectCode] [nvarchar](50) NULL,

[ProjectLocation] [nvarchar](255) NULL,

[ProjectType] [nvarchar](200) NULL,

[ProjectName] [nvarchar](200) NULL,

[ProjectDescription] [nvarchar](max) NULL,

[ProjectStartDate] [datetime] NULL,

[ProjectEndDate] [datetime] NULL,

[ProjectTotalHours] [float] NULL,

[ProjectStatusID] [bigint]...