tsql - How to Pivot on caption? -

-

I am trying to pivot the rows in columns with Tsql and also end the tap. How do I do this? My current query: 

  IF OBJECT_ID (N'tempdb .. # test_data ') Tap drop table #test_data Table #test_data (question_caption varchar (max), [0] varchar (max), [ Enter the #test_data value ('q1', 'abc', tap, faucet, zero) * #test_data value 'Q2', enter varchar (max), [2] varchar (max), [3] varchar (max), [3] Enter the #test_data value ('q3', tap, tap, 'd', null) in the form of the #test_data value ('q4', tap, tap, tap, 'jacqual'), tap, tap, 'df', tap, null) In the form of PivotTable

output ([0], [1], [2], [3]) for question_caption, select #test_data from smoke (maximum [0]) * : 

  question_caption 0 1 2 3 q1 ABC tap nail faucet Q2 faucet DRF cord faucet Q3 Nail faucet Nail Q4 Nail nail null JQUAL

What do I need: 

  q1 Q2 q3 q4 aBC def ghi jkl

How can I get this? The error in the above query is: Message 265, Level 16, State 1, row 4 PIVOT operator specified column name "0" conflicts with existing column name in PIVOT argument.

I have tried several pivotal examples, but all of them got an error or another result.

You can get a simple maximum case : 

 < Select the code> [q1] = max (when case_caption = 'q1' then ends [0] and ends), [q2] = max case when question_caption = 'q2' then ends [1] and tap), [ Q3] = max (case when question_caption = 'q3' then ends [2] and ends), [q4] = max (in case case_caption = 'q4' again [3] and tap end) #test_data

or axis: 

  from [q1], [q2], [q3] [q4] from ([q1]) (q ) To #te (from maximum, V) smoke (C, V) (Question, Capitol, section), ([0], [1], [2], [3]) St_data) [Q2], [q3], [q4])

Comments

Post a Comment

Popular posts from this blog

c# - SignalR: "Protocol error: Unknown transport." when navigating to hub -

-
Image
I am trying to use the ASP.NET signal for the first time - here's what I did: created a new web Has been added to the project and the following signal R packages: I have created the following category: [Hub-name ("chat")] Public class ChatHub: Hub {Public Zero Halo () {Clients.All.hello ( ); }} and the following startup configuration: public partial class startup {public zero configuration (IAppBuilder app) {configure (app); App.MapSignalR (); }} However, whenever I navigate localhost: (port) / api / signalr / chat I get the following error: Protocol error: Unknown transport. I am running a new browser and trying different people so remove it from the API / URL, and just use the localhost: (potter) / signaller / Chat
Read more

class - Kivy: how to instantiate a dynamic classes in python -

-
Using KV lang on my Python code, I have taken a hard time trying to instantiate a dynamic class, the following Consider the code: My test.kv file looks like this: & lt; MyPopup @ popup: Title: 'Hello' size_hunt: (1, .6) Grid layout: ID: RouteGrid column: 2 padding: ['8dp', '4dp', '8dp', '4dp'] Difference: '8dp' label: text: 'some text here' button: text: 'OK' On_press: do_something () & lt; MyGrid & gt;: Rows: 1 Button: Text: 'Show Popup' on_press: root.pop.show () Then import Kivy.app into my test.py: I get the following error: raise Factory Exception ('Uncount Class' '% name) kivy.factory.FactoryException: Unknown class Can anyone tell me how to do this properly, what do I remember? If you need more information please let me know Thank you. Takes a call to the factory before the KV file is loaded, so you want the class to Are not yet in existence. As long as no clas...
Read more

python - mayavi mapping a discrete colorbar on a surface -

-
Image
I want to change the color of the surface on the basis of another value (an ID) that is considered discrete (hence I In the simplified example given below, I have prepared a field with 3 different IDs: 0 / red on left 2 / blue 1 / green left But with the code below, I have some strange behavior on the border between red and blue (green Point) I think this is probably due to an interpolation! Code: import from import mlab np # np # my dataset -simplified-x, y, z = np.mgrid [-3: 3: 100] H, -3: 3: 100h, -3: 3: 100 h] value = NP. SQLT (x ** 2 + y ** 2 + z ** 2) # My color value: Volume is divided into 3 sub-versions taking colorvalues ​​with X = np.empty (values.shape) colorvalues [0:33,:,:] = 0 colorvalues ​​[33:66,:,:] = 2. Look [66:,:,:] = 1 src = mlab.pipeline.scalar_field (value) src.image_data.point_data.add_array (colorvalues.T.ravel ()) (1) .name = 'MyID' src.image_data. point_data.update src.image_data.point_data.get_array () # surface, contour = mlab.pipe...
Read more