Hello,
I have am trying to generate data from a DB which contains lines of code changed per programmer per build.
Table codeChanges has fields:
<filename><build number><programmer><lines of code changed>
I would like to generate output in the format:
<build><total lines changed by programmer1>><lines changed by programmer2>...
I can generate output in the form:
<build><total lines changed by programmer1>
<build><total lines changed by programmer2>
with the query
SELECT codeChanges.build, programmer, Sum(codeChanges.NumberOfLines) FROM codeChanges
GROUP BY codeChanges.build, programmer;
but not with multiple programmers on the same row.
Thanks in advance,
Eric
I have am trying to generate data from a DB which contains lines of code changed per programmer per build.
Table codeChanges has fields:
<filename><build number><programmer><lines of code changed>
I would like to generate output in the format:
<build><total lines changed by programmer1>><lines changed by programmer2>...
I can generate output in the form:
<build><total lines changed by programmer1>
<build><total lines changed by programmer2>
with the query
SELECT codeChanges.build, programmer, Sum(codeChanges.NumberOfLines) FROM codeChanges
GROUP BY codeChanges.build, programmer;
but not with multiple programmers on the same row.
Thanks in advance,
Eric