Need help with OpenXML in SQL

[RickyC1]

Getting only one record back from OpenXML... Why???? When I run Select XMLString From CAPSProgram I get my expected results..

Expecting to get 250 below is the code from QA:

EXEC sp_xml_concat @hdl OUT,'(Select XMLString From CAPSProgram)a','XMLString'

SELECT x.*
FROM OPENXML (@hdl, '/Data/Current',2)
WITH (Codid char(20) '/Data/Generic/CedingCoID',
IDs char(100) '/Data/Generic/ProgramID',
Effective char(200) '/Data/Generic/EffectiveDate',
Company char(200) '/Data/Generic/Company',
Layer3 money 'StdDeviation/Layer3',
Layer4 money 'StdDeviation/Layer4',
Layer5 money 'StdDeviation/Layer5',
Layer6 money 'StdDeviation/Layer6',
Layer7 money 'StdDeviation/Layer7') as x
Order by x.company
EXEC sp_xml_removedocument @hdl