I tried to do a simple sintax, but i have a problem with the language and "getdate"
I'm Brazillian and have an automation that update a Data Extension (Primary Key is month) with a FTP integration that the data always arrives in portuguese. But one day before this automation works, two fields (the month and the number of records from another DE) have to update. My sintax below:
Like the month in the archive arrives in portuguese, i needs that the DATENAME(MONTH, GETDATE()) arrived in PT-BR. Is it possible?
select DATENAME(MONTH, GETDATE()) AS [Month], count(*) As [Field1] from [Clients_DE]