Prev: partition wizard
Next: Help with query for consecutive years
From: Victor Schrader on 27 May 2010 01:08
I should have said:

select p.* from pjproj p
where not exists (
select j.* from pjproj j, pjprog q
where j.project = q.project and
j.project in ('L%', 'C%', '08%', '09%', '10%', '11%', '01PM%', '05PM%'))

The beauty of this it is:
a) cross platform (sql95 and not MS specific)
b) the self join stuff will get optimized away
c) it derives exactly what you are asking for, ie., the not of some set of situations

---
frmsrcurl: http://msgroups.net/microsoft.public.sqlserver.programming/Help-with-Query,3
First  |  Prev  | 
Pages: 1 2
Prev: partition wizard
Next: Help with query for consecutive years