Linked Questions
11 questions linked to/from Pivot rows into multiple columns
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 ...
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 ...
- 23
2
votes
2
answers
238
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-...
0
votes
1
answer
188
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
...
- 1,412
0
votes
1
answer
130
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 ...
- 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/...
- 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 ...
- 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 ...
- 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 ...
- 21
-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
...
- 123
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 ...
- 1