不能在具有唯一索引“UFIDA_U9_CBO_Pub_Controller_AttributeController_BusinessKey_Index”的对象

BEGIN TRAN

 

IF OBJECT_ID(N'tempdb..#Tmp') IS NOT NULL DROP TABLE #Tmp

--select ID from Base_Organization

 

create table #Tmp(Attribute bigint,[Name] nvarchar(500),FullName nvarchar(500),BaseObject varchar(100),U_ID nvarchar(500),Org bigint)

Truncate table #Tmp 

 

declare @Org bigint

Select @Org=ID from Base_Organization where Code='mfg'

 

insert into #Tmp(Attribute,[Name],FullName,BaseObject,U_ID,Org)

select 

distinct A.Attribute ,C.Name,D.FullName,A.BaseObject,A.U_ID,@Org as Org

from CBO_ObjectAttribute A

inner join CBO_BaseObject B on A.BaseObject=B.ID

inner join UBF_MD_Attribute C on A.Attribute=C.Local_ID

inner join UBF_MD_Class D on C