https://logicwiki.co.uk/index.php?action=history&feed=atom&title=SQL_Weekday
SQL Weekday - Revision history
2026-10-16T09:06:31Z
Revision history for this page on the wiki
MediaWiki 1.26.2
https://logicwiki.co.uk/index.php?title=SQL_Weekday&diff=741&oldid=prev
Dt1nh6: 1 revision imported
2016-05-09T13:27:53Z
<p>1 revision imported</p>
<table class='diff diff-contentalign-left'>
<tr style='vertical-align: top;' lang='en'>
<td colspan='1' style="background-color: white; color:black; text-align: center;">← Older revision</td>
<td colspan='1' style="background-color: white; color:black; text-align: center;">Revision as of 13:27, 9 May 2016</td>
</tr><tr><td colspan='2' style='text-align: center;' lang='en'><div class="mw-diff-empty">(No difference)</div>
</td></tr></table>
Dt1nh6
https://logicwiki.co.uk/index.php?title=SQL_Weekday&diff=740&oldid=prev
Macrop at 13:35, 30 June 2015
2015-06-30T13:35:25Z
<p></p>
<p><b>New page</b></p><div>[[Category:SQL]]<br />
<br />
<pre class="brush:sql"><br />
(<br />
select 1 as d<br />
union<br />
select 2<br />
union<br />
select 3<br />
union<br />
select 4<br />
union<br />
select 5<br />
union<br />
select 6<br />
union<br />
select 7<br />
) weekdays<br />
</pre><br />
<br />
<br />
<pre class="brush:sql"><br />
<br />
CREATE TABLE yourtable<br />
([Id] int, [Value] varchar(6), [ColumnName] varchar(13))<br />
;<br />
<br />
INSERT INTO yourtable<br />
([Id], [Value], [ColumnName])<br />
VALUES<br />
(1, 'John', 'FirstName'),<br />
(2, '2.4', 'Amount'),<br />
(3, 'ZH1E4A', 'PostalCode'),<br />
(4, 'Fork', 'LastName'),<br />
(5, '857685', 'AccountNumber')<br />
;<br />
<br />
select *<br />
from<br />
(<br />
select value, columnname<br />
from yourtable<br />
) d<br />
pivot<br />
(<br />
max(value)<br />
for columnname in (Firstname, Amount, PostalCode, LastName, AccountNumber)<br />
) piv<br />
</pre></div>
Macrop