Michael Maddison
michael at ddisolutions.com.au
Thu Sep 30 19:11:22 CDT 2004
You RUN/execute the statement in QA... don't SAVE it ;-))) cheers Michael M OK. Where do I write this code? Susan Klos Senior Database Analyst Evaluation and Reporting Florida Department of Education 850-245-0708 sc 205-0708 -----Original Message----- From: Mackin, Christopher [mailto:CMackin at quiznos.com] Sent: Thursday, September 30, 2004 3:49 PM To: dba-sqlserver at databaseadvisors.com Subject: RE: [dba-SQLServer] Union query Certainly, Just use: Create View dbo.MyView AS Select * From dbo.schoolEnrollmentNumberselemonly Union all Select * From dbo.SchoolEnrollmentNumberselemcombo Then you can call dbo.MyView from whereever -Chris Mackin -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of Klos, Susan Sent: Thursday, September 30, 2004 1:34 PM To: 'dba-sqlserver at databaseadvisors.com' Subject: [dba-SQLServer] Union query Please be kind. I am doing this from an Access viewpoint and am having trouble making a transition. I have created a union query: Select * >From dbo.schoolEnrollmentNumberselemonly (this is a view) Union all Select * >From dbo.SchoolEnrollmentNumberselemcombo (this is a view) Now I need to be able to call this query in another view. Is this possible? How? Susan Klos Senior Database Analyst Evaluation and Reporting Florida Department of Education 850-245-0708 sc 205-0708 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com