T-SQL UNION On 3 Tables!?

Posted by Goober on Stack Overflow See other posts from Stack Overflow or by Goober
Published on 2010-02-25T17:24:29Z Indexed on 2010/05/17 3:10 UTC
Read the original article Hit count: 334

Filed under:

tsql

|

union

Is this possible? Using SQL Server 2005.......

SELECT *
FROM Data0304 
UNION 
SELECT *
FROM Data0506
UNION 
SELECT *
FROM Data0708

Related posts about union

Whether to use UNION or OR in SQL Server Queries

as seen on SQL Server Performance - Search for 'SQL Server Performance'
Recently I came across with an article on DB2 about using Union instead of OR. So I thought of carrying out a research on SQL Server on what scenarios UNION is optimal in and which scenarios OR would be best. I will analyze this with a few scenarios using samples taken from the AdventureWorks database… >>> More
SyFy Channel Original Movie Title Generator

as seen on SQL Team - Search for 'SQL Team'
Saw this linked on reddit today and couldn't resist going through all the combinations: create table #pre(name varchar(20))create table #post(name varchar(20), pre varchar(10))insert #pre select 'Dino' union all select'Alien' union all select'Shark' union all select'Raptor' union all select'Tractor' union all select'Arachno' union all select'Cyber' union all select'Robo' union all select'Choco' union all select'Chupa' union all select'Grizzly' union all select'Mega' union all select'Were' union all select'Sabre' union all select'Man' insert #post select 'dactyl'… >>> More
Referencing a union inside a structure using union tag gives incorrect address

as seen on Stack Overflow - Search for 'Stack Overflow'
I had a need to declare a union inside a structure as defined below: struct MyStruct { int m_DataType; DWORD m_DataLen; union theData { char m_Buff [_MAX_PATH]; struct MyData m_myData; } m_Data; }; Initially, I tried accessing the union data as follows… >>> More
SQL SERVER – UNION ALL and ORDER BY – How to Order Table Separately While Using UNION ALL

as seen on SQL Authority - Search for 'SQL Authority'
I often see developers trying following syntax while using ORDER BY. SELECT Columns FROM TABLE1 ORDER BY Columns UNION ALL SELECT Columns FROM TABLE2 ORDER BY Columns However the above query will return following error. Msg 156, Level 15, State 1, Line 5 Incorrect syntax near the keyword ‘ORDER’… >>> More
Play Framework: Error getting sequence nextval using H2 in-memory database

as seen on Stack Overflow - Search for 'Stack Overflow'
As the title suggests, I get an error running Play 2.0.1 Tests using a FakeApplication w/ H2 in memory. I set up a basic unit test: public class ModelTest { @Test public void checkThatIndustriesExist() { running(fakeApplication(inMemoryDatabase()), new Runnable() { public… >>> More

Developer IT

T-SQL UNION On 3 Tables!? - Developer IT

T-SQL UNION On 3 Tables!?

tsql

union

Related posts about tsql

TSQL Challenge 30 - A Matrix Transposition challenge in TSQL

Will TSQL become useless because of new ORMs? [closed]

Issue Creating SQL Login for AppPoolIdentity on Windows Server 2008

The best, in the West

Something for the weekend - Whats the most complex query?

Related posts about union

Whether to use UNION or OR in SQL Server Queries

SyFy Channel Original Movie Title Generator

Referencing a union inside a structure using union tag gives incorrect address

SQL SERVER – UNION ALL and ORDER BY – How to Order Table Separately While Using UNION ALL

Play Framework: Error getting sequence nextval using H2 in-memory database

Categories cloud