原表结构：
想实现的效果：
不知道有没有不用CASE WHEN 的方法？
附
数据创建语句：
CREATE TABLE mdm_ProjMilestoneNodes ( [ProjMilestoneNodesGUID] uniqueidentifier, [ProjGUID] uniqueidentifier, [VersionGUID] uniqueidentifier, [VersionTypeName] varchar(20), [Nodes] varchar(50), [NodesDate] datetime, [NodesDateLength] money, [SerialNum] int )
INSERT INTO mdm_ProjMilestoneNodes ([ProjMilestoneNodesGUID], [ProjGUID], [VersionGUID], [VersionTypeName], [Nodes], [NodesDate], [NodesDateLength], [SerialNum])
VALUES
( '{e084e371-e93d-46ad-acbb-001d3aa2de50}', '{6b2d4e4a-946e-ec11-b399-f40270d39969}', '{8e390c4b-c80a-4b2a-87ec-59a029935483}', '定位上报版', '项目获取', N'2022-01-04T00:00:00', NULL, 1 ),
( '{7441a2a6-9938-40fc-92bb-1fbd6747d51b}', '{6b2d4e4a-946e-ec11-b399-f40270d39969}', '{8e390c4b-c80a-4b2a-87ec-59a029935483}', '定位上报版', '收回股东投资', N'2024-03-30T00:00:00', 27.2000, 5 ),
( '{eaab96b4-2b7b-4d8c-b060-5b13156af7db}', '{6b2d4e4a-946e-ec11-b399-f40270d39969}', '{8e390c4b-c80a-4b2a-87ec-59a029935483}', '定位上报版', '正式开工（首批）', N'2022-04-29T00:00:00', 3.8333, 2 ),
( '{095ddc0a-15d5-4e02-9384-746f605e2668}', '{6b2d4e4a-946e-ec11-b399-f40270d39969}', '{8e390c4b-c80a-4b2a-87ec-59a029935483}', '定位上报版', '竣工备案（首批）', N'2023-08-22T00:00:00', 19.8333, 4 ),
( '{09fe08e2-9495-4233-8da0-a735b045ed5f}', '{6b2d4e4a-946e-ec11-b399-f40270d39969}', '{8e390c4b-c80a-4b2a-87ec-59a029935483}', '定位上报版', '现金流回正', N'2024-09-30T00:00:00', 33.3333, 6 ),
( '{b86ddeb5-6fa4-4f90-bcf1-bbaf7c9a5c0e}', '{6b2d4e4a-946e-ec11-b399-f40270d39969}', '{8e390c4b-c80a-4b2a-87ec-59a029935483}', '定位上报版', '首开', N'2023-09-01T00:00:00', 20.1667, 3 )
DROP TABLE mdm_ProjMilestoneNodes
