spAdd_EmailJobConditionBlockConditions

            CREATE PROCEDURE [dbo].[spAdd_EmailJobConditionBlockConditions]
            (
                @ConditionBlockConditions XML,
                @EmailJobID int
            )
            AS
            BEGIN
                INSERT INTO [dbo].[EmailJobConditionBlockCondition]
                    ([ConditionBlockConditionID], [EmailJobID])
                SELECT cbc.[ID], @EmailJobID
                    FROM [dbo].[ConditionBlockCondition] cbc
                INNER JOIN @ConditionBlockConditions.nodes('/ConditionBlockConditions/ConditionBlockCondition') cbcNodes(cbc)
                    ON cbc.[ConditionBlockID] = cbcNodes.cbc.value('@ConditionBlockID', 'int')
                    AND cbc.[Priority] = cbcNodes.cbc.value('@Priority', 'int')
            END