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)