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 - 2001-03-10 : 09:15:30
|
Tamil Selvan writes "Dear Sir,
I'm working in Business - to - Business Project. In that, i showed catalog in the form of tree view. Initially i used to one duplicate table and store all the datas to display the structure using the server side scripting. I faced one problem in this, since i used duplicate table...at a time only one session will be active...if the other person open new window and access that tree view, then it erases the data present in the duplicate table...i actually put the data in the duplicate tbale and display it in the browser...later i try to convert into stored procedure for this operation. In the stored procedure, i used temporary table for storing the datas. I faced a problem of data retrieving....in my coding, i used to access the stored procedure 2 times...first time, i store the datas...second time, retrieving the datas....first time it executes, second time if i try to access the table is not there in the database....i need help from this....if any other better solution for creating treeview structure display, pls help me....
Thanks & Regards
Tamil Selvan P.R." |
|
|
|
|
|
Reg: Creating Stored Procedure For Tree View Structure