/SQL/Create view in sql server that contain multiple select statements

Create view in sql server that contain multiple select statements

SELECT     X AS 'First', Null as 'Second'
FROM       The_Table
WHERE     The_Value = 'y'
Union
SELECT     null as 'First', X AS 'Second'
FROM       The_Table
WHERE     The_Value = 'z'

Source: stackoverflow.com

Similar codes

8 votes174 views1 answer
Declare table variable sql server
SQL
4 votes199 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL
0 vote157 views1 answer
How to set all the min and sec data to zero in sql server
SQL
1 vote150 views1 answer
What is int in mysql
SQL
4 votes184 views4 answers
Mysql get date from datetime
SQL
0 vote160 views1 answer
Group by join columns per table
SQL
14 votes160 views3 answers
SQL trim
SQL
0 vote158 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL
0 vote124 views1 answer
Oracle sql replace string in clob
SQL
2 votes179 views1 answer
Cannot return non-composite value from function that returns composite type
SQL