Vikash Kumar

Vikash Kumar

  • NA
  • 959
  • 21.1k

Stored Procedure to divide two columns and store the result

Mar 6 2017 12:24 AM
Hi,
 
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 
 
Employee
 
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)