Stored Procedures for processing Member activation time | Software Development

Create proc procsetopenmonth (@ gcompanyuser varchar (120), @ months INT)
As
Begin
Declare @ poornum int
If exists (select * From hr_openmonth where gcompanyuser = @ gcompanyuser)
Begin
-- If (datediff (D, ststartdate, getdate ()))
Select @ poornum = datediff (D, getdate (), dateadd (M, gopenmonth, ststartdate) from hr_openmonth
If (@ poornum> = 0)
Begin
Update hr_openmonth set ststartdate = getdate (), gopenmonth = @ months + datediff (M, getdate (), dateadd (M, gopenmonth, ststartdate) where gcompanyuser = @ gcompanyuser
End
Else
Begin
Update hr_openmonth set ststartdate = getdate (), gopenmonth = @ months where gcompanyuser = @ gcompanyuser
End
End
Else
Begin
Insert into hr_openmonth (gcompanyuser, ststartdate, gopenmonth) values (@ gcompanyuser, getdate (), @ months)
End
End
Go