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 |
|
imranabdulaziz
Yak Posting Veteran
83 Posts |
 Posted - 2008-06-12 : 07:33:29
|
| Dear all,I am using sql server 2005.Let me explain the scenario : I am making request system where one request goes to immidiate boss and its immidiate boss till the contry head and even one has right to approve or reject the request. Once its approve from one level it goes to other level but now problem is if some one in the hierarchy does not responds.My table staructure is Requestno Requestemp Requestdate Superieremp Expirydate status0001 Em486 21-04-2008 Em604 23-04-2008 HoldTo do the same I am trying to schedule a job which run one sp where I am searching all the superieremp whose status is hold and expirydate is today date. Now problem is when there is multiple record as against each indivual I have to insert the record in the same mannerPlease suggest some ideas or any other idea please suggestThank you. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-12 : 07:58:41
|
| So are you trying to pass all the record values in same record as comma delimited? |
 |
|
|
|
|
|
how to perform a action on list of empcode