Annyi sor, amennyi az intervantionumber

MDI_CTE.sql

CREATE FUNCTION [dbo].[MDI_CTE] (@ID BIGINT)
RETURNS @MID_CTE TABLE
(
  ID BIGINT,
  ToothCode NVARCHAR(64),
  InterventionCode NVARCHAR(16),
  BNOCode NVARCHAR(16),
  ToBeReported BIT,
  DentistryPatientDatacardID BIGINT,
  InterventionNumber INT
)
AS
BEGIN
  INSERT INTO @MID_CTE
  SELECT
    ID,
    ToothCode,
    InterventionCode,
    BNOCode,
    ToBeReported,
    DentistryPatientDatacardID,
    InterventionNumber
  FROM ModToothInterventions
  WHERE ID = @ID

  DECLARE @CurrentRow INT = 1
  DECLARE @LastRow INT

  SELECT @LastRow = InterventionNumber
  FROM @MID_CTE


  WHILE @CurrentRow  <  @LastRow
  BEGIN
    INSERT INTO @MID_CTE
    SELECT
      ID,
      ToothCode,
      InterventionCode,
      BNOCode,
      ToBeReported,
      DentistryPatientDatacardID,
      InterventionNumber
    FROM ModToothInterventions
    WHERE ID = @ID

    SET @CurrentRow = @CurrentRow + 1
  END

  RETURN
END