set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER proc [dbo].[sp_GetAllProVersions]
@nodeText varchar(50)
as
declare @Versions_Currenttable table
(
ProjectId int,
devVersion varchar(100),
devStart datetime,
devEnd datetime,
qaVersion varchar(100),
qaStart datetime,
qaEnd datetime,
proVersion varchar(100),
proStart datetime,
proEnd datetime
)
-- 声明
declare cur_titles cursor
for
--select a.*,ver.VersionNumber,convert(varchar(10),ver.StatusSince,120) as StatusSince,convert(varchar(10),ver.NextStatusBy,120) as NextStatusBy from
--(
-- select distinct D_V.ProjectID as ProjectId,max(D_V.AutoID) as D_AutoID,D_V.VersionCurrentStateID as D_VersionCS
-- from dbo.CurrentState as D_C
-- inner join Versions as D_V
-- on D_C.CurrentStateID=D_V.VersionCurrentStateID
-- group by D_V.ProjectID,D_V.VersionCurren