Query multiple issues merged into one record at a time

mamie814

I have two tables with the following structure:

Form A

Field Type Meaning
DataValue float
DataKind int data type range 0-7 8 data indicators respectively representing a group of data
DataTime datetime


As shown above, each set of data should contain 8 data indicators, but there are 8 records in the database. Can the contents in table A be combined into one record through SQL and given different field names respectively.

116657396

Use crosstab query.

sinexe

Search "row transfer"

hiqwolfzzh

case .... when ..... then ...

jccg1124

reference
declare @sql varchar (4000)
set @sql = 'select Name'
select @sql = @sql + ', sum (case Subject when' '' + Subject + '' 'then Result end) [' + Subject + ']'
from (select distinct Subject from CJ) as a
select @sql = @ sql + 'from test group by name'
exec (@sql)

fanfan1980

--such?
create table T (id int, type int)
insert T select 1, 1
union all select 1, 2
union all select 1, 3
union all select 2, 3

select id,
'A' = max (case type when 1 then 1 end),
'B' = max (case type when 2 then 2 end),
'C' = max (case type when 3 then 3 end)
from T
group by id

--result
id A B C
----------- ----------- ----------- -----------
1 1 2 3
2 NULL NULL 3

(2 row (s) affected)