View Full Version : Ms Sql Server Store Procedure

Jun 5th, 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
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.

Jun 5th, 2007, 05:33 PM
Moving to MSSQL forum.