asp and graph
I use following query in asp.
DECLARE @totalVideos int
SET @totalVideos = (SELECT COUNT(*) FROM Training_Module)
SELECT t2.Name,t3.Department_Name, t4.Position_Name, COUNT(t1.emp_id) as ViewCount,COUNT(t1.emp_id)*100/44 as
ViewPercentage
FROM Module_View t1
JOIN Employee t2 ON t1.emp_id = t2.emp_id
JOIN Department t3 ON t2.Department_Code = t3.Department_Code
JOIN Position t4 ON t2.Position_Code = t4.Position_Code
GROUP BY t1.emp_id,t2.Name,t3.Department_Name, t4.Position_Name
it retreive the percentage safety video records.
like this
name viewcount percentage%
-----------------------------
Peter 10 22
Jones 16 36
Marksr 8 18
......
...
how can display the graph of above query record in asp ?
regards
Mateen
|