3 May 2007

Create HTML from SQL

by | posted in: Tech | 0
Run this in SQL Server Job or QA:
EXEC sp_makewebtask
@outputfile = ‘\\intweb\websites\closing.nyhrc.com\dailyrpt.html’,
@query = ‘select * from vw_DailyRptHTML’,
@templatefile = ‘C:\Test1.tpl’,
@singlerow = 0,
@whentype = 1
This is Test1.tpl:
<!DOCTYPE html PUBLIC “-//W3C//DTD HTML 3.2//EN”>
<html>
<head>
<title></title>
</head>
<body>
<table width=”100%” border=”1″ cellpadding=5 cellspacing=5>
<%begindetail%>
<tr>
<td align=”right”><%insert_data_here%></td>
<td align=”center”><%insert_data_here%></td>
<td align=”center”><%insert_data_here%></td>
<td align=”center”><%insert_data_here%></td>
<td align=”center”><%insert_data_here%></td>
<td align=”center”><%insert_data_here%></td>
<td align=”right”><%insert_data_here%></td>
<td align=”right”><%insert_data_here%></td>
<td align=”right”><%insert_data_here%></td>
<td align=”right”><%insert_data_here%></td>
<td align=”right”><%insert_data_here%></td>
<td align=”right”><%insert_data_here%></td>
</tr>
<%enddetail%></table>
</body>
</html>