× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



YEEEEESH
My brain bleeds for you
To better get a grasp of what you are talking about, can you supply some examples of categories and what each contains (the FULL content of each category)

Alan Shore
Programmer/Analyst, Direct Response
E:AShore@xxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dennis
Sent: Friday, June 03, 2011 12:40 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Identifying unique sets of combinations

We have a table as part of our HR system that is used to categorize days off. For example, "S" (for sick) is in the SCKAC, USEDS, VACCK and 14 other categories (I know, I know). V(acation) is in 7 categories, and so on. These things are categorized in such a way because they intersect so much. For example, a Carry-over vacation day and a Vacation day each have the same effect in terms of Vacation Balance, but very different effects when it comes to calculating next year's new balance.

In all, there are 110 absence codes that are grouped into 55 different categories. In an effort to simplify all of this, I've been asked to identify categories that share common members, with no exceptions. (In other words, if categories AAA, ABB and ACC all contain V and C, and none of them contain anything else, they are exact duplicates.)

By the same token, If V and G are in 5 categories, but a sixth category lacks G, the powers that be would like this noted also.

I'm sure there's a way to get to this answer and still maintain what's left of my sanity (many of you realize that there's little left), but I have not yet landed on it. I thought SQL might get me to the answer most readily, but try as I might I haven't found a workable solution yet; my CTEs quickly get too complex for me to follow. (See prior note on sanity.) Pivot table doesn't seem quite right (though it may help); counts are not definitive enough...

So I thought I'd come to this group; see if you've had a similar situation, and might be willing to share how you arrived at a solution.

Thanks!
--
Sent from my Galaxy tablet phone with with K-9 Mail. Please excuse my brevity.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.