spUpdateImageAlbum

        CREATE PROCEDURE dbo.spUpdateImageAlbum
    (
    @SiteImageID int,
    @ImageAlbumID int
    )
    AS

    Declare @ID int

    SELECT @ID = ID FROM ImageAlbum_Images WHERE SiteImageID = @SiteImageID

    if @ID > 0 
    begin
        UPDATE ImageAlbum_Images SET ImageAlbumID = @ImageAlbumID, Sequence = 0 WHERE ID = @ID
    end
    else
    begin
        INSERT INTO ImageAlbum_Images (ImageAlbumID, SiteImageID, Sequence) VALUES (@ImageAlbumID, @SiteImageID, 0)
    end