Produce a data exception report

[robbwalsh]

Scenario: I have 3 tables for this data exception report that I care about -

Table Fields
User UserID, UserName ...
UserSupportGroup UserSupportGroupID, UserID, SupportGroupID ...
SupportGroup SupportGroupID, SupportGroupName ...

UserSupportGroup is a junction table and allows many:many.

I want to be able to produce a result set where a supportgroup exists with duplicate users. The supportgroup can have a different name, but the user list must be an exact match. This will be for SQL Server 2000

 

[r937]

what columns would you like to see in the result set?

r937.com | rudy.ca

 

[dnoeth]

Looks like a Relational Division problem, there were some articles by Itzik Ben-Gan in SQL Server Magazine:

http://www.windowsitpro.com/Article/ArticleID/39300/39300.html

http://www.windowsitpro.com/Article/ArticleID/39604/39604.html

Dieter

 

[robbwalsh]

RE: "what columns would you like to see in the result set?"

I intend to use a stored procedure, and perhaps I would insert the results into a new table. Ideally the resultant report would state:

(pseudocode)
"SupportGroup: " + SupportGroupNameMatch + " has the same users as SupportGroup: + SupportGroupNameMatchPair

 

[r937]

at this point i would suggest you read those two articles that dieter posted

wouldn't want to re-invent the wheel, eh ;-)

r937.com | rudy.ca