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 |
|
lmparreira
Starting Member
1 Post |
 Posted - 2008-02-22 : 05:34:17
|
| I have 3 Checkbox list panels that query the DB for the items. Panel nº 2 and 3 need to know selection on panel nº 1. Panels have multiple item selection. Multiple users may use this at the same time and I wanted to have a full separation between the application and the DB. The ASP.net application always uses Stored Procedures to access the DB. Whats the best course of action? Using a permanent 'temp' table on the SQL server? Accomplish everything on the client side?[Web application being built on ASP.net 3.5 (IIS7) connected to SQL Server 2005) |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-02-23 : 12:22:48
|
| If you are allowing the user(s) to sort the info , which affects the relationshiphs in the db , then you might have to consider locking the records . Alternatively , if this not the issue, do it on the client side.Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
 |
|
|
|
|
|
Temp. tables / Variables / Process Keyed Tables ?