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 - 2005-12-20 : 08:23:05
|
| Frank writes "I am new to SQL Server, and I was wondering if you could help me with your knowledge !!I have three tables, table a is to keep track of attorneys, like name, attorney numbers, attorney section, attorneykey, table b is to keep track of the attorney's cases( this is a one too many relationship(attorney's could have many cases assigned) table c is to keep track of the max and min numbers. (to track the attorney's position).The scope of the project is to select an attorney based on their section, there are 4 sections (sections 1,2,3 and 8)This is sort of a wheel, I need to pick an attorney from the top of the attorney's table and so on, and if the attorney is rejected, then that attorney should be put on the bottom of the attorney's table.Can this be done using a stored procedure, and can you guide me ?" |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2005-12-20 : 08:36:46
|
déjà vuhttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=59314 -----------------[KH]Learn something new everyday |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-20 : 09:41:42
|
| >>déjà vuDoes it mean Duplicate post?Which language is it?MadhivananFailing to plan is Planning to fail |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2005-12-20 : 18:37:31
|
déjà vu is French and means, literally, "already seen."  -----------------[KH]Learn something new everyday |
|
|
|
|
|
|
|
|
how to ?