spDelete_ImageAlbum

        CREATE PROCEDURE dbo.spDelete_ImageAlbum
    (
    @PKID int,
    @CurrentUserID int
    )
    AS

    BEGIN TRAN

    DELETE FROM SiteImages WHERE ID IN (SELECT SiteImageID FROM ImageAlbum_Images WHERE ImageAlbumID = @PKID)

    DELETE FROM ImageAlbum WHERE ID = @PKID

    COMMIT TRAN