I have been manipulating the built in queries to create reports to better fit our needs. One thing I'm struggling with is what type of SQL does SWE use? I use MS SQL Server Management Studio to test out my queries before using them in SWE. Some of the statements that work just fine in MS Server Studio create an error when I run the query in SWE.
I'm thinking SWE uses a different flavor of SQL than MS Studio.