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 |
|
real_pearl
Posting Yak Master
106 Posts |
 Posted - 2004-07-01 : 01:58:38
|
| If I have a master-detail table structure. And at run time records are inserted into master and detail and finally the results are displayed. But the master-detail table structure is not permanent but is temporary because of client/server environment. How the data may be passed to the stored procedure which may do all the manipulations and finally return data. Either front-end developer pass a string containing all parents and child and then this string may be parsed to seperate parent and child for insertion into tables or some other way would be fine?Please give me some better solution |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-07-01 : 04:20:08
|
| and why don't you use datasets?? and how do you handle variable structure?Go with the flow & have fun! Else fight the flow :) |
 |
|
|
real_pearl
Posting Yak Master
106 Posts |
Posted - 2004-07-01 : 04:56:34
|
| I have to do it in SQL Server. I have done it using XML.Thanks |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-07-01 : 05:13:54
|
| i have no idea how to handle this in sql server... sorry...my approch would be to populate a dataset from xml and then create/alter a table with that...Go with the flow & have fun! Else fight the flow :) |
|
|
|
|
|
|
Solution Required