Hello group

I am trying to update a table with fresh data. with the following syntax

DELETE FROM studemo WHERE suniq in (SELECT suniq FROM cisstudemo)

INSERT INTO studemo
SELECT * FROM cisstudemo

I get the following message.


Server: Msg 2601, Level 14, State 3, Line 3
Cannot insert duplicate key row in object 'studemo' with unique index 'studemU1'.
The statement has been terminated.
What can I do to find unique index studemU1 or work around this?
Thanks
Jim

The table definitions

are

CREATE TABLE [dbo].[studemo] (
[suniq] [int] NOT NULL ,
[ident] [varchar] (10) NOT NULL ,
[stuuniq] [int] NOT NULL ,
[firstname] [varchar] (16) NOT NULL ,
[middlename] [varchar] (16) NULL ,
[lastname] [varchar] (20) NOT NULL ,
[namesfx] [varchar] (4) NULL ,
[nickname] [varchar] (16) NULL ,
[genderc] [varchar] (1) NOT NULL ,
[ethnicc] [varchar] (1) NOT NULL ,
[birthdate] [smalldatetime] NOT NULL ,
[birthplace] [varchar] (32) NULL ,
[regdate] [smalldatetime] NULL ,
[ssn] [char] (9) NULL ,
[gradyear] [decimal](4, 0) NULL ,
[homelangc] [varchar] (2) NULL ,
[primlangc] [varchar] (2) NULL ,
[homeaddr1] [varchar] (32) NULL ,
[homeaddr2] [varchar] (32) NULL ,
[homecity] [varchar] (24) NULL ,
[homestate] [varchar] (4) NULL ,
[homezip] [char] (9) NULL ,
[mailaddr1] [varchar] (32) NULL ,
[mailaddr2] [varchar] (32) NULL ,
[mailcity] [varchar] (24) NULL ,
[mailstate] [varchar] (4) NULL ,
[mailzip] [char] (9) NULL ,
[emailaddr] [varchar] (32) NULL ,
[url] [varchar] (64) NULL ,
[phnnumber] [char] (10) NULL ,
[phntypec] [varchar] (1) NULL ,
[phnunlist] [decimal](1, 0) NULL ,
[phnmsg] [decimal](1, 0) NULL ,
[bverbasc] [varchar] (2) NULL ,
[bverdocnum] [varchar] (32) NULL ,
[citizenc] [varchar] (2) NULL ,
[countryc] [varchar] (2) NULL ,
[geocode] [varchar] (10) NULL ,
[resschoolc] [varchar] (5) NULL ,
[resdistc] [varchar] (10) NULL ,
[chcschoolc] [varchar] (5) NULL ,
[gradreqc] [varchar] (10) NULL ,
[careeruniq] [int] NULL ,
[hlduniq] [int] NULL ,
[buspuniq] [int] NULL ,
[busduniq] [int] NULL ,
[maritalc] [varchar] (1) NULL ,
[migrantnum] [varchar] (16) NULL ,
[legalbind] [varchar] (254) NULL ,
[passwd] [varchar] (10) NULL ,
[retainflag] [decimal](1, 0) NULL ,
[norank] [decimal](1, 0) NULL ,
[inforelc] [varchar] (2) NULL ,
[counsfuniq] [int] NULL ,
[memberc] [varchar] (10) NULL ,
[chgby] [varchar] (5) NULL ,
[chgdt] [datetime] NULL ,
[stunotes] [text] NULL ,
[stateid] [varchar] (20) NULL ,
[addrverif] [smalldatetime] NULL
)


CREATE TABLE [dbo].[cisStudemo] (
[suniq] [int] NOT NULL ,
[ident] [varchar] (10) NOT NULL ,
[stuuniq] [int] NOT NULL ,
[firstname] [varchar] (16) NOT NULL ,
[middlename] [varchar] (16) NULL ,
[lastname] [varchar] (20) NOT NULL ,
[namesfx] [varchar] (4) NULL ,
[nickname] [varchar] (16) NULL ,
[genderc] [varchar] (1) NOT NULL ,
[ethnicc] [varchar] (1) NOT NULL ,
[birthdate] [smalldatetime] NOT NULL ,
[birthplace] [varchar] (32) NULL ,
[regdate] [smalldatetime] NULL ,
[ssn] [char] (9) NULL ,
[gradyear] [decimal](4, 0) NULL ,
[homelangc] [varchar] (2) NULL ,
[primlangc] [varchar] (2) NULL ,
[homeaddr1] [varchar] (32) NULL ,
[homeaddr2] [varchar] (32) NULL ,
[homecity] [varchar] (24) NULL ,
[homestate] [varchar] (4) NULL ,
[homezip] [char] (9) NULL ,
[mailaddr1] [varchar] (32) NULL ,
[mailaddr2] [varchar] (32) NULL ,
[mailcity] [varchar] (24) NULL ,
[mailstate] [varchar] (4) NULL ,
[mailzip] [char] (9) NULL ,
[emailaddr] [varchar] (32) NULL ,
[url] [varchar] (64) NULL ,
[phnnumber] [char] (10) NULL ,
[phntypec] [varchar] (1) NULL ,
[phnunlist] [decimal](1, 0) NULL ,
[phnmsg] [decimal](1, 0) NULL ,
[bverbasc] [varchar] (2) NULL ,
[bverdocnum] [varchar] (32) NULL ,
[citizenc] [varchar] (2) NULL ,
[countryc] [varchar] (2) NULL ,
[geocode] [varchar] (10) NULL ,
[resschoolc] [varchar] (5) NULL ,
[resdistc] [varchar] (10) NULL ,
[chcschoolc] [varchar] (5) NULL ,
[gradreqc] [varchar] (10) NULL ,
[careeruniq] [int] NULL ,
[hlduniq] [int] NULL ,
[buspuniq] [int] NULL ,
[busduniq] [int] NULL ,
[maritalc] [varchar] (1) NULL ,
[migrantnum] [varchar] (16) NULL ,
[legalbind] [varchar] (254) NULL ,
[passwd] [varchar] (10) NULL ,
[retainflag] [decimal](1, 0) NULL ,
[norank] [decimal](1, 0) NULL ,
[inforelc] [varchar] (2) NULL ,
[counsfuniq] [int] NULL ,
[memberc] [varchar] (10) NULL ,
[chgby] [varchar] (5) NULL ,
[chgdt] [datetime] NULL ,
[stunotes] [text] NULL ,
[stateid] [varchar] (20) NULL ,
[addreverif] [smalldatetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]