How to Fix SQL Syntax Error in Code

Question

Hello Community,

I'm getting the following error

Incorrect syntax near the keyword 'FROM'.

When I execute the following query:

WITH cte AS ( SELECT accountid FROM STRING_SPLIT(ts_montaguoffice, ';') as ts_montaguofficeonly 
  FROM core.account ) SELECT accountid, ts_montaguofficeonly 
  FROM cte CROSS APPLY (SELECT value FROM STRING_SPLIT(ts_montaguofficeonly, ';')) as split

I know its something simple, but could someone let me know how to resolve this error?

Thanks

Answer 1

This works for me:

SELECT accountid, t.value as ts_montaguofficeonly
FROM core.account 
cross apply ( select value from STRING_SPLIT(ts_montaguoffice, ';')) as t

But it depends.