Column is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause: createdon Using SQL-4-CDS v6.4.0.0 inside the XrmToolbox.

Function inlining in SQL Server 2019 Starting with SQL Server 2019, scalar functions written in T-SQL may be inlined. This means they will be folded into the query and no longer incur the UDF ...

Try to build single result of group by result on string column, but it doesn't works and reports error: No match found for function signature group_count(< CHARACTER >) Query sql example is below: ...