Your search for "pivot" returned 100 results:
I am trying to show how many employees were hired in each department by startyear (2001, 2002, 2003) and then to rollup these year totals by department. So, for example, Engineering hired one employee in 2001, another in 2002, and another in 2003 with 3 total in the Engineering department. I am able to get […]
2012-09-10
12,841 reads
Hi there I am fairly new to SQL Server TSQL and I have a strong MS Access background. I can't get my head around pivot queries is TSQL. I have 3 Colums with data in it: 1) City 2) Delivery_type 3) Date_Delivered I want to create a pivot query that has the format with 14 […]
2013-03-17
4,946 reads
Hi everyone, we have a table containing kind of key-value pairs, which are the columns of some entities. This is how master data is ingested in the platform. Then a query does some joins, filtering and finally a PIVOT to only output a row by entity, with all their columns denormalized. The query plan looks […]
2024-04-09
159 reads
HI All, With this basic example is there a hard and fast better route for writing pivots: [Code] --Query1 SELECT Col1, [1] as [Jan], [2] as [Feb], [3] as [Mar], [4] as [Apr], [5] as [May], [6] as [Jun], [7] as [Jul], [8] as [Aug], [9] as [Sep], [10] as [Oct], [11] as [Nov], [12] […]
2008-08-26
718 reads
hello all, after much googleing and setting of parameters , member values etc, i am at a dead end I am trying to get the date filtering for a pivot table working my time dimension is set to Time The attribute Date os set to a Type of Date It's key column is set to […]
2011-03-03
1,086 reads
I know I've found the answer to this before but I'm having trouble now because every example I've found for how to transpose rows into columns is assuming I am trying to aggregate some part of the data. Below is a query that will return 3 rows of data with 4 columns in each row. […]
2019-10-23
1,288 reads
Hi, Has anyone ever tried using a column with dt_ntext datatype in the pivot transformation for ssis 2008? I am trying to use it and it gives me the following error - Error at DFT - Load and Pivot DAta [Pivot[[40]]: The Input column "DataSubmitted" (2818) cannot be used as a Set Key, Pivot Key […]
2012-08-24
224 reads
Hi, I am a newbie in sql server.I have came across various article on internet which shows how to implement pivot and un-pivot table. Since there are various gurus of sql server in this forum, i would like to know from them wheather they had used this feature in any of there project. And even […]
2012-08-03
9 reads
Hi Experts, Am facing problem when trying to execute Pivot transform in BIDS 2008. The error is : [Pivot [25]] Error: The pivot key value "Q1" is not valid. [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Pivot" (25) failed with error code 0xC0202090 while processing input "Pivot Default Input" (26). The […]
2014-02-04
493 reads
I have the following results after running a SQL. The first 2 columns are the result of the SQL. The 3rd column is what I try to achieve. So combining all values where name is the same in a new column. Is this possible using a pivot? or any other suggestion? Thanks
2022-10-24
749 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
Dears, Hope this message finds you well We have a log table which is...
Comments posted to this topic are about the item The Backup File Extension
Comments posted to this topic are about the item Ingest and Retrieve data from...
I run this command in SQL Server 2022. What is the extension of the backup file?
BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'See possible answers