BEGIN BEGIN TRANSACTION DECLARE @Psh_Id INT, -- Push / Pull ID @atr_id VARCHAR(255), -- Attribute ID of the Attribute @atrtype_name VARCHAR(255), -- Name of the Attribute Type @action_flg CHAR(1), @rtn_value INT SET @action_flg = 'I' DECLARE c1temp CURSOR LOCAL FOR SELECT psh_id, atr_id, atrtype_name FROM InfAtr_Attribute WHERE Psh_Id = 1 and AtrType_Name = 'ClientCode' OPEN c1temp FETCH c1temp INTO @psh_id, @atr_id, @atrtype_name WHILE @@FETCH_STATUS = 0 BEGIN exec @rtn_value = oit_sp_update_attribute_matrix @psh_id, @atr_id, @atrtype_name, @action_flg FETCH c1temp INTO @psh_id, @atr_id, @atrtype_name END CLOSE c1temp DEALLOCATE c1temp END