http://www.msc.com.my/updates/flagships.asp
There are 7 big big project planned by government of Malaysia
-Electronic Government
-Multipurpose Card
-Smart School
-Telehealth (I'm part of it, currently striving to get UAT)
-R&D Cluster
-Technopreneur Development
-E-Business
I've been part of it in Telehealth application. I have been heard of it since I was in highschool. I think half of the project have been completed such as MyKad (smartcard application for all Malaysian) and Technopreneur Development. I think it is iteration which may involves many phase. I'm having a hard time with my user discussing about our Reporting Solutions.
Yup, we use SQL Server Reporting Services. But we encounter many problem especially when the Reporting Services and the application itself is a different entity. Many of the data is not captured appropriately(captured in freetext). The application running in pilot stage, so we can still test our report using actual data. Some of the data entry form is in freetext format. It is not a good practice to filter data using string like this:
SELECT COUNT(VaccineId) FROM Vaccine WHERE VaccineName = 'Diabetes'
Data entry form should allow the user to enter the data by using defined metadata so that the developer can filter by using Vaccine ID.
SELECT COUNT(VaccineId) FROM Vaccine WHERE VaccineName = 12
Assume 12 is vaccine ID.
We also have made some mistake is defined the user requirement. Instead filtering data by state, district and clinic, we only filter the data by clinic. All the stored procedure have been complete. I just need to find the best solution to cater the state and distinct parameter. I've try used cursor. But not sure whether it is the best method to iterate each clinicid exist in particular state or district:
declare clinic_cursor cursor for
select clinicid
from dbo.CM_HealthFacilityMaster
where (@stateid IS NULL OR stateid = @stateid)
and (@districtid IS NULL OR districtid = @districtid)
and (@clinicId IS NULL OR clinicid = @clinicid)
fetch next from clinic_cursor
into @clinicId
while @@fetch_status = 0
begin
/* I call the SP for fetch data filtering by clinicid and assign it to table variable here */
fetch next from clinic_cursor
into @clinicId
end