Bonitet kod fiscalPOS, PK, Index

declare @nesto char (15)

declare xPoz cursor local fast_forward for

    SELECT acKey

    from _LogClient

    group by acKey

    having count(*) > 1

open xPoz

fetch from xPoz into @nesto

while @@fetch_status = 0

begin

    delete top (1) from _LogClient where acKey = @nesto 

fetch from xPoz into @nesto

end

close xPoz

deallocate xPoz

go

CREATE UNIQUE NONCLUSTERED INDEX [acKey] ON [dbo].[_LogClient]

(

    [acKey] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

go

ALTER TABLE [dbo].[_LogClient] ADD  CONSTRAINT [PK_acKeyClient] PRIMARY KEY CLUSTERED 

(

    [acKey] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

go