<div>
<div class="content wysiwyg-content">
i have to distribute records to 7 different table.. the number of source records can be different ( for example, it can be 5000 or 37.. ) &nbsp;but i would like to distribute &nbsp;the records to 7 tables as evenly as possible. what is the best way to do this using SQL server 2008
</div>
</div>


i have to distribute records to 7 different table.. the number of source records can be different ( for example, it can be 5000 or 37.. )  but i would like to distribute  the records to 7 tables as evenly as possible. what is the best way to do this using SQL server 2008

insert records

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.