spAddUpdate_ConditionBlockConditionMergeHTML

            Create PROCEDURE [dbo].[spAddUpdate_ConditionBlockConditionMergeHTML]
            (
                @ConditionBlockConditionID int output,
                @HTML ntext
            )
            AS
            BEGIN

                    DECLARE @numRecords int

                    SELECT @numRecords = COUNT(1)
                    FROM ConditionBlockConditionMergeHTML
                    WHERE ConditionBlockConditionID = @ConditionBlockConditionID

                    IF (@numRecords<=0) 
                    BEGIN
                        INSERT INTO [ConditionBlockConditionMergeHTML]
                        (
                        [ConditionBlockConditionID],
                        [MergeFieldHTML]
                        )
                        VALUES
                        (
                        @ConditionBlockConditionID,
                        @HTML
                        )
                    END
                    ELSE 

                        UPDATE [ConditionBlockConditionMergeHTML] SET
                        [MergeFieldHTML] = @HTML
                        WHERE [ConditionBlockConditionID]=@ConditionBlockConditionID    

            END