Solved

Create a new table

Posted on 2011-03-23
5
265 Views
Last Modified: 2012-06-27
Select * 
From MIS.Dbo.Company_Staff_Property
union all
Select * 
From MIS.Dbo.Applicant_Staff_Property	

Open in new window


Hi from the above union I want to create a new table called Staff_Properties is it possible to do this
0
Comment
Question by:Davesm
5 Comments
 
LVL 16

Expert Comment

by:Imran Javed Zia
ID: 35197867
Sure, you can use wraper qury to do so. And then you can use it as per requirements
0
 
LVL 5

Accepted Solution

by:
Angelgeo earned 500 total points
ID: 35197898

select *
into 
Staff_Properties
from 
(
Select * 
From MIS.Dbo.Company_Staff_Property
union all
Select * 
From MIS.Dbo.Applicant_Staff_Property)a

Open in new window

0
 
LVL 3

Expert Comment

by:kumarnimavat
ID: 35197909
You may use the below given query to create a new table

Select * from New_table_name from
(
Select *
From MIS.Dbo.Company_Staff_Property
union all
Select *
From MIS.Dbo.Applicant_Staff_Property
) a
0
 
LVL 3

Expert Comment

by:kumarnimavat
ID: 35197915
Select * from Staff_Properties from
(
Select *
From MIS.Dbo.Company_Staff_Property
union all
Select *
From MIS.Dbo.Applicant_Staff_Property
) a
0
 

Author Closing Comment

by:Davesm
ID: 35197933
Awesome service
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question