有人能帮忙看看一条sql怎么写么？
就是一条会议信息，其中有个字段是开始时间，我要查询id查询这条会议的信息，并且查看这条会议是在本年度的第几次会议，开始时间是date类型，谢谢大佬

分析函数，rownum over(partition bt)

CREATE PROC SP_GetNumber
(
@璐村惂鐢ㄦ埛_000052P馃惥 int,
@startDateTime datetime,
@endDateTime datetime,
@number int output
)
AS
BEGIN
DECLARE @_id INT
SET @number=0
SELECT ID,StartDateTime,EndDateTime
INTO #temp_T_MettingInfo
FROM T_MettingInfo WHERE StartDateTime>=@startDateTime AND EndDateTime<=@endDateTime
ORDER BY StartDateTime ASC
WHILE EXISTS(SELECT TOP 1 ID FROM #temp_T_MettingInfo)
BEGIN
SELECT TOP 1 @_ID=ID FROM #temp_T_MettingInfo
SET @number=@number+1
IF @_ID=@id
BEGIN
BREAK
END
END
PRINT @number
DROP TABLE #temp_T_MettingInfo
END