Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Demo <> Dynamic Column Output
Language:
Ada
Assembly
Bash
C#
C++ (gcc)
C++ (clang)
C++ (vc++)
C (gcc)
C (clang)
C (vc)
Client Side
Clojure
Common Lisp
D
Elixir
Erlang
F#
Fortran
Go
Haskell
Java
Javascript
Kotlin
Lua
MySql
Node.js
Ocaml
Octave
Objective-C
Oracle
Pascal
Perl
Php
PostgreSQL
Prolog
Python
Python 3
R
Rust
Ruby
Scala
Scheme
Sql Server
Swift
Tcl
Visual Basic
Layout:
Vertical
Horizontal
--Sql Server 2014 Express Edition --Batches are separated by 'go' --select @@version as 'sql server version' Create Table Article (ArticleId Int, [Description] Varchar(10)) Insert Into Article Values (1, 'Test') Create Table OrderForecast(ArticleId Int, [Week] Int, [Order] Int, Amount Int) Insert Into OrderForecast Values (1, 51, 1, 0),(1, 52, 2, 150), (1, 1, 3, 0),(1, 2, 4, 200), (1, 3, 5,0) Select ArticleId, [Description], Week51, Week52, Week1, Week2, Week3 from ( select ArticleId, [Description], Amount, [Week] from ( SELECT OrderForecast.ArticleId, 'Week' + Convert(Varchar(10), OrderForecast.[Week]) as [Week], [Order], Amount, Article.[Description] as [Description] FROM OrderForecast Inner Join Article On OrderForecast.ArticleId = Article.ArticleId )a ) d pivot ( max(Amount) for [Week] in (Week51, Week52, Week1, Week2, Week3) ) piv;
View schema
Execution time: 0,02 sec, rows selected: 1, rows affected: 6, absolute service time: 0,28 sec, absolute service time: 0,28 sec
edit mode
|
history
ArticleId
Description
Week51
Week52
Week1
Week2
Week3
1
1
Test
0
150
0
200
0