Archive for March, 2010

MSSQL CAST() and GROUP BY

March 29, 2010 by marco · Comments Off
Filed under: Problems, Snippets 
Social Tagging:

Just in case somebody has a similar problem… Coming mainly from MySql I had to deal with some MsSql/SQL Server specialties. Consider the following working SQL for MsSql: SELECT AK.AK_TEXT, BU.BUDGET_BEREICH ,TY.AKTIONSTYP_TEXT ,AK.AK_STARTDATUM ,AK.AK_ENDEDATUM FROM AKTIONEN AS AK WITH (nolock) LEFT JOIN BUDGET_TRAEGER AS BU ON AK.AK_BUDGET_NUMMER=BU.BUDGET_NUMMER LEFT JOIN AKTIONSTYP AS TY ON AK.AK_TYP=TY.AKTIONSTYP_TYP LEFT [...]