CREATE TABLE #tb(
lh VARCHAR(10))
INSERT INTO #tb SELECT ‘12-1-2202‘
union all SELECT ‘12-1-2301‘
union all SELECT ‘12-1-2302‘
union all SELECT ‘12-1-2401‘
union all SELECT ‘12-1-2402‘
union all SELECT ‘12-1-2501‘
union all SELECT ‘12-1-2502‘
union all SELECT ‘12-1-2601‘
union all SELECT ‘12-1-2602‘
union all SELECT ‘12-2-101‘
union all SELECT ‘12-2-102‘
union all SELECT ‘12-2-201‘
union all SELECT ‘12-2-202‘
union all SELECT ‘12-2-301‘
union all SELECT ‘12-2-302‘
union all SELECT ‘12-2-401‘
union all SELECT ‘12-2-402‘
SELECT lh,SUBSTRING(lh,4,1) as a INTO #s from #tb
select
a.lh as ydy,b.lh as edy
from
(
select id=row_number()over(order by getdate()),lh from #s where a=1
)a
left join
(
select id=row_number()over(order by getdate()),lh from #s where a=2
)b
on
a.id=b.id
DROP TABLE #tb
DROP table #s
----------------结果----------------------------
/* ydy edy
----------- ----------- 12-1-2202 12-2-101 12-1-2301 12-2-102
12-1-2302 12-2-201
12-1-2401 12-2-202
12-1-2402 12-2-301
12-1-2501 12-2-302
12-1-2502 12-2-401
12-1-2601 12-2-402
12-1-2602 null
(6 行受影响)
*/
