Unique constraint with a twist

Hot Topic

Failing a SSIS Script component
SSIS - Built-In Logging Execution ID Problem
with new hard drive- Error 3: the system cannot find the specified path
Number of concurrent users
Return the data from a table ordered by its hierarchy
Completely Removing SQL Server 2005 Express
Multiple indexes on the same column
SCD and populating dimensions and facts
Trouble using sql:relation/sql:relationship in xsd file ...
Parameter problem

SQL Server

Report Subscription sends wrong version
Unable to cast object of type Microsoft.SqlServer.Management.UI.ConnectionDlg.Personalization to type Microsoft.SqlServer.Manage
Parameter defaults not working
Debugging a script component task???
Import Export Wizard - ODBC to SQL
NEWSEQUENTIALID()
Reporting Services Setup Issue
Object variable assigned to parent package
SSIS Performance compared to DTS
"Replication" between two servers which do not have connection at all

Unique constraint with a twist

Hi,

I'm not sure if this is possible, so hopefully you'll be able to help me .

I want to ensure that values in one column are unique in thier group (which is stored in a second column)

For example:

ID Name Group

1 ABC G1

2 ABC G1 would be invalid because ABC is already in group 1

3 ABC G2 would be OK because it's in group 2

Thanks in advance!

Answer this question

Unique constraint with a twist

  • Elliott_Ward

    HI,

    you have to create a compound key, either within the Create Table statement or as a separate statement

    CONSTRAINT UQ_CompoundOne UNIQUE (col1, col2)

    See more information in the bOL

    HTH, Jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---
  • Unique constraint with a twist
Answer this question