Post reply

Calling stored proc to insert record in one table

  • November 3, 2008 at 3:28 pm

    #893307

    MrBaseball34 (11/3/2008)

    what do you mean here:

    SELECT .......... UNION ALL

    SELECT .......... UNION ALL

    SELECT ...........

    I don't know what to put as the ...........

    I'm asking for you to take the effort in creating some test data so we can work your problem out. I probably should have started the thread out with asking for it, but I didn't so here we are. What I posted there (quoted above) was just an example of how to use SELECT...UNION ALL to put some rows into a test table. Here's the forum ettiquite thread for reference:

    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • November 3, 2008 at 6:16 pm

    #893355

    Have you thought about using union query?

  • November 4, 2008 at 9:05 am

    #893688

    I know about the posting etiquette thread but with this much data I felt it was too much trouble.

    We have decided to do this using our business/data objects in VB.Net. I really should have thought to do it that way before but, alas, I didn't.

    I really thank all of you for the help and guidance.

  • November 4, 2008 at 9:40 am

    #893711

    One thing to remember, when we ask for sample data, we aren't asking you to provide the entire data set. We just need enough data to test what we are working on to see if it work based on your expected results.

    For people who have regulations such as HIPPA, FERPA (that's mine), etc, then you take real data, and mung it. Disney characters are popular for names; ssn's become random numbers in ssn format; etc.

    John just wanted a few records that got processed, and a few records that didn't so he could compare them to see if he could see why the didn't process.

Viewing 4 posts - 31 through 33 (of 33 total)

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