Need idea regarding some Sql Server manipulations

[binilprasad]

Hi

I am more into web development than to database side. Recently I recieved a web project related to report generations. By going through the tables in DB which I need to use, I felt that those tables never support a web application development. So what I need is ,

I need to a new table which contains only those data needed for my web application and I need to get the data from other tables. Is it possible to do something in Sql Server such that, whenever a new data comes into one table , it should be read and get only the necessary data and store in another table. It should be automated. I like to know if something can be done in sql server.

Thank You

[George1111]

Depending how you want to use the New Table

If the data is already in a few other tables, already in the database, you are able to generate reports etc, by selecting data across a number of tables if required (which may mean you really dont need the new table at all)

OR

You are able to setup "Triggers" which will cause the new table to be updated each time a particular table is changed

OR

If your New Table is to be used for reporting occasionally, then simply generate the new table prior to creating the reports.

[hspc]

If your New Table is to be used for reporting occasionally, then simply generate the new table prior to creating the reports.

I think this is one of the common approaches. Create a SSIS package that transforms data periodically from original table to the reporting table. Call this package from a scheduled SQL server job.