Please supply report queries which work in MSSQL!
https://forums.manageengine.com/topic/report-on-requests-which-were-changed-to-resolved-state-last-week
http://forums.manageengine.com/topic/query-to-get-the-timespent-on-the-requests-which-are-open#49000005169121
http://forums.manageengine.com/topic/report-on-surveys-for-overall-rating-in-percentage#49000005169141
Lists the query for MySQL and MSSQL - it does not work in MSSQL
There are more and more of these appearing on your forums - why are the topics being posted as locked? - I am unable to respond in the actual post to say they are not working!!!
These are posted by Krishna Bharat - MySQL query functions do NOT all work in MSSQL - you need separate queries for MSSQL!!!
Thanks,
Dean
http://forums.manageengine.com/topic/query-to-get-the-timespent-on-the-requests-which-are-open#49000005169121
http://forums.manageengine.com/topic/report-on-surveys-for-overall-rating-in-percentage#49000005169141
Lists the query for MySQL and MSSQL - it does not work in MSSQL
There are more and more of these appearing on your forums - why are the topics being posted as locked? - I am unable to respond in the actual post to say they are not working!!!
These are posted by Krishna Bharat - MySQL query functions do NOT all work in MSSQL - you need separate queries for MSSQL!!!
Thanks,
Dean