When designing a view, would it be best to retrieve
- the ID fields where FK relationships exist between the joined tables
- the desired description field obtained through the FK id relationship
The views I am writing will be primarily used for SSRS reports and I want the views to be adaptable and flexible for multiples uses.
Critiques/advice are encouraged!