Post reply

Parameter value resetting problem

  • June 10, 2010 at 3:27 am

    #233628

    Hi Everyone,

    I have a stored procedure that has one parameter and set the value as 100 for that. I don't want to change the stored procedure but i need the value to be changed.

    If i pass parameter as 11 it is resetting as 100.But i need the value whichever i pass as parameter to storedprocedure that is 11

    If possible please advise.

    create procedure test1

    @P numeric

    as

    BEGIN

    IF @P< 100

    BEGIN

    SET @P= 100

    END

    print @P

    END

    declare @p numeric

    set @p = 11

    print @p

    exec test1 @p

    Thanks in advance

    Madhuri

  • June 10, 2010 at 3:44 am

    #1178515

    Inside the proc you are checking if parameter value is less than 100 and setting it to 100 if the parameter is less than 100.

    Take away that checking.

    "Keep Trying"

  • June 10, 2010 at 4:03 am

    #1178521

    Thanks for your reply. I had already mentioned in my earlier mail that without changing the stored procedure I need the solution.

    Please help

  • June 10, 2010 at 4:21 am

    #1178528

    Sorry i missed that part in your original post. I have no idea about this.

    "Keep Trying"

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

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