While consulting for clients with large databases, I have encountered this on several occasions. To get rid of the table lock you need to insert less rows at a time....

I WROTE THE FOLLOWING DYNAMIC CROSS TAB FOR A STATE UNIVERSITY. THE PRINCIPLES WILL WORK WELL IN ALMOST ANY CASE

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_NULLS ON

GO

ALTER ...