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
2010-06-18 09:50:38
+1
A:
insert into mytable(c1, c2, c3, ...) select c1, c2, c3, ... from myview
Willis Blackburn
2010-06-18 09:51:03