游标

DECLARE @itemCur CURSOR,@selectEmpIDs varchar(100)

     SET @itemCur=CURSOR FOR

         --获取分发人员

         SELECT EI.UserID FROM tbStepOperateRelation SOR LEFT JOIN vi_EmployeeBaseInfo EI ON SOR.OwnerID=EI.UserID

              WHERE SOR.StepInstanceID=@stepInstID

     OPEN @itemCur

     FETCH NEXT FROM  @itemCur INTO @selectEmpIDs

     WHILE @@fetch_status=0

     BEGIN

         SET @selectEmpIDs=@selectEmpIDs+','

         FETCH NEXT FROM  @itemCur INTO @selectEmpIDs

     END

     CLOSE @itemCur

     DEALLOCATE  @itemCur