Professional Web Applications Themes

Insert data to crossib qurey - Microsoft SQL / MS SQL Server

Hi If your data is in a SQL Server database, you would enter the data into each table separately. To produce a crosstab query check out the following article and links. You may also want to check out google. http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&selm=%23GZCh7fTBHA.224%40tkmsftngp07 John "Roy Goldhammer" <net.il> wrote in message news:phx.gbl... ...

  1. #1

    Default Re: Insert data to crossib qurey

    Hi

    If your data is in a SQL Server database, you would enter the data into each
    table separately. To produce a crosstab query check out the following
    article and links. You may also want to check out google.

    http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&selm=%23GZCh7fTBHA.224%40tkmsftngp07

    John

    "Roy Goldhammer" <net.il> wrote in message
    news:phx.gbl... 


    John Guest

  2. #2

    Default Re: Insert data to crossib qurey

    Hi

    How you convert the data from your interface to SQL queries that can be
    executed against the database is really depending on what you have written
    the interface in. It is best not to pass arrays (or other representations of
    such) to stored procedures.


    John


    "Roy Goldhammer" <net.il> wrote in message
    news:phx.gbl... 
    store 
    > each 
    >[/ref]
    http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&selm=%23GZCh7fTBHA.224%40 [/ref][/ref]
    other) [/ref]
    > crossib 
    > >
    > >[/ref]
    >
    >[/ref]


    John Guest

  3. #3

    Default Insert data to crossib qurey

    Hello there

    I have a query that i need to enter to table

    The query is crossib (Pivot)

    and the data should enter for two tables: tbl1(ID - primary key, other)
    tbl2(ID- Foreign Key from from tbl1, ColName - the columns on the crossib
    query) both of them are Primary key and data

    How can i enter this type of data witn Transact Sql?

    Any help would be useful



    Roy Guest

  4. #4

    Default Re: Insert data to crossib qurey

    Well John

    I don't know if i explain my self clear before

    I have a case that i need to present the data in crossib mode and then store
    it in table

    There fore i can't use one table so i need two tables like the example i
    gave you

    The question is how can i store the data on the two tables in this case?

    From my knowladge i can only do this with cursors which is as i learn
    somthing that don't suggested at all

    can you help me on it? i
    "John Bell" <com> wrote in message
    news:3f47cb17$0$10770$easynet.co.uk... 
    each 
    http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&selm=%23GZCh7fTBHA.224%40
    tkmsftngp07 [/ref]
    crossib 
    >
    >[/ref]


    Roy Guest

Similar Threads

  1. Question Insert from ASP to SQL using recordset data as values in insert statement
    By JasonM in forum Microsoft SQL / MS SQL Server
    Replies: 0
    Last Post: June 13th, 05:54 PM
  2. Insert Dynamic Data
    By stevet540 in forum Macromedia Dynamic HTML
    Replies: 2
    Last Post: March 18th, 05:02 PM
  3. how to insert data into database
    By newincf in forum Coldfusion - Getting Started
    Replies: 2
    Last Post: September 22nd, 02:51 PM
  4. Can't Insert Data
    By entoone in forum PHP Development
    Replies: 9
    Last Post: January 27th, 09:14 PM
  5. INSERT DATA
    By RAW in forum ASP.NET General
    Replies: 0
    Last Post: June 30th, 04:24 AM

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