sql - pivoting rows to columns in tsql -


I have the following sample data in the following table 

  ID language question SubQuestion SubSubQuestion TotalCount Kulprasar 3 E 9 0 1 88527 73% 3 E 9 2 2 1 9 684 16% 3 E 9 323 9 60 11% 3 e 9 9 9 33 1%   
 Let me In the row everything should be like this:  
  id language TotalCount901 TotalPercent901 TotalCount902 TotalPercent902 TotalCount903 TotalPercent903 3E 88,527 73% 19,684 16% 12960 11%   
 I Tired, but it is not ready to work for me.   
 
 
 I have made some assumptions based on your column names, but it seems that you Want to use something similar from This is applied to both  UNIVIS  and then a  PIVOT  to get the value in the column you requested:  
 Select from  (Selection ID, Language, QL + Cast) (as the Varchar (10)) + cast (subsurface as Worker (10)) + Cast (Submitted Question as varchar (10)), Call value (Selection ID USRC unpivot (in (TOTALCOUNT, totalpercent)), language, artist (varchar (10)) as TOTALCOUNT, totalPercent, question, subquestion, yourtable (SubSubQuestion for col in [TotalCount901]) Value for the country col) srcpiv axis (max (value), [totalPercent901], [TotalCount902], [totalPountcent2], [TotalCount903], [totalPortcent903], [TotalCount909], [totalPercent909]))  Note: When  UNPIVOT  columns need the same datatype if they are not, then you get to convert the datatype to the same type of convert / Cast will be required.  
 If you have an unknown number to converge, then you can use the DirectX SQL:  
  DECLARE @query AS NVARCHAR (MAX), @ colsPivot As NVARCHAR (MAX) selections @colsPivot = STUFF (select ',' + 'QUOTENAME (c.name + cast (Question as varchar (10)) + cast (subquestion (10) as varchar) SubSubQuestion T as the cast (your tablets varchar (10))) apply sys.columns such as cross c where C.object_id = object_id ('yourtable') and C.name c.name ('TOTALCOUNT', ' TotalPercent ') group, t.question, t.subquestion, t.sububquestion XML path (' ', t For EEPE, order by T. SBS Question Price ('.', 'NVHAR (Max)', 1,1, '') @ Set = Select from * (select ID, language, col + cast (varchar) As the question (10)) + cast (subquestion as varchar (10)) + cast col, from (id, language, select value of artists (varchar (10) SubSubQuestion as the form of (TOTALCOUNT varchar) (10) Total Count, Total Effective, Question, Submission, Subscription from your Bandh) USRC Univot (Value for Columns (Total Number)   
 Performed x (value) 'p' for colonel ('korea') for Colonel in SourcePort Pivot (MA) ('+ @ ColsPivot +') / P>

Comments

Post a Comment

Popular posts from this blog

java - NullPointerException for a 2d Array -

नक्शा = नया बफर्ड इमेज [चौड़ाई] [ऊंचाई]; के लिए (int i = 0; i & lt; height; i ++) {for (int j = 0; j & lt; चौड़ाई; j ++) {if (charMap [j] [i] == पर्वत। इंडेंटफार्म) {if (j + 1 & lt ; चौड़ाई और amp; amp; j-1 & gt; = 0) {if (charMap [j-1] [i]! = पर्वत। इंडेंटिफ़ायर & amp; amp; & amp; amp; charMap [j + 1] [i]! = पर्वत। इंडेंटफार्म) {नक्शा [जे] [आई] = टाइल ग्रिड [1] [10]; }} और {नक्शा [जे] [आई] = टाइल ग्रिड [8] [10]; }}} यह कोड है जिसे मैं सेल के चारों ओर प्रत्येक टाइल को चेक करके 2 डी सर की जांच करने के लिए उपयोग कर रहा हूं लेकिन मुझे लगता है कि किसी को भी सोच रहा हूँ मदद कर सकता है? मुझे संदेह है कि आपको NullPointerException को charMap [j] से प्राप्त हो रहा है [ I] == पर्वत। इंडेंटिफ़ायर लाइन। सुनिश्चित करें कि आप ज्योफ द्वारा सुझाए गए दोनों मानचित्रों के लिए आंतरिक सरणियों को प्रारंभ करते हैं।
Read more

python - Assemble mpeg file unable to play in mediaplayer -

I am currently working on a school project and I think that is to gather some problems with the MPEG file I The scope of my project is: 1) Split the MPEG file into pieces of many fixed sizes. 2) Collecting some of them and leaving some part. Problem 1: When I run the file in the media player, it will play the video until it reaches that segment which I left Give it Example: Chunk = ["yui_1", "yui_2", "yui_3", "yui_5", "yui_6"] Duration of each segment: 1 second * If you think I have left the "yui_4" section. * If I went to collect all the parts except "yui_4", then the video will play the first 2 seconds before being hanged throughout the period. Problem 2: When I gather the first part off the part, it is unable to run the full MPEG file is. Duration of each piece: 1 second Example: wheel = ["yui_2", "yui_3", "yui_4", "yui_5", "yui_6"...
Read more

c# - NameSpace Manager or XsltContent to parse aspx page -

How can I use the namespace manager or XSLT content to parse the aspx page? I am using HtmlAgilityPack I am trying to parse the aspx page to get the button and label control ID. When I try to select a node with the asp: button element, I get the following error Here is the error message: Namespace Manager or XsltContext is required This query contains a prefix, variable, or user-defined function. HtmlAgilityPack.HtmlDocument htmldoc = new HtmlAgilityPack.HtmlDocument (); String filePath = @ "C: \ webform4.aspx"; Htmldoc.load (filepath); Foreach (html.doc.DocumentNode.SelectNodes ("// div") in HtmlNode div) {Response.Write (div.Id); HtmlNode ASP ("asp: button") in foreach (div.SelectNodes) {Response.Write (asp.Id); }} My aspx page looks like: & lt;% @page language = "c #" autoevolutionwireup = "true" codebahind = "Webform 4 Aspx.cs" Inheritance = "WebApplication 1.WebForm4"%> & Lt ;...
Read more