Vikash Kumar

Vikash Kumar

  • 1.2k
  • 436
  • 3.5k

Stored Procedure to divide two columns and store the result

Mar 6 2017 12:24 AM
Hi I am looking fto create a stored procedure in mssql which divides two column values and stores the result in another. Can we use cursor?
Table should look like 
Basic pay(monthly)   Number of days Basics per day
5000                             30                        166
So the data type here should be int
 Any help would be really appreciated 

Answers (8)