Please supply report queries which work in MSSQL!

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














                  New to ADSelfService Plus?