repeat results without loops, MSSQL2005 Express

• Sailor

  Newbie

  Points: 2

  More actions

  October 21, 2025 at 8:21 pm

  #4675946

  hello everybody, new here and this is my first question

  I have a table contains: Name, Id, joinDate

  My question is that:

  I need a query to list all years between current date and joinDate, as the following as instance:

  Id------------------------Name----------------------empDate

  1--------------------------John-----------------------6-8-2020

  result:

  1--------------------------John-----------------------6-8-2021

  1--------------------------John-----------------------6-8-2022

  1--------------------------John-----------------------6-8-2023

  1--------------------------John-----------------------6-8-2024

  1--------------------------John-----------------------6-8-2025

  Thanks in advance.