x

UDF with Table-Valued Param; Output HTML string using XML

First-time poster here. I sincerely value the contributions many of you have made to this forum over the years. I have learned a lot.

I am thinking of a function for future use that I would like to create but don't know if it's possible (first of all), and even if it was, am not sure exactly how to get started with this one.

I want a function generic enough that it could be used by various reporting jobs to create an output HTML table (VARCHAR(MAX)) for DBmail jobs to run daily/weekly exception reports. This function would need to accept a table-valued parameter and output the table as an HTML string, presumably using XML syntax, though I would use any syntax that would work. Is this function possible on SS2008-R2?

Thank you.

more ▼

asked Jul 18, 2014 at 01:14 PM in Default

avatar image

barryblessing
1 1 1 2

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

This sounds like a bit of a nightmare to manage TBH. Wouldn't it just be simpler to set up the reports in SSRS and use subscriptions to manage the delivery?

http://msdn.microsoft.com/en-us/library/ms159762.aspx

more ▼

answered Jul 18, 2014 at 02:46 PM

avatar image

iainrobertson
3k 4 7 11

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x202
x83
x19
x16
x4

asked: Jul 18, 2014 at 01:14 PM

Seen: 682 times

Last Updated: Jul 18, 2014 at 02:46 PM

Copyright 2017 Redgate Software. Privacy Policy