Professional Web Applications Themes

Grouping....SQL Server or VB Code? - Microsoft SQL / MS SQL Server

I have a grouping question... I have two tables - State and Region. They are related by the regionID I have a VB form that has a dropdown box. I would like to have the region and state listed in the box like so: Region1 -State ... -State Region2 - State ... - State Region3 - State ... - State and so on.... Is there a SQL function that will display this or is this something I will need to do with the code to walk through the returned data and format it this way?? Thanks in advance... ----- CR ...

  1. #1

    Default Grouping....SQL Server or VB Code?

    I have a grouping question...

    I have two tables - State and Region. They are related by the regionID

    I have a VB form that has a dropdown box. I would like to have the
    region and state listed in the box like so:

    Region1
    -State
    ...
    -State
    Region2
    - State
    ...
    - State
    Region3
    - State
    ...
    - State

    and so on....

    Is there a SQL function that will display this or is this something I
    will need to do with the code to walk through the returned data and
    format it this way??

    Thanks in advance...
    -----
    CR Douglas
    hpjunglecat at yahoo dot com

    *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
    Don't just participate in USENET...get rewarded for it!
    CR Douglas Guest

  2. #2

    Default Re: Grouping....SQL Server or VB Code?

    There is no SQL function to do this, but you can write some code that will
    give you the data in this format. Essentially you require an hierarchical
    display of sorts and the SQL Server BOL has an example (search for Expanding
    Hierarchies). You can also write a code based around a cursor and a
    temporary table (since your levels are restricted to only 2).
    --
    HTH,
    SriSamp
    Please reply to the whole group only!
    [url]http://www32.brinkster.com/srisamp[/url]

    "CR Douglas" <hpjunglecat> wrote in message
    news:uZzB57eQDHA.3020TK2MSFTNGP10.phx.gbl...
    > I have a grouping question...
    >
    > I have two tables - State and Region. They are related by the regionID
    >
    > I have a VB form that has a dropdown box. I would like to have the
    > region and state listed in the box like so:
    >
    > Region1
    > -State
    > ...
    > -State
    > Region2
    > - State
    > ...
    > - State
    > Region3
    > - State
    > ...
    > - State
    >
    > and so on....
    >
    > Is there a SQL function that will display this or is this something I
    > will need to do with the code to walk through the returned data and
    > format it this way??
    >
    > Thanks in advance...
    > -----
    > CR Douglas
    > hpjunglecat at yahoo dot com
    >
    > *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
    > Don't just participate in USENET...get rewarded for it!

    SriSamp Guest

Similar Threads

  1. Server Clusters: Can i Use Same Code?
    By mike2277 in forum Coldfusion Server Administration
    Replies: 2
    Last Post: December 9th, 08:07 PM
  2. CFM 5.0 code with Coldfusion server 7.0
    By Raymond McCague in forum Coldfusion - Getting Started
    Replies: 6
    Last Post: October 21st, 11:46 PM
  3. Check another server's certficate from asp.net Code behind
    By Wardeaux in forum ASP.NET Security
    Replies: 1
    Last Post: April 15th, 04:09 AM
  4. baner code /ad server/
    By Tomek Niedzielski in forum Macromedia Flash
    Replies: 0
    Last Post: July 21st, 08:11 AM
  5. Grouping in SQL server 7.0
    By Guy Brown in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: July 7th, 09:35 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139