```
SELECT ma.ManningID
      ...
      ,'P01' AS Pline
      ...
FROM Manning AS ma
UNION ALL
SELECT ma.ManningID
      ...
      ,'P02' AS Pline
      ...
FROM Manning AS ma
UNION ALL
SELECT ma.ManningID
      ...
      ,'P03' AS Pline
      ...
FROM Manning AS ma

```

in case of many P... is it possible to make this view's query more compact?