Can someone give me some idea how to perform batch insert in sql2005 by using t-sql ? My query below doesnt run in batch if I try with "top" ? will that work ? the date_time below contain aroun 30 millions of records, that is why I plan to run the insert per 100000 batches
INSERT into DBTestA.dbo.LoggingA
FROM DBProdA.dbo.LoggingA with (nolock) where date_time>'2010-12-01 23:59:59.999'
and date_time>'2010-12-31 23:59:59.999'