This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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(137.6, 31%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
I am trying to answer a question with this code block and when I try to post I get unexpected error.
Please fix the following issues to continue:
Initial steps or instructions to begin using Microsoft Q&A
Hi Naomi,
Did you try manually editing the code block in markdown mode? Sometimes the editor messes up the underlying markdown. When in markdown mode you can delete out extra backticks that shouldn't be there, etc., make sure the block has the three opening and three closing backticks, etc.
-TP
I tried many times. I found it's the SELECT keyword in the SQL code that generates this error. When I removed SELECT I was finally able to save portion of the code
DECLARE @SQL NVARCHAR(MAX);
SELECT @SQL = STRING_AGG(...
PRINT @SQL;
This is the thread with the issue https://learn.microsoft.com/en-us/answers/questions/1314153/how-do-i-use-a-row-in-a-table-to-set-it-as-a-table
By trial and error I found that it's using SELECT twice in the statement that is causing the error.
Tried about 10+ times, I am unable to post a simple SQL string that uses STRING_AGG function.
Trying:
DECLARE @SQL NVARCHAR(MAX);
@SQL = STRING_AGG(CONVERT(VARCHAR(MAX),' ID FROM ' + QUOTENAME(s.name+'.'+t.name) + ' WHERE ID = 1234'), CHAR(13)) from sys.tables t join sys.columns c on t.object_id=c.object_id join sys.schemas s on s.schema_id=t.schema_id