dbo.QER_PRulerDetect_PX

1   create   procedure QER_PRulerDetect_PX ( @uid_PersonWantsOrg varchar(38) , @UID_QERWorkingStep varchar(38) ) as begin declare @WhereClauseMissnutzt
2 nvarchar(max) declare @ParameterName nvarchar(256) declare @XObjectKeyPWO varchar(138) = dbo.QBM_FCVElementToObjectKey1('PersonWantsOrg', '', @UID_PersonWantsOrg
3) declare @cmd nvarchar(max) SET XACT_ABORT OFF BEGIN TRY select top 1 @WhereClauseMissnutzt = s.WhereClause from QERWorkingStep s where s.UID_QERWorkingStep
4 = @UID_QERWorkingStep select top 1 @ParameterName = s.ParameterName from dbo.QBM_FCVStringToListSplitted(@WhereClauseMissnutzt, char(7), 1, 0, '') s where
5 s.OrderNumber = 1  select top 1 @cmd = concat('select ''', ParameterValue, ''' as UID_Person     -- der Entscheider
6							, null as UID_PWORulerOrigin'
7 ) from DialogParameterSet s join DialogParameter pa on s.UID_DialogParameterSet = pa.UID_DialogParameterSet where s.ObjectKeyUsedBy = @XObjectKeyPWO and
8 pa.ParameterName = @ParameterName  insert into #Ruler(UID_Person, UID_PWORulerOrigin) exec sp_executesql @cmd END TRY BEGIN CATCH exec QBM_PSessionErrorAdd
9 default ,@cmd RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: end 
10