Show 3 different ways to do the following:
- Each department can have multiple users.
- Each user can have multiple departments.
- A letter belongs to a user and a department.
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.
Here's one way that I came up with:
CREATE PROCEDURE GetDeptLetters
@UserId INT
AS
SELECT d.*, l.*
FROM Departments d
JOIN Letters l ON l.DepartmentId = d.DepartmentId AND l.UserId = @UserId
WHERE d.DepartmentId = @UserId
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people