CREATE TABLE #TEST
(
Id INT,
Name VARCHAR(10)
)
Insert Into #Test
select 1,'A'
Union All
Select 1,'B'
union all
Select 1,'C'
union all
Select 2,'D'
Below is the output of above table,As you can see Id Column is repeated three times..
Id Name
1 A
1 B
1 C
2 D
Now...
