Torna al Thread

SELECT TOP 5 Documents.Title, Documents.AutoDate, Projects.Name AS Project, Documents.ID FROM [Documents],[Projects] WHERE (Documents.Groups in (SELECT CStr(IDProject) FROM [Members] WHERE (IDuser = " + userID + ") AND (IDProject in (SELECT ID FROM [Projects] WHERE (typ<>4 AND typ<>1) )) ) AND Documents.Groups = CStr(Projects.ID) AND Documents.Status < 3 AND (DateDiff('m', (Documents.Autodate), (now)) <= 6 )) ORDER BY Documents.AutoDate DESC
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5