>Given the following:
>
>- Each department can have multiple users.
>- Each user can have multiple departments.
> -A letter belongs to a user and a department
>
>How would you write a stored procedure that takes a UserID and returns all of the columns from the
>Department and Letter tables for each Letter for the UserID that was passed to the stored procedure?
>
>I'm not sure how to code this with the many-to-many relationship between Departments and Letters.
Post your tables creation scripts and some sample data.
If it's not broken, fix it until it is.
My Blog