Thank You.. However, there are instances where there may be a clock in/out cycle multiple times a day. If employee a clocks in at 8am, out at 9am, then again...

80 i believe. i searched microsoft and they require 90 or higher to use the pivot function, which i can not change.

thanks!! that helps a lot but it also requires me to change the compatibility level of the DB, which i can't really do. is there another alternative?