Could you give me some more details on what you are trying to achieve?

You can see it using link
http://schedules.footballguys.com/freeschedule.php i don't need only cross join between 1 and 12 i need correct prepare 11 weeks of games. Best regards.

It looks like you have some tables with the schedule information and all that you want is to get the schedules for each week. So, do you want some help with the t-sql query so that you can display it appropriately? If yes, then I will need the table structures to help you. Or is it that you want to display it in a SSRS report?

Either ways, you have to give me more information on what is your source data structures, and what you would like the end result to be? And what are the toolset that you are trying to achieve it in.

I have got results in my table but i had to write it manually. I would like to create generator depends on count of teams. Example 1. 4 teams means that if we have 2 rounds and every team has to play with other. Remeber that team play one match at home and next away.( but not always) 1 round

1 week

1 - 2

3 - 4

2 week

4 - 1

2 - 3

3 week

1 - 3

2 - 4

2 round (reverse match)

4 week

3 - 1

4 - 2

5 week

1 - 4

3 - 2

6 week

2 - 1

4 - 3

if we have 6 teams it means that every week will be 3 plays. 1 round that will be 5 weeks, 2 round = 5 weeks and so on. Problem is not with generating matches but with apropriate combines in week.