Post reply

How do i save collections in SQL

  • September 30, 2010 at 2:36 am

    #239070

    hi friends,

    in my previouse post, i have asked how to split csv with mutple columsn and rows and returna table ... but i dont think the thread is clear enough to understand the situation:

    in attachment contain the relationship between Question, QuestionAnswers and Answer entities,

    When i save a question along with i have save N number of answers and whne save a question i have to save data to two other tables, ANswers and QuestionAnswers

    So with the question i pass a colleciton of answers thsi collection will be sent to the sp as a csv, so my collection would like this:

    q_text - 'which numbers make 4?'

    Answers collection:

    '1, 1', f, 1

    '2, 2', t, 1

    '1, 2', f, 1

    '3, 2', t, 1

    PS: second and third values in a row, is the is_corrent and is_active for the table QuestionAnswers also note that the first value IS IN single quotes.

    so i do i extract these csv values to save in a ANswers and QuestionAnswers along with Questions?

    thanks

  • September 30, 2010 at 9:09 am

    #1229690

    Whats wrong with having it persisted to a file, bulk inserting it in the Stored Procedure to a temp./staging table and then copying them to any relevant tables?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply