SQL Server Syntax Difficulties
I'm used to RedShift and Postgres, but not SQL Server, and I'm having to do some work in SQL Server syntax now and am having trouble with a particular query.
I have a snippet that is a standalone query (not adding the query for company reasons) and it runs fine. I.E.:
But when I make a parent query around that subquery it bombs, citing the last character as the issue, both in Periscope and directly querying off of a server client. I.E.:
Any ideas what I'm missing here? I haven't had luck isolating this with documentation or forums so far.