sql2000:


Code:
Score_BD Table:

A   B	C   D	E	F    G	   H     I	K	L
-   -	-   -	-	-    -	   -     -	-	-	
9   1	3   30	5	     9	  3			
9   1	6   50	5	     9	  3
9   1	99  40	5	8    9	  3     7	6	3
9   1	66  21	5	7    9	  32    7	6	3
9   1	44  19	5	9   10	  37    7	6	3
10  1	50  20	5	     9	  3			
10  1	49  20	5	     9	  3
10  1	48  20	5	8    9	  3     7	6	3
10  1	47  21	5	7    9	  33    7	6	3
10  1	46  19	5	9   10	  34    7	6	3
need to extract:
G and H columns case when F is not null and A is 10.