Post reply

result

  • March 29, 2007 at 10:01 am

    #172610

    I have veiw that has test id

    and other column selected.

    and

    i have stored procedure that calulate money for individual test id.

    but i want

    to get report which show everything from view along with calcuated field from store procedure.

    how can i do that

    .

  • March 29, 2007 at 10:46 am

    #697687

    Move your stored procedure to a function

    Or write a query to do the calculation and join to the view.

  • March 29, 2007 at 12:50 pm

    #697719

    that way it does not work either. I need to get result in one line fro both view and procedure. Is it possible if i create cursor?

     

    Thanks

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

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