Dieser SELECT ist nur für mein Archiv gedacht:
DECLARE @startdate AS DATETIME
DECLARE @enddate AS DATETIME
SET @startdate='01.07.2008'
SET @enddate='30.07.2008'
SELECT * FROM(
SELECT Locator.stadt, Locator.stobez, DevProject.BUM1ID, b.*, c.*, locator.AKTIVVON, locator.AKTIVBIS, d.*
FROM DevProject
INNER JOIN DevProjectLocation ON DevProjectLocation.DevProjectGUID = DevProject.GUID
INNER JOIN Locator ON Locator.GUID = DevProjectLocation.LocatorGUID
LEFT outer join
(
SELECT min(V_Version_History.LastEditDate) AS DateContractSigned, Locator_History.GUID AS GUID1
FROM Locator_History, V_Version_History
WHERE V_Version_History.VersionGuid=locator_history.VersionGuid
AND Locator_History.status=255
GROUP BY Locator_History.GUID
) b ON Locator.Guid=b.Guid1
LEFT outer join
(
SELECT min(V_Version_History.LastEditDate) AS DatePublished, Locator_History.GUID AS GUID2
FROM Locator_History, V_Version_History
WHERE V_Version_History.VersionGuid=locator_history.VersionGuid
AND (Locator_History.status=243 OR Locator_History.status=244)
GROUP BY Locator_History.GUID
) c ON Locator.Guid=c.Guid2
LEFT outer join
(
SELECT min(V_Version.LastEditDate) AS DatePublished2, Locator.GUID AS GUID3
FROM Locator, V_Version
WHERE V_Version.Guid=locator.Guid
AND (Locator.status=243 OR Locator.status=244)
GROUP BY Locator.GUID
) d ON Locator.Guid=d.Guid3
LEFT OUTER JOIN office ON office.ID=Locator.Office
LEFT OUTER JOIN Company ON office.companyID=company.ID
WHERE Locator.stadt=Locator.stadt AND ( locator.land=1)
) AS source
WHERE
(DatePublished IS not NULL AND DatePublished>=@startdate AND DatePublished<@enddate)
OR
(DatePublished is NULL AND DatePublished2>=@startdate AND DatePublished2<@enddate)