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 |
|
dev.tekk
Starting Member
1 Post |
 Posted - 2009-12-17 : 14:13:18
|
| Hi,My site's user admin allows the admins to assign users to work with different locations for the app. What I want to do is that instead of just returning all the locations for selecting, have the returned recordset not include those locations already assigned to the user.I want to do this in the stored procedure. My first thought is building a string by finding the assigned locations to the user then searching the locations table using a WHERE not include parameter (or maybe use a join statement?) to create the record set.Any ideas?Thanks,James |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-12-18 : 01:01:57
|
| Post the code that you are currently usingMadhivananFailing to plan is Planning to fail |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-12-20 : 03:47:59
|
| isnt it better to take a left join with table containing assigned locations and look for those records from location master which doesnt have a match (not already assigned)? |
|
|
|
|
|
|
Filtering record set in a stored procedure