Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Washington DC area

    Angry Unanswered: update statement for sp

    I have a table that needs to be edited based on 2 input parameters in the table. This is what I've come up with so far. Please tell me if I'm on the right track.

    update g.pbd
    set pbd_number = x, pbd_title = y
    (select pbd_id
    from g.pbd)
    where pbd_number = pbd_number and pbd_title = pbd_title;


  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    >I'm on the right track.
    from where in the world did the "g." come out of the blue?
    >select pbd_id
    please explain why you are selecting this field?
    >set pbd_number = x, pbd_title = y
    How/where to "x" & "y" get defined or any value?
    Rather than doing...
    Ready, Fire, Aim
    Please try to RTFM
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts