spAddUpdate_SiteImageFolders

            CREATE PROCEDURE [dbo].[spAddUpdate_SiteImageFolders]
                (
                @ImageID        int,
                @Categories        ntext
                )
            AS
            BEGIN
                DECLARE @Doc            int

                BEGIN TRANSACTION

                EXEC sp_xml_preparedocument @Doc OUTPUT, @Categories

                -- update categories in SiteImageFolders table
                DELETE FROM SiteImageFolders
                WHERE SiteImageID = @ImageID

                INSERT INTO dbo.SiteImageFolders(SiteImageID, SiteFolderID)
                SELECT @ImageID, SiteFolderID 
                FROM OPENXML(@Doc, 'Image/ImageCategory', 1)
                WITH (SiteImageID integer, SiteFolderID integer)
                WHERE SiteFolderID > 0

                EXEC sp_xml_removedocument @Doc

                COMMIT TRANSACTION
            END