Professional Web Applications Themes

how to pass in list and insert them one by one - Microsoft SQL / MS SQL Server

Hi, I have a parameter that pass in list to store procedure, for example, '21, 34, 254,3e3' how am I able to split it and insert one by one to a table . column 1 and 3 are hardcoded value. 1567, 21 , 0 1567, 34, 0 1567, 254, 0 1567, 3e3, 0...

  1. #1

    Default how to pass in list and insert them one by one

    Hi,
    I have a parameter that pass in list to store procedure,

    for example,
    '21, 34, 254,3e3'

    how am I able to split it and insert one by one to a table . column 1 and 3
    are hardcoded value.



    1567, 21 , 0
    1567, 34, 0
    1567, 254, 0
    1567, 3e3, 0


    Mike Guest

  2. #2

    Default Re: how to pass in list and insert them one by one

    Refer to:
    [url]http://www.algonet.se/~sommar/arrays-in-sql.html[/url]

    --
    - Anith
    ( Please reply to newsgroups only )


    Anith Sen Guest

  3. #3

    Default Re: how to pass in list and insert them one by one

    [url]www.aspfaq.com/2248[/url]




    "Mike" <pearl_77hotmail.com> wrote in message
    news:OF81iFZRDHA.2228tk2msftngp13.phx.gbl...
    > Hi,
    > I have a parameter that pass in list to store procedure,
    >
    > for example,
    > '21, 34, 254,3e3'
    >
    > how am I able to split it and insert one by one to a table . column 1 and
    3
    > are hardcoded value.
    >
    >
    >
    > 1567, 21 , 0
    > 1567, 34, 0
    > 1567, 254, 0
    > 1567, 3e3, 0
    >
    >

    Aaron Bertrand - MVP Guest

  4. #4

    Default how to pass in list and insert them one by one

    I have to look at these web sites others have sent you,
    because I have needed to do this as well. In the past, I
    have pd the parameter for commas and run a loop.

    Robert

    >-----Original Message-----
    >Hi,
    > I have a parameter that pass in list to store
    procedure,
    >
    >for example,
    >'21, 34, 254,3e3'
    >
    >how am I able to split it and insert one by one to a
    table . column 1 and 3
    >are hardcoded value.
    >
    >
    >
    >1567, 21 , 0
    >1567, 34, 0
    >1567, 254, 0
    >1567, 3e3, 0
    >
    >
    >.
    >
    Robert Taylor Guest

Similar Threads

  1. How to pass complex list to web service
    By hgtraining in forum Macromedia Flex General Discussion
    Replies: 1
    Last Post: April 29th, 12:51 AM
  2. MM:Insert and AutoPostback Drop Down List
    By cayetanob in forum Dreamweaver AppDev
    Replies: 2
    Last Post: April 17th, 03:45 PM
  3. Insert Record and pass url variables
    By brianevans5179 in forum Dreamweaver AppDev
    Replies: 6
    Last Post: March 30th, 01:46 PM
  4. Insert record - choose table from list?
    By btn in forum Dreamweaver AppDev
    Replies: 0
    Last Post: March 21st, 11:24 PM
  5. Replies: 3
    Last Post: September 30th, 09:24 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