Need help converting MSSQL proc to MySQL - PayPal$

Discussion in 'OT Technology' started by Supergeek, Jun 22, 2009.

  1. Supergeek

    Supergeek New Member

    Joined:
    Jan 23, 2007
    Messages:
    1,855
    Likes Received:
    0
    Location:
    Colorado
    I'll PayPal $20 to the first person who posts the fixes for this code, and it all actually works and stuff.

    I got this from an MS SQL guy. I'm trying to import it into a MySQL database. I'm sick and tired of this code already, and I am willing to pay someone $20 to look it over and fix it. :confused: I'm not a MySQL expert, and I have no knowledge of MS SQL at all. If you're good at both, it should take you like 5 minutes.

    Would appreciate cliffs on the "SET NOCOUNT ON" bullshit too. My mother used to call me no count, but I don't think it's the same.

    Original version I got from the dude:
    http://pastebin.ca/1469503

    What I've done so far, but some may be wrong:
    http://pastebin.ca/1469497

    This is due tomorrow, so would appreciate help overnight. I'll check back in the morning.
     
  2. Supergeek

    Supergeek New Member

    Joined:
    Jan 23, 2007
    Messages:
    1,855
    Likes Received:
    0
    Location:
    Colorado
    Yes, I realize the irony of someone named "Supergeek" asking for technical help. I epic fail.
     
  3. SLED

    SLED build an idiot proof device and someone else will

    Joined:
    Sep 20, 2001
    Messages:
    28,118
    Likes Received:
    0
    Location:
    AZ, like a bauce!
    no count tells the proc not to create a result set with a "(N Records Effected)" returned. You can prob just take that out for mysql.

    I'll look at your code a little later
     
  4. Supergeek

    Supergeek New Member

    Joined:
    Jan 23, 2007
    Messages:
    1,855
    Likes Received:
    0
    Location:
    Colorado
    We've got someone looking at it now. Thanks anyway.
     
  5. Peyomp

    Peyomp New Member

    Joined:
    Jan 11, 2002
    Messages:
    14,017
    Likes Received:
    0
    I can't imagine slogging through this kind of shit for $20. SQL Server->MySQL shenanigans rank as my most painful technical tasks ever. Then again, I did do it at nearly 10K feet with altitude sickness :)
     
  6. Limp_Brisket

    Limp_Brisket New Member

    Joined:
    Jan 2, 2006
    Messages:
    48,422
    Likes Received:
    0
    Location:
    Utah
    half done!
     

Share This Page