gistfile1.sql

update Template set Body='<?xml version="1.0" ?><xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0"><xsl:output method="text" indent="no"/><xsl:template match="/data"><![CDATA[<p>Dear ]]><xsl:choose><xsl:when test="account/name"><xsl:value-of select="account/name" /></xsl:when><xsl:otherwise>Valued Customer</xsl:otherwise></xsl:choose><![CDATA[,</p> <p>We have not heard from you for a while. We wanted to check in and make sure that you are still having a great experience using our product(s). We have asked ]]><xsl:choose><xsl:when test="account/ownerid/@name"><xsl:value-of select="account/ownerid/@name" /></xsl:when><xsl:otherwise>a customer service representative</xsl:otherwise></xsl:choose><![CDATA[ to contact you next week to get your feedback on the product(s) you are currently using and to give you details about our upcoming products.</p><p>?]]><xsl:choose><xsl:when test="account/accountid"><xsl:value-of select="account/accountid" /></xsl:when><xsl:otherwise></xsl:otherwise></xsl:choose><![CDATA[?</p><p>&#160;</p> <p>Thank you.</p>]]></xsl:template></xsl:stylesheet>' where Title='Account Reconnect'