111 reputation
15
bio website strifestreams.com
location United Kingdom
age 32
visits member for 3 years, 2 months
seen Aug 1 '13 at 15:48

Dec
18
awarded  Notable Question
Feb
27
awarded  Popular Question
Oct
13
awarded  Scholar
Oct
13
accepted Using multiple PIVOTs JOINs and GROUP BYs for advanced report generation
Oct
13
answered Using multiple PIVOTs JOINs and GROUP BYs for advanced report generation
Oct
11
awarded  Student
Oct
11
comment Using multiple PIVOTs JOINs and GROUP BYs for advanced report generation
@Mark-Storey-Smith Yes good call - I've completely re-written the question to focus purely on the issue and attached a ZIP containing all the SQL to re-create the issues shown above.
Oct
11
awarded  Editor
Oct
11
revised Using multiple PIVOTs JOINs and GROUP BYs for advanced report generation
Rewrote the whole question to make it easier to understand
Oct
11
comment Using multiple PIVOTs JOINs and GROUP BYs for advanced report generation
@Catcall It would look like the first output screenshot I've listed, which shows the total minutes of each DutyCategoryId grouped by UserId, RoleId, GeographyId and CategoryId - but with additional columns listing whether or not that group of timesheets had a value for each AttrituteId recorded against it (A boolean flag for each possible AttributeId
Oct
10
asked Using multiple PIVOTs JOINs and GROUP BYs for advanced report generation
Jan
21
awarded  Quorum