Post reply

stored procedure parameter issue

  • April 21, 2016 at 9:42 am

    #315897

    Please see the attachement.

    how to write a Stored Procedure as per the attachment to pass parameter as ADDR_TYPE_CD as ‘D’ and get parameterAs ADDR_TYPE_NAME

    (The expected values are ‘Building Address’)

  • April 21, 2016 at 10:00 am

    #1873702

    This is a pretty simple task if I'm reading your requirements correctly. Before we all do the work for you, can you show us what you've tried and the challenges your facing with your approach?

    John Rowan

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

  • April 21, 2016 at 10:04 am

    #1873706

    John Rowan (4/21/2016)

    This is a pretty simple task if I'm reading your requirements correctly. Before we all do the work for you, can you show us what you've tried and the challenges your facing with your approach?

    +1

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

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

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