masdamasda
چهارشنبه 25 فروردین 1389, 12:07 عصر
با سلام من میخام توی گزارشم از pivot استفاده کنم ولی متاسفانه eroor میده و
کوئریم هم اینه :
select * From
(
select T.TestDate ,AVG(CAST(SUBSTRING(T.DPercent, 2, 2) AS smallint) / 100)
, S.DetectorCode AS Code, S.DetectorName AS Name FROM Student AS S INNER JOIN
allTest AS T ON T.Counter = S.Counter INNER JOIN
TestMInfo AS M ON M.GroupCode = S.GroupCode ......
WHERE (D.Attribute = 0) AND (D.CourseId = 369) AND (S.GroupCode = 1)
) as one
pivot
(
AVG(CAST(SUBSTRING(T.DPercent, 2, 2) AS smallint) / 100)
for t.testdate in (13880724,13880808,13880822)
) as two
کوئریم هم اینه :
select * From
(
select T.TestDate ,AVG(CAST(SUBSTRING(T.DPercent, 2, 2) AS smallint) / 100)
, S.DetectorCode AS Code, S.DetectorName AS Name FROM Student AS S INNER JOIN
allTest AS T ON T.Counter = S.Counter INNER JOIN
TestMInfo AS M ON M.GroupCode = S.GroupCode ......
WHERE (D.Attribute = 0) AND (D.CourseId = 369) AND (S.GroupCode = 1)
) as one
pivot
(
AVG(CAST(SUBSTRING(T.DPercent, 2, 2) AS smallint) / 100)
for t.testdate in (13880724,13880808,13880822)
) as two