Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New Coder
    Join Date
    May 2007
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Question 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.

  • #2
    teh Moderatorinator
    Join Date
    Sep 2004
    Location
    USA
    Posts
    2,472
    Thanks
    4
    Thanked 40 Times in 40 Posts
    Moving to MSSQL forum.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •