What are the challenges you face when working across database platforms? Take the survey
Options

Dealing with denormalised data

I'm trying to generate a table that for performance reasons uses some denormalised data. However, I cannot see how to pick this up from the source table.

The relevant parts of the schema are:

Employee:
  • Id: Int PK
  • FirstName: nvarchar
  • Lastname: nvarchar
Appointment:
  • EmployeeId : int FK
  • EmployeeName: nvarchar (concatenation of Employee.FirstName, Employee.LastName)

Setting the EmployeeId was easy enough using the Foreign Key generator, however, I need to the EmployeeName to match the values from the Employee table.


Tagged:

Answers

Sign In or Register to comment.