details about finetuning queries  
Author Message
vinayagamenmsol





PostPosted: Tue Oct 04 03:52:04 CDT 2005 Top

SQL Server Developer >> 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 cuttings

SQL Server87  
 
 
RD





PostPosted: Tue Oct 04 03:52:04 CDT 2005 Top

SQL Server Developer >> details about finetuning queries ddl means
CREATE TABLE TABLENAME ETC
SAMPLE DATA MEANS : insert into
--
Regards
R.D
--Knowledge gets doubled when shared




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