var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: sql query for..
I need a late entry report query
For a Particular employee
For a given month
For in time and out time every day i.e. Minimum & Maximum time of entry
ETY_EMPNO - Employee Number
ETY_EVENTDATE - Date of Entry
ETY_INTIME - In Date & Time
ETY_OUTTIME -Out Date & Time
could anyone sort out this problem for me?
Smells like homework to me.
Have you read the section on aggregate queries in Books Online and reviewed the MIN() and MAX() functions?