pivot

Need to transform the rows into columns for the similar ID's in oracle

Hi, I need to transform the rows into columns for the similar ID's in oracle e.g. The following is the result I will get if i query my database Col1 Col2 Col3 ---- ---- ---- 1 ABC Yes 1 XYZ NO 2 ABC NO I need to transform this into Col1 Col2 Col3 Col4 Col5 ...

PIVOT / UNPIVOT in SQL Server 2008

Hello I got child / parent tables as below. MasterTable: MasterID, Description ChildTable ChildID, MasterID, Description. Using PIVOT / UNPIVOT how can i get result as below in single row. if (MasterID : 1 got x child records) MasterID, ChildID1, Description1, ChildID2, Description2....... ChildIDx, Descriptionx Thanks ...

Using PIVOT in SQL Server

How can i convert below using PIVOT as Thanks ...

How can I turn a bunch of rows into aggregated columns WITHOUT using pivot in SQL Server 2005?

Here is the scenario: I have a table that records the user_id, the module_id, and the date/time the module was viewed. eg. Table: Log ------------------------------ User_ID Module_ID Date ------------------------------ 1 red 2001-01-01 1 green 2001-01-02 1 blue 2001-01-03 2 green 20...

How do I pivot simple repeating data in SQL 2005 that is of type Text

Hello there, I've done some searching and found info on how to pivot numbers and sum them, but I haven't seen where I can pivot text. Simplified, we have a table that looks a little something like this... PlanID--------AreaAbbrev---------AreaDescription----------GoalText 10133---------Rec----------------Recreation-------------------J...

SQL conditional Pivot

Yes, this is another Pivot question... I've read through nearly all the previous questions and I can't seem to hack together a query that does what I need. Here is what my table looks like: FirmName Account Balance Pmt Revolving Installment Mortgage Amex 12345 10000 2000 1 0 0 Discover 54321 20000 4000 ...

SQL Pivot table error-using variable gives syntax error

Hi my coworker came to me with this error and now I am hooked and trying to figure it out, hope some of the experts can help us! Thanks so much! When I execute Step6 we get this error: Msg 102, Level 15, State 1, Line 4 Incorrect syntax near '@cols'. --Sample of pivot query --Creating Test Table Step1 CREATE TABLE Product(Cust VARC...

Converting rows to Columns in SQL

I have a table (actually a view, but simplified my example to a table) which gives me some data like this CompanyName website Google google.com Google google.net Google google.org Google google.in Google google.de Microsoft Microsoft.com Microsoft live.com Microsoft bing...

SQL Aggregate all Purchases for a certain product with same rebatecode

I would like to aggregate all purchases for a certain product that used the same rebatecode (using SQL Server 2005). Assume we have the following table: ID ProductID Product RebateCode Amount 1 123 7HM ABC 1 2 123 7HM XYZ 2 3 124 7HM ABC 10 4 124 ...

Converting MySQL Resultset from Rows to Columns

I have output from a select like this: 04:47:37> select * from attributes left outer join trailer_attributes on attributes.id = trailer_attributes.attribute_id; +----+--------------+----------+-----------+------------+--------------+-----------------+ | id | name | datatype | list_page | trailer_id | attribute_id | attribute_val...

Multi Pivoting on single Source data

I am trying to mutlipivot source data (as below ) want results as single row (as below) My query so far is SELECT * FROM ( SELECT * FROM ( SELECT NK, DC, VERSION, GEV FROM MULTIPIVOT ) S...

Performance using T-SQL PIVOT vs SSIS PIVOT Transformation Component.

Hi I am in process of building Dimension from EDW (source), wherein I need to pivot columns of source to load Dimension. Currently most of the pivoting stuff am doing is by using T-SQL PIVOT which further get used in my SSIS package to merge with Dim table This pivoting can also be achieved by SSIS PIVOT Transformation component. In ...

SQL: join within same table with different 'where' clause

Ok, so the problem I'm facing is this, I have a table with 3 columns : ID, Key and Value. ID | Key | Value ================ 1 | 1 | ab 1 | 2 | cd 1 | 3 | ef 2 | 1 | gh 2 | 2 | ij 2 | 3 | kl Now I want to select the value of Keys 1 & 3 for all IDs, the return should be like this ID | 1 | 2 ================ 1 ...

SQL Query Help Please

Hello, I have an addition SQL question, hopefully someone here can give me a hand. I have the following mysql table: ID Type Result 1 vinyl blue, red, green 1 leather purple, orange 2 leather yellow and i am seeking the following output: ID Row One Row Two 1 vinyl blue, red, green leather purple, o...

T SQL Rotate row into columns

SQL 2005 using T-SQL, I want to rotate rows into columns. Sample script: Use TempDB Go CREATE TABLE [dbo].[CPPrinter_InkLevels]( [CPPrinter_InkLevels_ID] [int] IDENTITY(1,1) NOT NULL, [CPMeasurementGUID] [uniqueidentifier] NOT NULL, [InkName] [varchar](30) NOT NULL, [InkLevel] [decimal](6, 2) NOT NULL, CONSTRAINT [PK_C...

how to pivot rows to columns

Every example of using PIVOT in MSSQL shows people using this to aggregate data. I'm trying to exploit this to just simply transpose rows to columns For instance, consider the follwoing data SELECT 11826 ID,cast('64 ' as varchar(1000)) as answer,75098 QuestionID,2785 CollectionID into #temp insert into #temp SELECT 11827 ID,cast('S...

SQl Pivot help with multiple tables

SQL Pivot Help: I have three tables as follows: Class Table: ID Name 1 N1 2 N2 3 N3 Flags Table: ID ClassID Flags 1 1 F1 1 1 F2 1 2 F3 1 3 F1 1 3 F3 Session Table: ID ClassID Session 1 1 S1 2 1 S2 3 1 S3 4 2 S2 5 ...

SQl Server 2005 Pivot

I want to basically join these 3 table in a view for a report: Class Table: ID Name 1 N1 2 N2 3 N3 Flags Table: ID ClassID Flags 1 1 F1 2 1 F2 3 2 F6 4 2 F3 5 3 F2 Sessions Table: ID ClassID Sessions 1 1 S1 2 1 S4 3 2 S3 4 3 S...

Dynamically create categories for SQLite pivot/crosstab

I realise it is possible to create a crosstab within sqlite, but is it possible to dynamically determine the relevant categories/columns at runtime rather than hardcoding them? Given the following example, it can get rather tedious ... SELECT shop_id, sum(CASE WHEN product = 'Fiesta' THEN units END) as Fiesta, sum(CASE WHEN product = ...

T-SQL Pivot? Possibility of creating table columns from row values

Is it actually possible to rotate a T-SQL (2005) so that (for the sake of argument) the values of the first column's rows become the titles of the output table's columns? I realise this is not really what PIVOT is for, but it's what I need - the ability to request a table where the columns are not known before-hand because they have bee...