Eu as face asa ca in exemplul urmator:

1.Creez vederi astfel

SELECT     Sales.SalesOrderDetail.*
FROM         Sales.SalesOrderDetail INNER JOIN
                      Sales.SalesOrderHeader ON Sales.SalesOrderDetail.SalesOrderID = Sales.SalesOrderHeader.SalesOrderID
WHERE     (YEAR(Sales.SalesOrderHeader.OrderDate) = 2001)

dupa cum se vede leg tabela "SalesOrderHeader" de "SalesOrderDetail" pintr-o legatura alta decat data calendaristica si anume "SalesOrderID"

2.apoi as face un insert into tabel_details_2001 select * from vedere

3 as revedea schema de indecsi pusi pe coloanele de legatura intre tabele

---

Gheorghe Ciubuc,SQL Server Influencer, MCP(SQL 2000), MCTS (SQL Server 2005) , OCA(Oracle 9i), Sybase(Brainbench)