Post reply

Calculations not working in a stored procedure

  • September 5, 2008 at 1:31 pm

    #192427

    I have a stored procedure that does a simple calculation based on a case statement.

    When I run the query in the query window the calculation returns the correct value. However, When I execute the stored procedure in the query window the procedure returns a null value

  • September 5, 2008 at 1:39 pm

    #868019

    When the stored procedure is executed is it focused on the same data set as when you use the query window?

    ie.. use mydataset

    exec my sproc

  • September 5, 2008 at 1:39 pm

    #868020

    Post the code and sample data so we don't have to guess at this problem.

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

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