Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Location
    Eternity
    Posts
    31

    Unanswered: Help required for a query

    Hi All..
    Iam looking for a query to satisfy the below requirements.

    Table Data

    Territory Channel From To
    US DVD 18-12-2005 17-12-2009
    Canada DVD 18-12-2005 17-12-2009
    Mexico DVD 18-12-2005 17-12-2009
    US Cable 18-12-2005 17-12-2009
    Canada Cable 18-12-2005 17-12-2009
    Mexico Cable 18-12-2005 17-12-2009
    Germany Cable 14-01-2006 13-01-2010
    England Cable 14-01-2006 13-01-2010
    Italy Cable 14-01-2006 13-01-2010

    Expected Output

    Territory Rights From To
    US,Canada,Mexico DVD,Cable 18-12-2005 17-12-2009
    Germany,England,Italy Cable 14-01-2006 13-01-2010

    Please let me know if someone can offer any help regarding this.
    The above table and the output is present in the attached doc too.

    Thanx in advance.
    Vijay
    Attached Files Attached Files
    Obviousness is the enemy of Correctness
    --Bertand Russel

  2. #2
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    Do a search for stragg on google.

    Alan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •