tags:

views:

25

answers:

2

I have some data in a view which I want to insert into a table (same table schema) what's the easiest, cleanest way to do it.

+4  A: 
Insert Into dbo.MyTable (Col1, Col2,...)
Select Col1, Col2, ...
From dbo.MyView
Barry
+1  A: 

insert into mytable(c1, c2, c3, ...) select c1, c2, c3, ... from myview

Willis Blackburn