Post reply

Create periodically html tables based on a view

  • August 23, 2010 at 12:10 am

    #225053

    Good afternoon everyone

    I am currently developing a new website and try to see how i could explore my data stored in our corporate 2008 SQL server . The data i want to display is not changing too much and instead of having ASP or PHP pages accessing directly the DB for requesting similar outputs and overloading the DB, i would like to create twice a day web pages which would contain HTML tables, stored them on my web server and would be accessed direcly by the users.

    I spent the whole afternoon exploring on the Web, the different possibilities such as SQL server Agent, reporting services but don' t really know how to achieve such a task...

    Would any of you could give some ideas, some simple ways on how to do that?

    -Creating the output based on my query or view

    -Put it on my web server to be accessed by web users.

    Thanks a lot in advance for your help

    Sylvain

  • August 23, 2010 at 1:23 pm

    #1210667

    You may use the Scheduled Reporting feature in SSRS

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • August 24, 2010 at 10:03 pm

    #1211437

    Thanks Adiga

    We don' t have reporting services with a report server installed in our SQL Server configuration.

    Is there any other ways using a stored procedure for example to be executed periodically through a SQL Server Job in order to store the result page in my web Server?

    Thanks

    Sylvain

  • August 24, 2010 at 10:48 pm

    #1211446

    Here is one such example.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • August 24, 2010 at 10:49 pm

    #1211448

    One more example[/url] at SSC using SSIS

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

Viewing 5 posts - 1 through 4 (of 4 total)

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