In this case, just the three listed and rowguid for replication, oh, and
a table key. So:

KeyID, Person, Breed, Favorite
1, Dan, Cocker Spaniel, False
2, Dan, Lab, False
3, Dan, Bulldog, False
4, Dan, Great Dane, True


------------------------------------------------------------------
Dan



Mordechai
Danielov
<mssqldba-ezmlms To
hield-x61402050. LazyDBA Discussion
[Email Address Removed] <[Email address protected]
DBA.com> cc

09/28/2006 08:50 Subject
AM RE: Conditional unique index?










What columns do you have in this table?

-----Original Message-----
From: Guzman [mailto:mssqldba-ezmlmshield-x58686773.[Email address
protected]

Sent: Thursday, September 28, 2006 11:44 AM
To: LazyDBA Discussion
Subject: Conditional unique index?

Can you create a conditional unique index? An example: Each person can
have more than one breed of dog, but only one can be they're favorite.
So the primary key is Person/breed, but can I create a conditional index
that allows for only one Person/Favorite, but allows the rest to be
false? Something like 'WHERE count([Favorite])=1


Dan, Cocker Spaniel, False
Dan, Lab, False
Dan, Bulldog, False
Dan, Great Dane, True

I know there is a difference between better and easy. Better would be a
separate table of Favorites, with Person as primary, but an index would
allow me to save a step or three in combobox dropdown list creation
(adding a column to the dropdown list is way easier than creating
another subform, subquery and combobox with dropdown)

Dan



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




MS Sql Server LazyDBA home page