Hi, Please run the query below in your query analyzer and check if this the desired result. Declare @Tab Table ( Id Int Identity (1,1), [Name] Varchar (100), [Address] Varchar (100), DateMoved DateTime ) Insert Into @Tab ([Name], [Address], DateMoved) Select 'xxx' , 'aa,sssss' , GetDate () - 10 Union Select 'xxx' , 'ab,sssss' , GetDate () - 10 Union Select 'xxx' , 'ac,sssss' , GetDate () - 10 Union Select 'yyy' , 'aa,bbbbb' , GetDate