Post reply

DBMAIL QUERY RESULT IN HTML FILE

  • October 5, 2013 at 2:15 am

    #278703

    Dear,

    I require to send a file as attachment that is generated from a query result.

    Usually the attachment is with ".dat" extension. Now I want that the attachment should be in html format.

    Please any idea would help me a lot.

    Regards

    Akbar

  • October 6, 2013 at 1:50 pm

    #1656187

    [SET SARCASM ON]

    Wow, that's really a lot information to work with...

    The easies way: change the .dat extension to .html. Not that it would do any good, but at least it would answer your "question"...

    [SET SARCASM OFF]

    How about some ready to use sample data together with your expected result (both, .dat and .html format)? See the first link in my signature for details.

    Maybe it'll be enough to use the FOR XML output formatting. But if the html file also needs to include formatting or the like it might become "slightly" more complicated. We don't know. From my point of view there's a "tipping point of complexity" where it's easier to use SSRS and it's functionalities vs. trying to do all with SQL.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply