Linked Questions

0 votes
2 answers
2k views

How to transpose rows to column in datatabse [duplicate]

I have one table which contain 3 column,Col_ID, Col_Group, Col_Price for this my column is like below Col_ID Col_Group Col_Price 1 AA 0 1 BB 2000 1 ...
user84622's user avatar
1 vote
2 answers
1k views

Turning a multiple row resultset into columns with multiple rows [duplicate]

I currently have a resultset that looks like this: Title Value Start Time              1998-01-04 01:38:00.000 End Time                1998-01-04 01:43:00.000 Product Name           ...
M. Maynard's user avatar
2 votes
2 answers
273 views

How to pivot a table for a set number of combinations? [duplicate]

Ok so I have a table of components and a colleague needs some data from this table in a different format, now I could do it with some python or java code but wondered if there is a simpler way in MS-...
Steven Lightfoot's user avatar
0 votes
1 answer
215 views

Query to insert records from one table into another table based on the column of the first table [duplicate]

I have a table with the structure below : Table(customer_Num int , Channel_Id Varchar(50) , Branch_Code int) and some example data for this table is : Table ...
Pantea's user avatar
  • 1,432
0 votes
1 answer
132 views

Dividing a column into three columns [duplicate]

I have this table: Name Address Code James CT Homeaddress Mark [email protected] Email John [email protected] homeemail ... This is ...
Rafey's user avatar
  • 65
0 votes
1 answer
46 views

Create dynamic column [duplicate]

My table has this data START_DATE | STOP_DATE | SAMPLE_DATE | SAMPLE_VALUE :-------------------- | :-------------------- | :--------------------- | -----------: 11/...
4111's user avatar
  • 101
0 votes
0 answers
35 views

Need to create an SQL result suitable for data mining [duplicate]

I have a database of supermarket transactions that I wish to use for associative data mining purposes. Below is an image of my current SQL query however I am not sure if what I require is possible ...
Owen's user avatar
  • 3
4 votes
2 answers
25k views

How to execute this procedure in PL/SQL?

I have this table in the below format: Persnbr | Userfieldcd | Value 01 | Port | Funds 01 | Vip1 | Systems 02 | Port | Bank 02 | Vip1 | Authority This is how I want ...
Rafey's user avatar
  • 65
1 vote
2 answers
5k views

Transforming multiple rows into a single row

In my company, I need to join table A to table B: Table A is the sources table Table B is the empty table I want to know that how can I do it and the result like table B? Source table A: ID ...
user85312's user avatar
-1 votes
1 answer
2k views

How to combine multiple rows into one, based on event id, datetime, and an action into their own columns?

I'm not sure how to word the topic title... I have a table with data similar to below, where each row stores an event associated with alarms. For example, events might include: alarm goes active ...
Applez00800's user avatar
0 votes
0 answers
1k views

How to use PIVOT or LISTAGG to solve this?

I have a table like below. USERID USERNAME ITEM 12345 JESSE ITEM1 12345 JESSE ITEM3 12345 DON ITEM2 12346 DANNY ITEM4 12346 ELISA ITEM1 12347 ANDY ITEM2 12347 ANDY ITEM4 What im trying to ...
Eliza's user avatar
  • 1