UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Change Row To Column, SQL Server 2008 R2    
 
   
mr.siro
post May 26 2020, 10:08 PM
Post#1



Posts: 188
Joined: 27-January 18



Hello guys, i have table like green area, how get result like blue area with query.
Go to the top of the page
 
June7
post May 26 2020, 10:11 PM
Post#2



Posts: 1,510
Joined: 25-January 16
From: The Great Land


That is done with a CROSSTAB query.

--------------------
Attachments Manager is below the edit post window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    2nd July 2020 - 06:31 AM