Mein Vorschlag:

select 'Position 1' display,1 return
from tabelle
where identnr=XXX
and sp1=1
union all
select 'Position 2' display,2 return
from tabelle
where identnr=XXX
and sp2=1
union all
select 'Position 3' display,3 return
from tabelle
where identnr=XXX
and sp3=1
usw....

sp1 = Spalte1