CodingForums.com - View Single Post

cloudy · 06-05-2007, 05:57 AM

hi, i dont know this is the right place to let me ask the problem about the database script or not.
if wrong, plz inform me.
i wan to write a store procedure to check the balance leave of the user when end of year.
if end of year then
if balanceleave>4days then
newbalance=totalannual+4days
else
newbalance=totalannual+balanceleave(old)
end if
i have one table is store the user
totalannualleave, balanceanual leave, empid, leaverecordid (PK)
i m first time user to use the store proc,so i duno how to start it.the store proc will run when the date is 31/12 every year(midnite)
can u all guide me?
thank you.

06-05-2007, 05:57 AM	PM User \| #1
cloudy New Coder Join Date: May 2007 Posts: 94 Thanks: 0 Thanked 0 Times in 0 Posts	Ms Sql Server Store Procedure hi, i dont know this is the right place to let me ask the problem about the database script or not. if wrong, plz inform me. i wan to write a store procedure to check the balance leave of the user when end of year. if end of year then if balanceleave>4days then newbalance=totalannual+4days else newbalance=totalannual+balanceleave(old) end if i have one table is store the user totalannualleave, balanceanual leave, empid, leaverecordid (PK) i m first time user to use the store proc,so i duno how to start it.the store proc will run when the date is 31/12 every year(midnite) can u all guide me? thank you.