Viewing 4 posts - 1 through 4 (of 4 total)
Thank you for clerifying the JOIN issue. I do recall studying that the method of creating joins had changed recently but I'd never worked with the old code before....
November 9, 2010 at 5:41 pm
Thank you to all that have defended me from the high handedness. ? However, I think Celko does have a point and I appreciate his intentions if not the methods....
November 9, 2010 at 8:00 am
That worked perfectly. Thank you both!
November 4, 2010 at 10:05 am
THanks ... ok then this
SELECT Projects.ProjName, (Employees.EmpName) AS EmpName, SUM([Employees Project Log].Hrs) AS TotalHrs
, RANK() OVER
(PARTITION BY Projects.ProjName ORDER BY SUM([Employees...
November 4, 2010 at 9:39 am
Viewing 4 posts - 1 through 4 (of 4 total)