Professional Web Applications Themes

Inserting data from returned results - Microsoft SQL / MS SQL Server

INSERT INTO NewTable (col1, col2, col3) SELECT colA, colB, colC FROM OldTable WHERE ... etc -- David Portas ------------ Please reply only to the newsgroup -- "Shane" <pipex.com> wrote in message news:3f1f8cf0$0$11383$dial.pipex.com...  SQL  VB  enter ...

  1. #1

    Default Re: Inserting data from returned results

    INSERT INTO NewTable (col1, col2, col3)
    SELECT colA, colB, colC
    FROM OldTable
    WHERE ... etc

    --
    David Portas
    ------------
    Please reply only to the newsgroup
    --

    "Shane" <pipex.com> wrote in message
    news:3f1f8cf0$0$11383$dial.pipex.com... 
    SQL 
    VB 
    enter 


    David Guest

  2. #2

    Default Re: Inserting data from returned results

    Check out: http://www32.brinkster.com/srisamp/sqlArticles/article_14.htm and
    http://www32.brinkster.com/srisamp/sqlArticles/article_15.htm. These two
    articles show 2 ways of inserting information into a table from another
    source. The first article uses a SELECT statement as the source and second
    article uses a stored procedure as a source.
    --
    HTH,
    SriSamp
    Please reply to the whole group only!
    http://www32.brinkster.com/srisamp

    "Shane" <pipex.com> wrote in message
    news:3f1f8cf0$0$11383$dial.pipex.com... 
    SQL 
    VB 
    enter 


    SriSamp Guest

  3. #3

    Default Re: Inserting data from returned results

    That's great and really simple to - many thanks for your advice.


    "SriSamp" <co.in> wrote in message
    news:#phx.gbl... 
    and 
    > SQL 
    > VB 
    > enter [/ref]
    an 
    >
    >[/ref]


    Shane Guest

Similar Threads

  1. Altering a results returned to a ASP
    By Stephen in forum ASP Database
    Replies: 3
    Last Post: March 5th, 03:27 PM
  2. Using PHP to Print SELECT Results - Incomplete Data Returned
    By Keith W. McCammon in forum PHP Development
    Replies: 5
    Last Post: November 13th, 07:39 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