set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
 
ALTER PROCEDURE [dbo].[alz_Gallery_Views_Update]
AS
BEGIN
 
DECLARE	@UserId uniqueidentifier
SET @UserId = NULL
DECLARE @ViewerID uniqueidentifier
SET @ViewerID = NULL
 
DECLARE @Counter int
Set @Counter = 0
 
-- Fix the current count problem caused by aspx page, sqlDataSource inadvertently posting twice
UPDATE tblPics SET views = (views+2)/2 WHERE PrimaryPic = 1 
 
-- backup the values in case something goes horribly wrong
SELECT UserID, Views
INTO dbo.Table_1
FROM tblPics
Where tblPics.PrimaryPic = 1 AND tblPics.UserID is not null
 
 
-- declare @userid uniqueidentifier
DECLARE tempcursor CURSOR
FOR SELECT UserID from tblPics where PrimaryPic = 1
OPEN tempcursor
FETCH NEXT FROM tempcursor into @UserID
 
WHILE @@FETCH_STATUS = 0
	BEGIN
		WHILE (SELECT views from tblPics where PrimaryPic = 1 AND UserID = @UserID) > 0
		BEGIN
			  Update tblPics set views = views - 1 where PrimaryPic = 1 AND UserID = @UserID
			  Insert INTO tblGallery_Views (GalleryOwnerID, ViewerID) values(@UserID, NULL)
			  SET @Counter = @Counter + 1
			  IF (SELECT views from tblPics where PrimaryPic = 1 AND UserID = @UserID) < 1
					BREAK
			  ELSE
					CONTINUE
		END
 
		SET @Counter = 0
 
	FETCH NEXT FROM tempcursor INTO @UserID
 
END
 
CLOSE tempcursor
DEALLOCATE tempcursor
 
END