spAddUpdate_ECardPartTemplates

                CREATE procedure [dbo].[spAddUpdate_ECardPartTemplates]
                (
                    @ECardPartID int,
                    @TemplatesXml ntext
                )
                as
                    set nocount on;
                    declare @doc int;

                    begin transaction spAddUpdate_ECardPartTemplate;

                    exec sp_xml_preparedocument @doc output, @TemplatesXml;

                    delete from dbo.ECardPartTemplate where ECardPartID = @ECardPartID;

                    -- The ones with no category
                    insert into dbo.ECardPartTemplate(ECardPartID, ECardTemplateID)
                        select @ECardPartID, ECardTemplateID
                        from openxml (@doc, 'root/t',1)
                        with (ECardTemplateID int, SiteFoldersID int)
                        where SiteFoldersID < 0;

                    -- The ones with a category
                    insert into dbo.ECardPartTemplate(ECardPartID, ECardTemplateID, SiteFoldersID)
                        select @ECardPartID, ECardTemplateID, SiteFoldersID
                        from openxml (@doc, 'root/t',1)
                        with (ECardTemplateID int, SiteFoldersID int)
                        where SiteFoldersID >= 0;

                    exec sp_xml_removedocument @doc;

                    commit transaction spAddUpdate_ECardPartTemplate;