i have a table called emp-leave_balanced(leave-id,leave balance,etc are column),in leave balance column each employee has some leave balance (like 4,5,8 etc)i need to add this leave-balance to another column(that also have common value like 25) i need to update this new column based on system time at the end of 31st December at 12.00am.>>>>>

ok so how will i update the new column that column already have value 24 and all employee have some leave balance how to add all this can u tell me for one or two leavebalance some pseudo code example

Ads

View Answers

Post Answer

Preview:

Related Tutorials/Questions & Answers:

leave balance
called emp-leave_balanced(leave-id,leavebalance,etc are column),in leavebalance column each employee has some leavebalance (like 4,5,8 etc)i need to add this leave-balance to another column(that also have common value like 25) i need

Show Balance
, and subtract the second number
from it showing the balance... JOptionPane comeup just fine... and subtract num2 from num1
and show the remaining balance.... any help

Advertisements

to renew leave to next month
to renew leave to next month i need to make a project where an employee must be able to apply leave only once in a month, and if he doesn't use that leave in that particular month, it must be renewed to the next month so that he

Flow Control Constructs
,
REPEAT and LEAVE constructs. They are fully implemented.
These constructs can... and usually that can be done with a LEAVE Statement.
The LOOP Statement can be labeled also.
LEAVE Statement
The general syntax of LEAVE Statement is :
LEAVE

updating column automatically based on system date
,leavebalance,etc are column),in leavebalance column each employee has some leavebalance (like 4,5,8 etc)i need to add this leave-balance to another column...:
update leave_balance set newcolumn=leavebalance;
You can also run the program

Ayurveda for Healthy Living
by the body type and the mind body balance. The medicines of Ayurveda are made from..., maintaining the balance between three doshas matters to a great extent

question
question good morning ,
select * from leavetable where leave_type in ('Sick Leave(SL)','Half Day Leave(HL)','Leave(L)') and currentdate='curdate()'
what is the wrong in this ,it returned zero rows but have row like :
leave

question
question Good Afternoon,
code to display the employees on leave,and approve that leave for manager.using JPanel+mysql+Java

java program
; withdraw. The deposit method would accept attributes amount & balance & returns the new balance which is the sum of amount & balance. Similarly, the withdraw method would accept the attributes amount & balance & returns

java code
. The deposit method would accept attributes amount & balance & returns the new balance which is the sum of amount & balance. Similarly, the withdraw method would accept the attributes amount & balance & returns the new

question
,but that retuned zero rows selected
select * from leavetable where leave_type in ('Sick Leave(SL)','Half Day Leave(HL)','Leave(L)') and currentdate='curdate()'
but have one row in leavetable like-
Leave(L) 100 John 2011-06-28
i

question
,but that retuned zero rows selected
select * from leavetable where leave_type in ('Sick Leave(SL)','Half Day Leave(HL)','Leave(L)') and currentdate='curdate()'
but have one row in leavetable like-
Leave(L) 100 John 2011-06-28
i

java - Java Beginners
name
Bal Stores balance amount in the account... getValues() To modify balance according...()
deposit() To modify balance according to the amount

ATM Java Code - Java Beginners
can insert name, account number, current balance,transaction type,
2)if select transaction is money deposit, the value will be input and current balance... and current balance

question
question i need a jsp/html program which includes drop down menu for leave types and a button for apply leave.and need another jsp to validate types of leave and then insert in to data base using mysql

c++ program of inheritancebalance and if the balance falls below this level, a service charge is imposed.
Create... the following tasks:
(a) Accept deposit from a costumer and update the balance.
(b) Display the balance
(c) Compute and deposit interest.
(d) Permit

java - IDE Questions
,TOTFEES,BALANCE.
i am saving this details in FEES table.
Another Frame i have... , i should get the new balance .
i am saving this details in installment table , but whenever i am opening the installment frame, in balance field it is showing