Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ruchirj07
Starting Member
37 Posts |
 Posted - 2007-12-12 : 01:04:43
|
| Hi,I want to create a hyperlink on column "TestCaseID" in every row generated using a QUERY while sending the mail. I'm using the following code :SET @tableHTML = N'<H1><BR><p><font color=""#0000A0"">Task Order Report</BR></H1>' + N'<body> New TaskId = <STRONG><a href= '+@tmpHeyper+'> TCM_2100 </a> </STRONG> containing 100 TestCases is generated successfully for Schedule with ID : <STRONG> TCM_100 </STRONG>. You can check the task for this schedule by logging into TCM under your Workspace.<BR></BR><BR></BR>'+ N'<table border=""0"" width=""100%"" bgcolor=""#FF0000"">' + N'<tr><th>TestCaseID</a></th><th>Product Area</th>' + N'<th>Product Sub Area</th><th>Execution Mode</th>' + CAST ( ( SELECT td = testcaseid , '', td = [Product Area], '', td = [Product Sub Area], '', td = tbltestcaseresult.nResultMode, '' FROM vwTestCaseDetail JOIN tbltestcaseresult ON testcaseid = atestcaseid WHERE aTaskId = 'TCM_2100' ORDER BY testcaseid FOR XML PATH('tr'), TYPE ) AS NVARCHAR(MAX) ) + N'</table>''</body>' ;Please Help. |
|
|
|
|
|
hyperlink using sp_send_dbmail