iNLINE PIVOT QUERY SYNTAX ERROR
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(230.39999999999998, 94%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Canaday, Susan L
0
Reputation points
a PIVOT query runs without error on its own but gets a syntax query when made into an inline query
Developer technologies | Transact-SQL
{count} votes
-
Canaday, Susan L 0 Reputation points
2025-05-20T19:03:27.17+00:00 sorry, gets a syntax error of Parse error column: Incorrect syntax near 'on'.
-
Viorel 123.6K Reputation points2025-05-20T19:23:55.79+00:00 Show at least the query.
-
Canaday, Susan L 0 Reputation points
2025-05-20T20:04:20.24+00:00 I'm not permitted to by the employer. It's a big query with lots of joins, and then an additional inline query with a pivot.
-
Canaday, Susan L 0 Reputation points
2025-05-20T20:05:10.49+00:00 I'm thinking it's a limitation of a dedicated pool type database hosted by azure synapse analytics.
-
Erland Sommarskog 124.2K Reputation points MVP Volunteer Moderator2025-05-20T21:55:28.3366667+00:00 Might be. But when we don't see the query, there is no way we can help you. It is understandable that your employer does not permit you to post actual code, but then you need to produce something anonymised that produces the same error.
And of course, the titbit that you are working on Synapse Dedicated pool is not an unimportant one!
-
Canaday, Susan L 0 Reputation points
2025-05-21T13:58:53.9066667+00:00 The developers here make tons of tiny #temp tables, something that was very much frowned on at most places I've worked at due to their temp tables getting bigger and bigger and spilling out over everything else that needs temp space, and many shops declaring very small temp spaces anyway. I come in with the attitude of 'why not just write a decent query while cognizant of indexing and data patterns.' This database has a lot of columnar indexes but on rather small tables and no partitioning, so not the best situation. But this database really does have some limitations. Something I see on a lot of cloud databases, but Azure Synapse Analytics hosted dedicated pools especially.
Sign in to comment
Sign in to answer