Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- WITH
- correctShips(ship) AS
- (
- --Корабли с более чем одним пробелом
- SELECT ship
- FROM Outcomes
- WHERE ship LIKE '% % %'
- ),
- spacePosition(ship, N) AS
- (
- --Позиции пробелов для кораблей.
- SELECT ship, CHARINDEX(' ', ship) AS N
- FROM correctShips
- UNION ALL
- SELECT cs.ship, CHARINDEX(' ', cs.ship, N + 1)
- FROM correctShips cs
- JOIN spacePosition cte ON cs.ship = cte.ship
- WHERE CHARINDEX(' ', cs.ship, N + 1) > 0
- AND CHARINDEX(' ', cs.ship, N + 1) < LEN(cs.ship)
- )
- SELECT *
- FROM spacePosition
- можно сделать вторые колонки с следующим пробелом и LEAD их цеплять
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement