mmeisel
asked on
SQL Cross Join / Stored Proc
I want to create a stored procedure that will take in a year, look up "active" rows in a "Code Table" and insert it into another table (Table B). For instance:
Year: 2009
Code Table
ID - several other columns - Status
1 - ... - Active
2 - ... - Inactive
3 - ... - Active
Table B
Year - ID
2009 - 1
2009 - 3
Year: 2009
Code Table
ID - several other columns - Status
1 - ... - Active
2 - ... - Inactive
3 - ... - Active
Table B
Year - ID
2009 - 1
2009 - 3
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.