/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

0 vote129 views1 answer
Opensuse stop MySQL
SQL
0 vote94 views1 answer
Mysql convert column to uppercase
SQL
1 vote142 views1 answer
Get table which have specific columns in mysql
SQL
0 vote184 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
3 votes168 views3 answers
Order by postgres
SQL
1 vote164 views1 answer
Sql view where tables have same column name combine results
SQL
0 vote131 views1 answer
Get all employee of salary if more than in sql
SQL
0 vote159 views1 answer
Database db connection string format
SQL
0 vote154 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL
0 vote131 views1 answer
Update using case in mysql
SQL