| Member | | Join Date: Jun 2007
Posts: 123
| |
When I run this query in my sql query prompt, it comes out with the correct results, but when I but it into the VBA prompt for my excel program, it doesn't display the correct results.
Any ideas? -
SELECT dbo.Defects.DefectId, dbo.Defects.Name, dbo.WorkflowSteps.StepName, dbo.PriorityTypes.Name AS PriorityName, dbo.SeverityTypes.Name AS Severity, dbo.Defects.BuildNumber, dbo.DefectCustomFields.Custom_86 AS TargetBuildNumber, dbo.Defects.BuildNumberOfFix, CONVERT(varchar(20), dbo.Users.FirstName) + ' ' + CONVERT(varchar(20), dbo.Users.LastName) as Creator, CONVERT(varchar(20), Users_1.FirstName) + ' ' + CONVERT(varchar(20), Users_1.LastName) AS AssignedUser, dbo.Projects.Name AS ProjectName
-
-
FROM dbo.Projects INNER JOIN
-
dbo.Defects ON dbo.Projects.ProjectId = dbo.Defects.ProjectId INNER JOIN
-
dbo.Users ON dbo.Defects.CreatorId = dbo.Users.UserId INNER Join dbo.PriorityTypes ON dbo.Defects.PriorityTypeId = dbo.PriorityTypes.PriorityTypeId INNER JOIN
-
dbo.SeverityTypes ON dbo.Defects.SeverityTypeId = dbo.SeverityTypes.SeverityTypeId INNER JOIN
-
dbo.StatusTypes ON dbo.Defects.StatusTypeId = dbo.StatusTypes.StatusTypeId INNER JOIN
-
dbo.WorkflowSteps ON dbo.Defects.WorkflowStepId = dbo.WorkflowSteps.WorkflowStepId INNER JOIN
-
dbo.DefectCustomFields ON dbo.Defects.DefectId = dbo.DefectCustomFields.DefectId LEFT OUTER JOIN
-
dbo.Users AS Users_1 ON dbo.Defects.AssignedToId = Users_1.UserId
-
-
WHERE (dbo.Defects.StatusTypeId IN (9, 10, 1, 11, 2, 3, 8)) AND (dbo.Projects.ProjectId IN (" + projIds + ")) AND(dbo.Defects.DefectId NOT IN
-
-
(SELECT dbo.defects.DefectId
-
FROM dbo.Defects AS Defects_1
-
WHERE (dbo.defects.LastUpdatedDateTime < '" + DefectClosedFilterDate + "') AND (dbo.defects.StatusTypeId = 8) AND (Defects.ProjectId IN (" + projIds + "))))
-
-
ORDER BY dbo.WorkflowSteps.StepName, dbo.PriorityTypes.Name, dbo.Defects.DefectId DESC
-
|
