• subscribe
December 02, 1999 11:56 AM

Correction - for

SQL Server Pro
InstantDoc ID #7711

In "Merge Zone" (November), the database diagram contained an error. The correct diagram has an additional table, field_user, that is used for the dynamic filtering criteria. The current field_user table in the diagram should be called field_user/events and represents the many-to-many relationship between field users and events. So the field_ user/events and field_user tables are joined on their respective rep_id columns; field_user/events and events are joined on each table's event_id column. In other words, event_id in field_user/events is a foreign key whose matching primary key is event_id in events; rep_id in field_user/events is the foreign key whose matching primary key is rep_id in field_user.



ARTICLE TOOLS

Comments
    There are no comments to display. Be the first one!
You must log on before posting a comment.

Are you a new visitor? Register Here
  • SP1?
    I know there is a SP1 for SQL 2008 R2 available....and there is a "feature pack" as well... ...
  • SQL database mirroring
    I have SQL Server 2008 R2 Enterprise 64bit on Windows 2008 R2 Enterprise 64bit.  Each SQL Server has...
  • Dell Compellent Disk Drive
    Does anybody has experience with Dell Compellent Disk Drive? Basically, this system manages all disk...
  • Sql server performance tuning
    I need to find a tool that help me to optimize sql server,queries,improve the performance and solve ...