Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-07-31 : 17:31:31
|
| Ian writes "I wasn't sure how to describe this in the subject line so please keep reading.I have a table we'll Call RFP that has an RFP_ID and a Sponsor_ID (FK to the Sponsor table). 1 Sponsor can have 0..* RFPs. But I want all of the rows from the RFP table have a 1..1 relationship with Sponsor. Or in other words I want to find the rows with Sponsor_IDs that are unique within the RFP table.I've spent an entire day on a script but think it can be MUCH better (its very slow) and wanted to see what a true GURU could do.Cheers,Ian." |
|
|
|
|
|
finding rows that have a one to one relationship