<div>
Do you have an employee table?<br />
If so, you can run a correlated subquery checking the employee id table and then checking the tracking tbale where the emplyeed ID not exist.<br />
&nbsp;<br />
&nbsp;<br />
&nbsp;<br />

</div>


Do you have an employee table?
If so, you can run a correlated subquery checking the employee id table and then checking the tracking tbale where the emplyeed ID not exist.
 
 
 


<div>
emp table - yes<br />
<br />
so....<br />
<br />
select * from EmpTable, TrackingTable<br />
<br />
where EmpTable.EmpID = TrackingTable.EmpID<br />
<br />
(INSERT SUBQUERY HERE?)<br />
<br />
<br />
suggestions?<br />

</div>


emp table - yes

so....

select * from EmpTable, TrackingTable

where EmpTable.EmpID = TrackingTable.EmpID

(INSERT SUBQUERY HERE?)


suggestions?


<div>
<div class="content wysiwyg-content">
im trying to create a query/report that will generate a report detailing all the employees who forgot to enter their time on friday<br />
<br />
my thought was ... <br />
<br />
&lt;pseduocode&gt;<br />
&quot;select * from tracking table where hours IS NULL and (TrackDate &gt;= '04/06/2009') AND (TrackDate &lt;= '04/10/2009')&quot;<br />
&lt;/pseduocode&gt;<br />
<br />
but if they didnt enter any data then there is no record of them anyway.<br />
<br />
how do i need to construct my logic to get the data i need? <br />
<br />
two queries : one that says who DID enter time and then compare a list of the total employees<br />
<br />
any assistance is appreciated.<br />
<br />
thx<br />
<br />
<br />
<br />

</div>
</div>


im trying to create a query/report that will generate a report detailing all the employees who forgot to enter their time on friday

my thought was ... 

<pseduocode>
"select * from tracking table where hours IS NULL and (TrackDate >= '04/06/2009') AND (TrackDate <= '04/10/2009')"
</pseduocode>

but if they didnt enter any data then there is no record of them anyway.

how do i need to construct my logic to get the data i need? 

two queries : one that says who DID enter time and then compare a list of the total employees

any assistance is appreciated.

thx





employee exception report in SQL

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.