DROP TABLE #Delete_keys

USE SUSDB

CREATE TABLE #Delete_Keys(guid varchar(255))

DECLARE	@loop as int, @guid as uniqueidentifier

SET @loop = 0

INSERT INTO #Delete_keys (guid)
SELECT UpdateID
FROM PUBLIC_VIEWS.vUpdate
WHERE IsDeclined = 'True';

WHILE @loop = 0
BEGIN
		SELECT TOP(1) @guid = guid FROM #Delete_keys
	IF @guid IS NULL
		SET @loop = 1
	ELSE
		EXEC spDeleteUpdateByUpdateID @guid
		DELETE FROM #Delete_keys WHERE guid = @guid
END

DROP TABLE #Delete_keys