Monday, March 19, 2012

details about finetuning queries

table1: In timings history
EMPID pk INTIME EFFECTIVE_DATE END_DATE
ENTERED_BY
tabl2 intiming
EMPID pk INTIME EFFECTIVE_DATE END_DATE enteredby
ta3
emptimings
ENTRYTIME pk EMPID TIMETYPE INOUT IP_ADDRESS
i want to calculate emp salary after deducting leaves and break timings
and other cuttingsddl means
CREATE TABLE TABLENAME ETC
SAMPLE DATA MEANS : insert into
--
Regards
R.D
--Knowledge gets doubled when shared
"raghu veer" wrote:

> table1: In timings history
> EMPID pk INTIME EFFECTIVE_DATE END_DATE
> ENTERED_BY
> tabl2 intiming
> EMPID pk INTIME EFFECTIVE_DATE END_DATE enteredby
> ta3
> emptimings
> ENTRYTIME pk EMPID TIMETYPE INOUT IP_ADDRESS
>
> i want to calculate emp salary after deducting leaves and break timings
> and other cuttings
>
>

No comments:

Post a Comment