View Full Version : Ms Sql Server Store Procedure

06-05-2007, 06: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.

06-05-2007, 06:33 PM
Moving to MSSQL forum.