The problem i am having is that when i try to run this code in sql view of the queries in ms access it comes up undefined function 'string_agg' in expression.. Yes, but each implementation differs slightly from each other. Instead, use the group by on the substring function like so:
To fix this error, you. The function 'string_agg' is not a valid windowing function, and cannot be used with the over clause. Standard aggregation functions like sum or.
This can happen for a few reasons:. I recently coded a stored procedure on sql server 2019 (14.0.3192.2) in aws that utilized the function string_agg with no issues. Describe the bug i'm using a sql server instance with version 12.0.6024 and i'm getting an error: I assumed that as i appeared to have ms 2018 functions like this would work.
When i moved the code to my local test db. However i then clicked on 'help' and. String_agg () does not exist in older versions of ms sql server and that was the problem here. It looks like the string_agg was fixed, but only when not connecting to a sql azure database;