Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1234

Need help in SQL Query Expand / Collapse
Author
Message
Posted Friday, October 11, 2013 2:09 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:45 AM
Points: 7,102, Visits: 6,933
Yes I think that is the essence of it. You need a way to group the groups, either fixed within the query like Nevyn posted or alter the design (if possible) to cater for it.


Far away is close at hand in the images of elsewhere.

Anon.

Post #1503910
Posted Friday, October 11, 2013 6:41 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 12:03 PM
Points: 621, Visits: 2,127
vigneshlagoons 51204 (10/10/2013)
So table design issue because of bringing the group values on top of CCSG Group?


Yes, there is a hierarchical relationship within your groups, and it is not in your database design. So if your boss came to you and told you one of the subgroups was no longer part of CCSG group, or a new group was created that was, you'd have to change every query/program written around that instead of just updating the records.
Post #1503981
Posted Friday, October 11, 2013 7:01 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Sunday, December 8, 2013 10:34 PM
Points: 33, Visits: 151
Yeah Nevyn,

Should have to consider you told. Its like we hardcore the group values and when changes are needed, its going to be really tedious.
Post #1503989
Posted Thursday, October 17, 2013 5:05 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Sunday, December 8, 2013 10:34 PM
Points: 33, Visits: 151
Hi,

Thanks to all who helped me through this.
Post #1505602
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse