count distinct 组合,UPDATE TOP 组合,Sql server 游标使用

--后台操作人员共维护多少会员
Select  @UserBackTotal = count(distinct memberID) from MarketMember where  AssignState = 0
count(distinct

UPDATE lead_master SET Assigned_User='m' WHERE leadmasterid IN (SELECT TOP 5 leadmasterid FROM lead_master WHERE Call_Status='b')


open my_cursor
declare @pname sysname
fetch next from my_cursor into @pname
while(@@fetch_status=0)
  begin
    --Select  @pname as [USerID]
        EXEC [dbo].[p_MarketMemberUpdateByNum]
        @pname,
        @ActionNum,
        @AssignNumMax,
        @AssignNumMin
    fetch next from my_cursor into @pname
  end
close my_cursor
deallocate my_cursor