| 100+
P: 142
| - SELECT a.claimno
-
,a.diagrefno
-
,a.diag
-
,a.diagdesc
-
,b.diagrefno as diagrefno2
-
,b.diag as diag2
-
,b.diagdesc as diagdesc2
-
,c.diagrefno as diagrefno3
-
,c.diag as diag3
-
,c.diagdesc as diagdesc3
-
,d.diagrefno as diagrefno4
-
,d.diag as diag4
-
,d.diagdesc as diagdesc4
-
,e.diagrefno as diagrefno5
-
,e.diag as diag5
-
,e.diagdesc as diagdesc5
-
-
FROM ezcap1.archp.dbo.CLAIM_DIAGS a
-
LEFT OUTER JOIN ezcap1.archp.dbo.CLAIM_DIAGS b on a.CLAIMNO=b.CLAIMNO and b.diagrefno = 2
-
LEFT OUTER JOIN ezcap1.archp.dbo.CLAIM_DIAGS c on a.CLAIMNO=c.CLAIMNO and c.diagrefno = 3
-
LEFT OUTER JOIN ezcap1.archp.dbo.CLAIM_DIAGS d on a.CLAIMNO=d.CLAIMNO and d.diagrefno = 4
-
LEFT OUTER JOIN ezcap1.archp.dbo.CLAIM_DIAGS e on a.CLAIMNO=e.CLAIMNO and e.diagrefno = 5
-
WHERE a.diagrefno = 1
QUESTION
The script above displays data result horizontally. Question? How can I display data vertically?
Thanks.
| |
