IF	(SELECT	COUNT(1)
	FROM	dbo.pal_Template
	WHERE	templateName = 'SBF Prep Report')=0
BEGIN
	INSERT INTO dbo.pal_Template (   templateTypeId ,
	                                 templateName ,
	                                 templateContent
	                             )
	VALUES (   1 ,  -- templateTypeId - int
	           'SBF Prep Report' , -- templateName - varchar(250)
	           N'<table style="width: 100%; height: 150px;">
    <tbody>
        <tr>
            <td style="width: 30%; text-align: center; vertical-align: middle;">&nbsp;<img alt="" src="{companyImage}" style="font-family: ''MS Sans Serif''; font-size: 12px; width: 150px; height: 150px;" /></td>
            <td style="width: 40%; text-align: center; vertical-align: bottom;">&nbsp;<span style="font-weight: 700; font-size: 20px; font-family: ''MS Sans Serif''; color: #c00000;"><br />
            <img alt="" src="{companySlogan}" style="text-align: center; font-family: ''MS Sans Serif''; font-size: 12px; width: 453px; height: 45px; left: 179px;" /><br />
            <br />
            <br />
            SBF - Preparatory Programme Report</span></td>
            <td>&nbsp;</td>
        </tr>
    </tbody>
</table>
<br />
<table style="width: 100%;">
    <tbody>
        <tr>
            <td style="width: 25%; padding: 10px;">
            <p>&nbsp;Scholar Name:</p>
            </td>
            <td style="width: 25%; padding: 10px;">
            <p><strong>{data.scholarName}</strong></p>
            </td>
            <td style="width: 25%; padding: 10px;">
            <p>&nbsp;Attendance:</p>
            </td>
            <td style="width: 25%; padding: 10px;">
            <p><strong>{data.attendance} %</strong></p>
            </td>
        </tr>
        <tr>
            <td style="width: 25%; padding: 10px;">
            <p>&nbsp;Maths Teachers:</p>
            </td>
            <td style="width: 25%; padding: 10px;">
            <p><strong>{data.mathsTeachers}</strong></p>
            </td>
            <td style="width: 25%; padding: 10px;">
            <p>&nbsp;English</p>
            </td>
            <td style="width: 25%; padding: 10px;">
            <p><strong>{data.englishTeachers}</strong></p>
            </td>
        </tr>
    </tbody>
</table>
<p>&nbsp;</p>
<table style="width: 100%; height: 500px; padding: 10px; margin: 10px;" cellpadding="10">
    <tbody>
        <tr>
            <td colspan="2" style="border-style: solid solid none; border-width: 5px; border-color: #c00000;"></td>
        </tr>
        <tr>
            <td style="width: 30%; border-style: none none none solid; border-width: 5px; border-color: #c00000;">
            <p style="padding: 10px;">&nbsp;Maths Comments:</p>
            </td>
            <td style="width: 70%; border-style: none solid none none; border-width: 5px; border-color: #c00000;">
            <p style="padding: 10px;">&nbsp;{data.mathsComment}</p>
            </td>
        </tr>
        <tr>
            <td colspan="2" style="border-style: none solid; border-width: 5px; border-color: #c00000;"></td>
        </tr>
        <tr>
            <td style="width: 30%; border-style: none none none solid; border-width: 5px; border-color: #c00000;">
            <p style="padding: 10px;">&nbsp;English Comments:</p>
            </td>
            <td style="width: 70%; border-style: none solid none none; border-width: 5px; border-color: #c00000;">
            <p style="padding: 10px;">&nbsp;{data.englishComment}</p>
            </td>
        </tr>
        <tr>
            <td colspan="2" style="border-style: none solid solid; border-width: 5px; border-color: #c00000;"></td>
        </tr>
    </tbody>
</table>
<p>&nbsp;</p>
<br />
<table style="width: 100%;">
    <tbody>
        <tr>
            <td style="width: 50%; text-align: center; vertical-align: middle; padding: 10px;">
            <p>&nbsp;Juliet Glover</p>
            </td>
            <td style="width: 50%; text-align: center; vertical-align: middle; padding: 10px;">
            <p>Lucille Dunne</p>
            </td>
        </tr>
        <tr>
            <td style="width: 50%; text-align: center; vertical-align: middle; padding: 10px;">
            <p>Head of Foundation</p>
            </td>
            <td style="width: 50%; text-align: center; vertical-align: middle; padding: 10px;">
            <p>Head Teacher</p>
            </td>
        </tr>
    </tbody>
</table>
<p>&nbsp;</p>'  -- templateContent - ntext
	       )
END

