源数据
要达成的结果
SELECT A.Startdate,
B.Startdate AS Enddate,
isnull(A.orgcode4_name,'') as orgcode4_name,
isnull(zige_name,'') as zige_name,
isnull(zhizhcode_name,'') as zhizhcode_name,
isnull(positioncode_name ,'') as positioncode_name
FROM
(SELECT ROW_NUMBER() over(order by startdate asc) as Seq, a.orgcode4_name,zige_name,zhizhcode_name,positioncode_name,convert(nvarchar(10),startdate,120) as startdate