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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-03 : 09:56:08
|
| Greg writes "window 2000 spk 2sql server 2000An internet application spec I'm currently working on calls for the ability to create list of customers that preformed any of a variety of actions from various tables. These lists must be available for an indeterminate amount of time for viewing/editing/acting on. These lists or snapshots are named and created dynamically. My current model has a web UI calling a C++ CGI that uses ADO to make stored procedure calls. Thanks to your article on Dynamic SQL I've worked out how I can formulate the where and join portions of the query, however I'm at a lose as to how to store the results. The queries are fairly complicated and the tables quite large, so I expect execution times to be on the order of an hour.thanks in advance" |
|
|
jackstow
Posting Yak Master
160 Posts |
Posted - 2002-04-03 : 10:22:52
|
| Maybe XML would be the way to go. SQL Server 2000 has loads of built in XML features and there's a thread here http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=9336 where robvolk has a way of creating xml files from stored procedures. |
 |
|
|
|
|
|
how to store a