I have two tables one "students" with enrollment and enrollment and another "do" with the students' grades in certain tests. I used the pivot command in the table "do_test" to transform the name of the tests into columns and the notes in lines,...
I have a query that returns me the student grades in certain tests. The amount of test can vary. I use the Pivot command to transform the test names into columns and thus organize test / note, as shown in the following image:
Where"SENEM_01"...
I'm trying to make a query using the pivot based on this link insert the description of the link here , but without success, because it always returns 2 lines Null:
Query:
DECLARE @registros as table (
ID int,
Campo varchar(250),...
I'm learning how to use tables with PIVOT in Sql-Server. I have a table with the item name, the vendor name, and the customer id.
Item | Customer | ID Rep
Pen Set | 1001 | Richard
Binder | 25092 | Nick
Pen Set | 5149...
This code: link
Make the selection in the ListBox ... and Filter driven by a button .. as described in the link ...
But if the PivotTable is created by Power Pivot .. This code does not apply ...
You can do this same job in this creat...
I have a table which I convert lines into columns with PIVOT. 'Chumbando' the column name works very well, however I will need to do this dynamically. Is it possible to use variables to define the name of the columns?
SELECT PRODUTO,...
Hello, could anyone give me an example of using the appropriate parameter connection of method PivotTableWizard() ?
When I use this parameter I get the error:
The PivotTableWizard property of the Worksheet class can not be obtaine...
I have a table with the data:
unidade tipo valor
1 2 10,00
1 3 15,00
2 2 16,00
3 3 10,00
3 1 25,00
I need to make a select pivot that swallows me
unidade tipo1 tipo2 tipo3...
I have a pivot table that returns me some null values in SUM(1) . I wanted them to be zero rather than null, but I can not.
Original pivot table
SELECT
Description AS Categoria,
[ACS],
[URO]
FROM
(...
I tried to find a solution to this case, and I need your help.
I have the following table:
hora data tarefa
10:00 02/01/19 A
10:00 03/01/19 B
11:00 02/01/19 C
Considering that today is 02/01/2019, when making the...