The problem is that, according to the explaination, you need 3 100GB RAID 5 and 2 250GB RAID 1 however the correct answer has 3 100GB RAID 5 and...

Joe, it depends on how you see it.

I developed one system for the company which, according to the customers, was a failure.

The same system was also used for an automated...

Looks like the submitter of the question failed the parser because both A and B definitely work.

One quick solution is as follows:

SELECT childid, parentid, checkdate, docid, sum(cast(fixed_length as dec(10,2)) as sumfixedlength

from (

SELECT    

dbo.Erika_test_claim_billed.childid,

dbo.Erika_test_claim_billed.parentid,

dbo.Erika_test_claim_billed.checkdate,

dbo.Erika_test_claim_billed.docid,

dbo.padfieldleft(case

                      when (dbo.Erika_test_adjustments.seq = 1 or 

 dbo.Erika_test_adjustments.seq is null)...