, 17 2015 . 10:36
+
! .
date object t1 t2 t3
01.01.2015 1 1 2 3
01.01.2015 2 4 5 6
02.01.2015 1 7 8 9
02.01.2015 2 10 11 12
date t1 t1 t2 t2 t3 t3
01.01.2015 1 4 2 5 3 6
02.01.2015 7 10 8 11 9 12
TRANSFORM First(7.t1) AS [First-t1]
SELECT 7.dDate, Count(7.t1) AS [ t1]
FROM 7
GROUP BY 7.dDate
PIVOT 7.lcoObject;
t1. t2,t3 .
http://www.sql.ru/forum/1166370/perekresnyy-zapros
