-- variables
DECLARE @xml XML = '
<states>
  <s />
  <s />
  <s />
  <s />
  <s />
</states>'

-- use common table expression to shred data
;WITH ShreddedData () AS
(
FROM     @xml.nodes('states/s') x(node)
)
SELECT * FROM ShreddedData;