dodgerfan
asked on
Subqueries
I think I need a subquery here, but I do not know for sure and I have no experience with them. I have a SQL Server 2005 database. I need to create a view that will return all of the records with a certain status that I'm responsible for. My responsibility is determined by the code the record is assigned that conincides with the codes I'm responsible for. There are 100 different codes, and I can me assigned to any number fo them. So the main record table has 1500 records in it. Each record has a status(1, 2, 3, 4) and a code(a, b, c, d, etc.). I am assigned to 5 different codes (a, b, c, d, e). I want to return any record with a status of 1 in any of the codes I'm assigned to. What is the best way to do this? I hope this is clear. Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.