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 |
|
imlodhi
Starting Member
2 Posts |
 Posted - 2011-06-01 : 11:26:34
|
| Hi,I have a requirement to display data in two different front end applications from 4 tables which are in same database by using views/stored procedures (not sure which one is better???) and then once data is updated at the front end i need to write back new/updated records to the 4 tables using views/stored procedures (Not sure which one is better???).Now, two different applications using data entirely differntly with differnt combination of joins and display datasets. How to deal with this requirement. What is the best approach to display data and how to save it back to the tables?Any thoughts regarding best approaches whould be appreciated.Thanks. |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2011-06-02 : 01:38:21
|
| Could you confirm\outline the reasons why the data - is in the same tables? Does the data model\design fit in with the intention of the data use? Is integrity required between data?Displaying data is a case of building a SELECT statement, creating a recordset object and displaying on the front-end application. This will depend on the frontend application.Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
|
|
|
Two different frontends using same base tables!!!!