Microsoft SQL Server , view transformation
Is it possible to transform the following view :
to this structure ?
I've tried with cross join but I have no idea how to make a condition based on column name.
Solution
You need APPLY instead of JOIN to be able to access outer columns
SELECT t.Date, v.[1], v.[2], v.number
FROM Table t
CROSS APPLY (VALUES
(t.[1], CAST(NULL AS int), 1),
(NULL, t.[2], 2)
) v ([1], [2], number)
- Reorder rows in a MySQL table
- Need to truncate a timestamp and add a minute to it in SQL
- Shortcut for Question marks in preparedStatement for parameterized query
- Correctly Migrate Postgres least() Behavior to BigQuery
- Dealing with single quotes in excel vba sql queries
- Data is Null. This method or property cannot be called on Null values
- Redshift GROUP BY ALL syntax not supported
- How to simulate GREATEST() in Sybase ASE?
- Retrieve data from 3 tables with 2 conditions
- How to LOCK with READ COMMITTED SNAPSHOT
- How to save the result of a condition (IF) into a variable?
- SQL query to get students who have enrolled in English or Urdu course but not in both
- Mysql Where Calculate
- MySql reuse alias for WHERE clause
- Filter by distance in the same query that calculates it with MySQL?
- Age calculation not working
- MYSQL using alias in the WHERE clause
- WHERE clause to filter times that are under an hour
- Unknown column for calculate field in MySQL
- Calculated column in where-clause - performance
- mysql calculation results in WHERE clause
- Getting previous column values in a new column
- Why do we always prefer using parameters in SQL statements?
- SQL Statement using Where clause with multiple values
- I am getting the following error when I am inserting a all the lines of a very large log file into ms sql server 2008
- how to see generated sql from a linq query
- Snowflake PARSE_JSON pattern match for keys
- Get a result set flagging where there is a history going back 3 months
- Chaining joins in SQL based on dynamic table
- what are the alternative methods to replace SSRS Subscription?