/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

5 votes176 views1 answer
Mysql get last day of month
SQL
0 vote176 views1 answer
Postgres get running query
SQL
0 vote199 views1 answer
Mysql min value row
SQL
0 vote192 views2 answers
Csv into data postgres
SQL
0 vote180 views1 answer
Get created time of database psql 8
SQL
23 votes181 views6 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote245 views1 answer
Postgres rename database
SQL
0 vote213 views2 answers
Amazon linux postgresql client
SQL
5 votes195 views1 answer
Com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
SQL
0 vote197 views4 answers
Stored procedure sql
SQL