Hi everyone , i have an interesting scenario where i need to find something that is not there :)

Sql 2005

i have table called Audits in format id, CELL amd DATECOMPLETE , every time an audit is done in a cell a new line is written to the table as shown below, we have 50 cells and the expectation is that an audit is done every week , if this is true we would see 50 rows added to the table ( id, Cell,DateComplete the datecomplete column is a numeric column in format 201301 where 2013 is the year and 01 is the week )

In reality this is not the case

I can query who has done their audits and the date complete , is it possible to write a query which shows which cell has not completed an audit and thus there is no row written to the table pivoted by DateComplete .... hope this makes sense

1. Do you have a list of cells somewhere, perhaps in another table?2. Is there a specific day of the week that will be entered into the datecomplete column, or can it be any day of the week

The way to write the query would be to first cross join a calendar table and the table that has the list of cells. Then, you would do a left join with the audit table. If you can provide the info I asked for above, I or someone else on the forum can help you with writing the query.