fnGetEmailConditionBlockConditions

            CREATE FUNCTION [dbo].[fnGetEmailConditionBlockConditions] 
            (
                @EmailID int
            )
            RETURNS 
            @Conditions TABLE 
            (
                [ID] int,
                [HTML] ntext
            )
            AS
            BEGIN
                INSERT INTO @Conditions
                SELECT
                    cbc.[ID],
                    c.[HTML]
                FROM
                    [dbo].[EmailConditionBlock] ecb
                JOIN [dbo].[ConditionBlockCondition] cbc
                    ON cbc.[ConditionBlockID] = ecb.[ConditionBlockID]
                JOIN [dbo].[Condition] c
                    ON cbc.[ConditionID] = c.[ID]
                WHERE ecb.[EmailID] = @EmailID

                RETURN 
            END