SMS Queries to SMS Reports: A Seven Part Series
I discovered this article today on MyITForum. It is one of the best collections I've seen of the process one needs to take to migrate an SMS Query to an SMS Report.
Read the series here:
If you've used SMS 2003, then you're familiar with the problem that building an SMS Query uses WQL, while SMS Reports use standard SQL. Converting between these two languages has its idiosyncrasies, and knowing how to do the conversion is critical for SMS administrators who need to provide reports (above the canned ones). The series is a great read.