My favorites
▼
|
Sign in
pyodbc
Python ODBC library
Project Home
Downloads
Wiki
READ-ONLY: This project has been
archived
. For more information see
this post
.
Search
Search within:
All issues
Open issues
New issues
Issues to verify
for
Advanced search
Search tips
Subscriptions
Issue
41
attachment: query.txt
(10.8 KB)
1
2
3
4
5
6
7
8
9
DECLARE @TemplateHTML varchar(8000)
SET @TemplateHTML = ' <strong><html>' + char(13) + '<head>' + char(13) + '<title>Bugaboo Creek Steakhouse</title>' + char(13) + '<meta http-equiv=' + char(34) + 'Content-Type' + char(34) + ' content=' + char(34) + 'text/html; charset=iso-8859-1' + char(34) + ' />' + char(13) + '##Global.HotmailCSS##</head>' + char(13) + '<body bgcolor=' + char(34) + '#FFFFFF' + char(34) + ' alink=' + char(34) + '#993333' + char(34) + ' vlink=' + char(34) + '#993333' + char(34) + ' link=' + char(34) + '#993333' + char(34) + '>' + char(13) + '<table id=' + char(34) + 'Table_01' + char(34) + ' width=' + char(34) + '550' + char(34) + ' height=' + char(34) + '685' + char(34) + ' border=' + char(34) + '0' + char(34) + ' cellpadding=' + char(34) + '0' + char(34) + ' cellspacing=' + char(34) + '0' + char(34) + '>' + char(13) + '<tr>' + char(13) + '<td><img src=' + char(34) + 'spacer.gif' + char(34) + ' width=' + char(34) + '33' + char(34) + ' height=' + char(34) + '1' + char(34) + '></td>' + char(13) + '<td><img src=' + char(34) + 'spacer.gif' + char(34) + ' width=' + char(34) + '483' + char(34) + ' height=' + char(34) + '1' + char(34) + '></td>' + char(13) + '<td><img src=' + char(34) + 'spacer.gif' + char(34) + ' width=' + char(34) + '34' + char(34) + ' height=' + char(34) + '1' + char(34) + '></td></tr>' + char(13) + '##EMAIL_ONLY##' + char(13) + '<tr><td align=' + char(34) + 'right' + char(34) + ' colspan=' + char(34) + '3' + char(34) + '><font face=' + char(34) + 'Arial, Helvetica, sans-serif' + char(34) + ' size=' + char(34) + '1' + char(34) + '>##PROBLEMVIEWING##</font></td></tr>' + char(13) + '##END_EMAIL_ONLY##' + char(13) + '<tr><td colspan=' + char(34) + '3' + char(34) + '><table width=' + char(34) + '550' + char(34) + ' cellpadding=' + char(34) + '0' + char(34) + ' cellspacing=' + char(34) + '0' + char(34) + ' border=' + char(34) + '0' + char(34) + '><tr>' + char(13) + '<td rowspan=' + char(34) + '2' + char(34) + '><img src=' + char(34) + '##IMGPATH##1.jpg' + char(34) + ' alt=' + char(34) + '' + char(34) + ' width=' + char(34) + '200' + char(34) + ' height=' + char(34) + '113' + char(34) + ' border=' + char(34) + '0' + char(34) + ' usemap=' + char(34) + '#Map' + char(34) + ' /></td>' + char(13) + '<td><img src=' + char(34) + '##IMGPATH##2.jpg' + char(34) + ' width=' + char(34) + '316' + char(34) + ' height=' + char(34) + '29' + char(34) + ' alt=' + char(34) + '' + char(34) + ' /></td>' + char(13) + '<td rowspan=' + char(34) + '2' + char(34) + '><img src=' + char(34) + '##IMGPATH##3.jpg' + char(34) + ' width=' + char(34) + '34' + char(34) + ' height=' + char(34) + '113' + char(34) + ' alt=' + char(34) + '' + char(34) + ' /></td>' + char(13) + '</tr>' + char(13) + '<tr><td backgrouND=' + char(34) + '##IMGPATH##4.jpg' + char(34) + ' width=' + char(34) + '316' + char(34) + ' height=' + char(34) + '84' + char(34) + ' align=' + char(34) + 'center' + char(34) + ' bgcolor=' + char(34) + '#993333' + char(34) + '><font face=' + char(34) + 'Arial, Helvetica, sans-serif' + char(34) + ' color=' + char(34) + '#FFFFFF' + char(34) + ' size=' + char(34) + '6' + char(34) + ' style=' + char(34) + 'font-size:24;' + char(34) + '>##HEAD##</font></td></tr>' + char(13) + '</table>' + char(13) + '</td></tr>' + char(13) + '<tr><td colspan=' + char(34) + '3' + char(34) + '><img src=' + char(34) + '##IMGPATH##5.jpg' + char(34) + ' width=' + char(34) + '550' + char(34) + ' height=' + char(34) + '55' + char(34) + ' alt=' + char(34) + '' + char(34) + ' /></td></tr>' + char(13) + '<tr>' + char(13) + '<td backgrouND=' + char(34) + '##IMGPATH##6.gif' + char(34) + ' width=' + char(34) + '33' + char(34) + ' height=' + char(34) + '66' + char(34) + '></td>' + char(13) + '<td backgrouND=' + char(34) + '##IMGPATH##7.gif' + char(34) + ' width=' + char(34) + '483' + char(34) + ' height=' + char(34) + '66' + char(34) + ' align=' + char(34) + 'center' + char(34) + '><font face=' + char(34) + 'Arial, Helvetica, sans-serif' + char(34) + ' size=' + char(34) + '2' + char(34) + ' color=' + char(34) + '#000000' + char(34) + '>' + char(13) + '##EMAIL_ONLY##' + char(13) + '<b>##Global.FirstName##</b><br />' + char(13) + '##END_EMAIL_ONLY##' + char(13) + '</font><font face=' + char(34) + 'Arial, Helvetica, sans-serif' + char(34) + ' size=' + char(34) + '3' + char(34) + ' color=' + char(34) + '#000000' + char(34) + '><b>##SUBHEAD##</b></font><BR /></td>' + char(13) + '<td backgrouND=' + char(34) + '##IMGPATH##8.gif' + char(34) + ' width=' + char(34) + '34' + char(34) + ' height=' + char(34) + '66' + char(34) + '></td>' + char(13) + '</tr>' + char(13) + '<tr>' + char(13) + '<td backgrouND=' + char(34) + '##IMGPATH##9.gif' + char(34) + ' width=' + char(34) + '33' + char(34) + ' height=' + char(34) + '327' + char(34) + '></td>' + char(13) + '<td backgrouND=' + char(34) + '##IMGPATH##10.gif' + char(34) + ' width=' + char(34) + '483' + char(34) + ' height=' + char(34) + '327' + char(34) + ' valign=' + char(34) + 'top' + char(34) + '>' + char(13) + '<table width=' + char(34) + '40%' + char(34) + ' height=' + char(34) + '300' + char(34) + ' cellpadding=' + char(34) + '0' + char(34) + ' cellspacing=' + char(34) + '0' + char(34) + ' border=' + char(34) + '0' + char(34) + ' align=' + char(34) + 'left' + char(34) + '>' + char(13) + '<tr valign=' + char(34) + 'top' + char(34) + '><td>##PHOTO1## <BR /><BR /><BR /><BR /></td></tr>' + char(13) + '<tr valign=' + char(34) + 'bottom' + char(34) + '><td>##PHOTO2##</td></tr>' + char(13) + '</table>' + char(13) + '<font face=' + char(34) + 'Arial, Helvetica, sans-serif' + char(34) + ' size=' + char(34) + '3' + char(34) + ' color=' + char(34) + '#993333' + char(34) + '><b>##BHEAD1##</b></font><br />' + char(13) + '<font face=' + char(34) + 'Arial, Helvetica, sans-serif' + char(34) + ' size=' + char(34) + '2' + char(34) + ' style=' + char(34) + 'font-size:13px;' + char(34) + 'color=' + char(34) + '#000000' + char(34) + '>##BODY1##</font><br /><br />' + char(13) + '<font face=' + char(34) + 'Arial, Helvetica, sans-serif' + char(34) + ' size=' + char(34) + '3' + char(34) + ' color=' + char(34) + '#993333' + char(34) + '><b>##BHEAD2##</b></font><br />' + char(13) + '<font face=' + char(34) + 'Arial, Helvetica, sans-serif' + char(34) + ' size=' + char(34) + '2' + char(34) + ' style=' + char(34) + 'font-size:13px;' + char(34) + ' color=' + char(34) + '#000000' + char(34) + '>##BODY2##</font><br /><br />' + char(13) + '<font face=' + char(34) + 'Arial, Helvetica, sans-serif' + char(34) + ' size=' + char(34) + '3' + char(34) + ' color=' + char(34) + '#993333' + char(34) + '><b>##BHEAD3##</b></font><br />' + char(13) + '<font face=' + char(34) + 'Arial, Helvetica, sans-serif' + char(34) + ' size=' + char(34) + '2' + char(34) + ' style=' + char(34) + 'font-size:13px;' + char(34) + 'color=' + char(34) + '#000000' + char(34) + '>##BODY3##</font><BR /><BR />' + char(13) + '</td>' + char(13) + '<td backgrouND=' + char(34) + '##IMGPATH##11.gif' + char(34) + ' width=' + char(34) + '34' + char(34) + ' height=' + char(34) + '15' + char(34) + '></td>' + char(13) + '</tr>' + char(13) + '<tr><td colspan=' + char(34) + '3' + char(34) + '><img src=' + char(34) + '##IMGPATH##12.gif' + char(34) + ' width=' + char(34) + '550' + char(34) + ' height=' + char(34) + '33' + char(34) + ' alt=' + char(34) + '' + char(34) + ' /></td></tr>' + char(13) + '<tr>' + char(13) + '<td backgrouND=' + char(34) + '##IMGPATH##13.gif' + char(34) + ' width=' + char(34) + '33' + char(34) + ' height=' + char(34) + '50' + char(34) + '></td>' + char(13) + '<td backgrouND=' + char(34) + '##IMGPATH##14.gif' + char(34) + ' width=' + char(34) + '483' + char(34) + ' height=' + char(34) + '50' + char(34) + ' style=' + char(34) + 'padding-right:25px;' + char(34) + '><font face=' + char(34) + 'Arial, Helvetica, sans-serif' + char(34) + ' size=' + char(34) + '2' + char(34) + ' color=' + char(34) + '#000000' + char(34) + '>##CLOSINGCOPY##</font></td>' + char(13) + '<td backgrouND=' + char(34) + '##IMGPATH##15.gif' + char(34) + ' width=' + char(34) + '34' + char(34) + ' height=' + char(34) + '66' + char(34) + '></td>' + char(13) + '</tr>' + char(13) + '<tr><td colspan=' + char(34) + '3' + char(34) + '><img src=' + char(34) + '##IMGPATH##16.gif' + char(34) + ' width=' + char(34) + '550' + char(34) + ' height=' + char(34) + '41' + char(34) + ' alt=' + char(34) + '' + char(34) + ' /></td></tr>' + char(13) + '<tr><td colspan=' + char(34) + '3' + char(34) + '><font face=' + char(34) + 'Arial, Helvetica, sans-serif' + char(34) + ' size=' + char(34) + '1' + char(34) + ' color=' + char(34) + '#000000' + char(34) + '>##RESTRICTIONS##</font></td></tr>' + char(13) + '<tr><td colspan=' + char(34) + '3' + char(34) + ' align=' + char(34) + 'center' + char(34) + '><font face=' + char(34) + 'Arial, Helvetica, sans-serif' + char(34) + ' size=' + char(34) + '1' + char(34) + ' style=' + char(34) + 'font-size:10px' + char(34) + '><br />' + char(13) + '##ftflink## ' + char(13) + '<a href=' + char(34) + '<URL:1>' + char(34) + ' target=' + char(34) + '_blank' + char(34) + '>Visit Us Online</a> ' + char(13) + '##EMAIL_ONLY##' + char(13) + '##Global.ProfileLink##' + char(13) + ' ' + char(13) + '##Global.UnsubscribeLink##' + char(13) + '##END_EMAIL_ONLY##' + char(13) + '##WEB_PAGE_ONLY##' + char(13) + '<a href=' + char(34) + '##Global.URL_JoinPage##' + char(34) + '>Join The Creek Club</a>' + char(13) + '##END_WEB_PAGE_ONLY##' + char(13) + '<br />' + char(13) + '</font></td></tr>' + char(13) + '<tr><td colspan=' + char(34) + '3' + char(34) + '>##EMAIL_ONLY##<hr noshade><table cellpadding=' + char(39) + '0' + char(39) + ' cellspacing=' + char(39) + '0' + char(39) + ' width=' + char(39) + '100%' + char(39) + '>' + char(13) + '<tr><td><a href=' + char(39) + 'http://www.fishbowl.com/fishbowl/power.html' + char(39) + ' target=' + char(39) + '_blank' + char(39) + '><img src=' + char(39) + 'http://www.fishbowl.com/poweredby.gif' + char(39) + ' alt=' + char(39) + 'Powered by Fishbowl' + char(39) + ' width=' + char(39) + '115' + char(39) + ' height=' + char(39) + '39' + char(39) + ' border=' + char(39) + '0' + char(39) + ' /></a></td><td><font face=' + char(39) + 'Arial, Helvetica, sans-serif' + char(39) + ' size=' + char(39) + '1' + char(39) + ' style=' + char(39) + 'font-size:11px;' + char(39) + ' color=' + char(39) + '#000000' + char(39) + '>##Global.OptOutLanguage## ##Global.CorpMailingAddress##</font></td></tr></table><font face=' + char(39) + 'Arial, Helvetica, sans-serif' + char(39) + ' size=' + char(39) + '1' + char(39) + ' style=' + char(39) + 'font-size:11px;' + char(39) + ' color=' + char(39) + '#000000' + char(39) + '>To ensure delivery, add <b>##Mailing.FullFromAddress##</b> to your address book.</font>##END_EMAIL_ONLY## ##WEB_PAGE_ONLY## ##Global.WebVersionFooter##</td></tr></table>##END_WEB_PAGE_ONLY##</body></html></strong>'
INSERT INTO tbl_FinalDestination
SELECT value1, value2, @TemplateHTML, value4, value5, etc, NULL
FROM tbl_FinalDestination
WHERE value1 = '16903'
select @@IDENTITY
Powered by
Google Project Hosting