Professional Web Applications Themes

Is there "subform" in SQL 2000??? - Microsoft SQL / MS SQL Server

I have 3 tables in many to many relationship. Table1, Table2, Table3. Table1: ID: Name: State: 1 User1 CA 2 User2 FL 3 User3 NC Table2: (many-to-many table) ID: Name: OptionID: 1 User1 Option1 2 User1 Option2 3 User1 Option3 4 User1 Option4 5 User2 Option2 6 User2 Option3 7 User2 Option4 8 User3 Option1 9 User3 Option4 Table3: OptionID: Option1 Option2 Option3 Option4 I would some help writing a query that would return something like this. User1 Option1 Option2 Option3 Option4 USer2 NA Option2 Option3 Option4 User3 Option1 NA NA Option4 When i do this kind of output, i ...

  1. #1

    Default Is there "subform" in SQL 2000???

    I have 3 tables in many to many relationship. Table1,
    Table2, Table3.


    Table1:
    ID: Name: State:
    1 User1 CA
    2 User2 FL
    3 User3 NC


    Table2: (many-to-many table)
    ID: Name: OptionID:
    1 User1 Option1
    2 User1 Option2
    3 User1 Option3
    4 User1 Option4
    5 User2 Option2
    6 User2 Option3
    7 User2 Option4
    8 User3 Option1
    9 User3 Option4



    Table3:
    OptionID:
    Option1
    Option2
    Option3
    Option4

    I would some help writing a query that would return
    something like this.


    User1 Option1 Option2 Option3 Option4
    USer2 NA Option2 Option3 Option4
    User3 Option1 NA NA Option4

    When i do this kind of output, i can use soemthing
    called "subforms" in the Access database, is there
    soemthign like that in SQL???

    Thanks in Advance

    Jhoon Guest

  2. #2

    Default Re: Is there "subform" in SQL 2000???


    Here are some urls for cross-tab/pivoting.

    1. http://www.ag-software.com/

    2. http://support.microsoft.com/default.aspx?scid=kb;EN-US;q175574

    3. http://www.sqlmag.com/Articles/Index.cfm?ArticleID=15608
    http://www.sqlteam.com/item.asp?ItemID=2955


    --
    -oj
    RAC v2.2 & QALite!
    http://www.rac4sql.net



    "Jhoon" <com> wrote in message
    news:08b201c350df$2743cdf0$gbl... 


    oj Guest

  3. #3

    Default Re: Is there "subform" in SQL 2000???

    <GGGGGG>

    --
    -oj


    "Greg Obleshchuk" <com> wrote in message
    news:phx.gbl... 

    >
    >[/ref]


    oj Guest

Similar Threads

  1. Using "Find & Replace" w/ Subform
    By Kristen in forum Microsoft Access
    Replies: 0
    Last Post: July 18th, 05:26 PM
  2. Can "Computed Column" be a stored procedure in SQL Server 2000?
    By Bill in forum Microsoft SQL / MS SQL Server
    Replies: 3
    Last Post: July 8th, 06:47 AM
  3. Subform Causes long "Calculating..." in status bar
    By JFrank Brock in forum Microsoft Access
    Replies: 0
    Last Post: June 27th, 03:12 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