jwcolby
jwcolby at colbyconsulting.com
Fri Nov 23 11:04:22 CST 2007
Indeed why not? The only real reason is that newTable does not exist yet and I would have to create it by hand. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller Sent: Friday, November 23, 2007 11:23 AM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] SQL Server 2005 - View to table Um, why not just SELECT INTO newTable FROM viewName? Arthur