dbo.QER_PQERRiskIndexDefine

1  create   procedure QER_PQERRiskIndexDefine( @TableName varchar(30) , @ColumnName varchar(30) , @TypeOfCalculation varchar(3) , @Weight float ,
2 @QueryString nvarchar(max) , @DisplayValue nvarchar(64) , @Description nvarchar(max) , @IsInActive bit = 0 , @UID_QERRiskIndex varchar(38) = null ) as
3 begin declare @UID_DialogColumn varchar(38) declare @IsInsert bit = 0 declare @Xdate datetime = getutcdate() declare @XUser nvarchar(64) = object_name
4(@@procid) declare @Msg nvarchar(1000) SET XACT_ABORT OFF BEGIN TRY select top 1 @UID_DialogColumn = c.UID_DialogColumn from DialogTable t with (readpast
5) join DialogColumn c with (readpast) on t.UID_DialogTable = c.UID_DialogTable where c.ColumnName = @ColumnName and t.TableName = @TableName if @UID_DialogColumn
6 is null begin select @Msg = '#LDS#Column {0} not found in table {1}.|' + @ColumnName + '|' + @TableName + '|' raiserror(@msg, 18, 1 ) with nowait end 
7if @UID_QERRiskIndex is null begin select top 1 @UID_QERRiskIndex from QERRiskIndex r where r.UID_DialogColumn = @UID_DialogColumn and r.DisplayValue =
8 @DisplayValue and r.TypeOfCalculation = @TypeOfCalculation end if @UID_QERRiskIndex is null begin select @UID_QERRiskIndex = dbo.QBM_FCVGuidToTransfer
9(newid(), dbo.QBM_FGIDBOwner() ) end if not exists (select top 1 1 from QERRiskIndex r where r.UID_QERRiskIndex = @UID_QERRiskIndex ) begin select @IsInsert
10 = 1 end if @IsInsert = 1 begin insert into QERRiskIndex(Description, DisplayValue, IsInActive, QueryString , TypeOfCalculation, UID_DialogColumn, UID_QERRiskIndex
11, Weight , XDateInserted, XDateUpdated, XUserInserted, XUserUpdated , XObjectKey ) select @Description, @DisplayValue, @IsInActive, @QueryString , @TypeOfCalculation
12, @UID_DialogColumn, @UID_QERRiskIndex, @Weight , @XDate, @Xdate, @XUser, @XUser , dbo.QBM_FCVElementToObjectKey1('QERRiskIndex', 'UID_QERRiskIndex', @UID_QERRiskIndex
13) end else begin update QERRiskIndex set Description = @Description  , IsInActive = @IsInActive , QueryString = @QueryString  , Weight = @Weight , XDateUpdated
14 = @Xdate , XUserUpdated = @XUser where UID_QERRiskIndex = @UID_QERRiskIndex end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow
15 varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH ende: return end 
16