Create table #TempTable
insert into #TempTable
select * from #TempTable
select * from #TempTable A cross join #TempTable B where A.MYteam <> B.MYteam
drop table #TempTable
These are teams playing with each other, How do i avoid eg. Silver vs gold cuz there is a gold vs silver.
I'm not sure exactly what you are looking for, but perhaps
select * from #TempTable A cross join #TempTable B where A.MYteam < B.MYteam
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?