CREATE TABLE [dbo].[CKJLEMPID]( [PayrollGroup] [VARCHAR](20) NOT NULL, [Year] [VARCHAR](50) NOT NULL, [LastID] [VARCHAR](18) NOT NULL, [CreateBy] [VARCHAR](50) NULL, [CreateDate] [VARCHAR](18) NULL, [ChangeDate] [VARCHAR](18) NULL, [ChangeBy] [VARCHAR](50) NULL, CONSTRAINT [PK_CKJLEMPID] PRIMARY KEY CLUSTERED ( [PayrollGroup] ASC, [Year] 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