Home Forums SQL Server 2008 SQL Server 2008 - General Check Constraint Question - Situations Where a Child Record Should Be Limited to One Occurrance RE: Check Constraint Question - Situations Where a Child Record Should Be Limited to One Occurrance

  • Hmmm...

    So in the DateCategory table, add a column that defines if the specific date category (Project Review, Weekly Check-In, Project Handover, etc.) is 'limited' (?) and then have the function look up the value, check the records and then grant its blessing.

    Thanks.