Fixing SharePoint

How to copy data from one table to another in SQL Server 2008 insert into MultiMedia.dbo.MovieSongs(Col1,Col2,Col3) select Col1,Col2,Col3 colums from MultiMedia_Temp.dbo.MovieSongs

How to copy data from temp table in SQL server 2008? with MovieSlice as           (                 select  moviestock .moviesuffix,count( moviesongs.id_song) as songsCount from  moviestock inner join moviesongs on  moviestock .moviesuffix = moviesongs.moviesuffix group by  moviestock .moviesuffix     )     UPDATE      MovieStock SET      MovieStock .songsCount = MovieSlice.songsCount FROM      MovieStock INNER JOIN     MovieSlice ON     MovieSlice.moviesuffix =  MovieStock .moviesuffix