Viewing post 1 (of 1 total)
Here's one way you could rewrite your code, using drew.allen's unpivot query. Takes about 30ms on my server.
select empid, apr, may, jun, jul, aug, sep, oct, nov, [dec], jan,...
August 6, 2010 at 4:03 pm
#1203812