[HELP] About Honor Rank

dbo._TrainingCampHonorRank
1	324	1
2	328	1
3	327	1
4	326	1
5	335	1
6	NULL	NULL
7	NULL	NULL
8	NULL	NULL
9	NULL	NULL
10	NULL	NULL
11	NULL	NULL
12	NULL	NULL
13	NULL	NULL
14	NULL	NULL
15	NULL	NULL
16	NULL	NULL
17	NULL	NULL
18	NULL	NULL
19	NULL	NULL
20	NULL	NULL
21	NULL	NULL
22	NULL	NULL
23	NULL	NULL
24	NULL	NULL
25	NULL	NULL
26	NULL	NULL
27	NULL	NULL
28	NULL	NULL
29	NULL	NULL
30	NULL	NULL
31	NULL	NULL
32	NULL	NULL
33	NULL	NULL
34	NULL	NULL
35	NULL	NULL
36	NULL	NULL
37	NULL	NULL
38	NULL	NULL
39	NULL	NULL
40	NULL	NULL
41	NULL	NULL
42	NULL	NULL
43	NULL	NULL
44	NULL	NULL
45	NULL	NULL
46	NULL	NULL
47	NULL	NULL
48	NULL	NULL
49	NULL	NULL
50	NULL	NULL

dbo._TrainingCamp
323	2011-10-19 01:08:00	5	0	0	2011-10-19 01:08:00.000		
324	2011-10-19 02:11:00	1	22	77	2011-10-21 18:53:37.283		
325	2011-10-20 16:25:00	5	0	0	2011-10-20 16:25:00.000		
326	2011-10-20 16:49:00	1	5	21	2011-10-23 14:10:41.257		
327	2011-10-21 14:39:00	1	9	34	2011-10-23 13:50:57.737		
328	2011-10-21 17:34:00	1	10	46	2011-10-22 17:23:25.840		
329	2011-10-21 19:40:00	5	0	0	2011-10-21 19:40:00.000		
330	2011-10-22 12:10:00	5	0	0	2011-10-22 12:10:00.000		
331	2011-10-22 17:03:00	5	1	5	2011-10-23 08:29:02.953		
332	2011-10-22 17:22:00	5	0	0	2011-10-22 17:22:00.000		
333	2011-10-22 22:09:00	5	0	0	2011-10-22 22:09:00.000		
334	2011-10-22 22:38:00	5	1	5	2011-10-23 09:15:28.930		
335	2011-10-22 22:54:00	1	6	30	2011-10-23 13:54:54.777		
336	2011-10-23 00:10:00	5	6	17	2011-10-23 14:19:48.150		
337	2011-10-23 05:23:00	5	6	30	2011-10-23 15:04:43.170		
338	2011-10-23 05:48:00	5	1	5	2011-10-23 06:16:34.247		
339	2011-10-23 08:35:00	5	3	9	2011-10-23 11:16:14.293