T-SQL

Re: cum transform din coloana in linie sql server 2000

csm75 — Wed, 16 Apr 2008 18:02:16 GMT

Da, cea mai buna solutie.

Re: cum transform din coloana in linie sql server 2000

B_gd_n[ ]Sahlean — Wed, 05 Mar 2008 19:58:54 GMT

O posibila solutie:
CREATE TABLE T
(
nr VARCHAR(25) NOT NULL,
doc VARCHAR(25) NOT NULL,
chit VARCHAR(25) NOT NULL,
suma MONEY NOT NULL
)
GO

INSERT INTO T VALUES ('0370','hnv3','curent',10)
INSERT INTO T VALUES ('0370','hnv3','rest',15)
INSERT INTO T VALUES ('0370','hnv3','access',20)
INSERT INTO T VALUES ('0470','hnv4','curent',100)
INSERT INTO T VALUES ('0470','hnv4','rest',150)
INSERT INTO T VALUES ('0470','hnv4','access',200)
GO

SELECT nr,
  doc,
  SUM(CASE WHEN chit='curent' THEN suma ELSE 0 END) AS curent,
  SUM(CASE WHEN chit='rest' THEN suma ELSE 0 END) AS rest,
  SUM(CASE WHEN chit='access' THEN suma ELSE 0 END) AS access
FROM T
GROUP BY nr, doc

cum transform din coloana in linie sql server 2000

Alex — Wed, 05 Mar 2008 18:27:20 GMT

salut,

am o tabela temporara care contine ceva de genul:

nr doc chit suma

0370 hnv3 curent 10

0370 hnv3 rest 15

0370 hnv3 acces 20

cum o pot transforma in forma

nr doc curent rest acces

0370 hnv3 10 15 20

multumesc.

alex.