SQL_Kills (3/29/2015)
A0001 still needs to appear as 50 as a Difference for the InjectedDate 2015-03-05 23:19:01.727
To pad a resultset with missing rows required to form a complete set, you can cross join with a subset of all possible codes.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho