Post reply

Need help in SQL Query

  • October 11, 2013 at 2:09 am

    #1657821

    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.

  • October 11, 2013 at 6:41 am

    #1657884

    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.

  • October 11, 2013 at 7:01 am

    #1657890

    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.

  • October 17, 2013 at 5:05 am

    #1659228

    Hi,

    Thanks to all who helped me through this.

Viewing 4 posts - 31 through 33 (of 33 total)

You must be logged in to reply to this topic. Login to reply