You must Sign In to post a response.
  • Category: SQL Server

    Sql function for calulcating cost*no of units

    i want 2 calculate products price.. by input cost * no of units and call the same in textbox..
  • #684202
    Hi,

    You can do the calculation inside stored procedure. Please check below sample code. You just need to use this logic inside your stored procedure.


    declare @ItemPrice numeric(15,2)
    declare @Unit numeric(15,2)
    declare @TotalPrice numeric(15,2)
    SET @TotalPrice = @ItemPrice * @Unit


    Please let me know if you are not able to proceed further or require any help in this regard.


    Regards,
    Asheej T K


  • This thread is locked for new responses. Please post your comments and questions as a separate thread.
    If required, refer to the URL of this page in your new post.