USE [lin2world] 
GO
-- =============================================
-- Author:		Vanganth
-- Create date: 
-- Description:	Procedure for Running Delegate clan master procedure for each pledge
-- =============================================
CREATE PROCEDURE lin_RunDelegateClanMaster
AS

SET NOCOUNT ON;
DECLARE
@pledge_id INT
DECLARE CUR1 CURSOR FOR
SELECT [pledge_id] from lin2world.dbo.Pledge where [delegate_clid] > 0
OPEN CUR1
FETCH NEXT FROM CUR1
INTO @pledge_id
WHILE (@@FETCH_STATUS <> -1)
BEGIN
exec lin2world.dbo.[lin_DelegateClanMaster] @pledge_id
FETCH NEXT FROM CUR1
INTO @pledge_id
END
CLOSE CUR1
DEALLOCATE CUR1
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO