Devart Forums

Posted: **Mon 15 Apr 2013 12:52**

Formatting unpivot code below (which is correct T-SQL) results in failure "Error (6,21): '')'' expected"

with SRC as
( select [1] = 1 )
select U.*
from SRC
unpivot
(Val for Col in (SRC.[1])) as U

Reason seems to be the alias SRC in SRC.[1]
Removing the alias (code below) and formatting is done without an error.

with SRC as
( select [1] = 1 )
select U.*
from SRC
unpivot
(Val for Col in ([1])) as U

Posted: **Wed 17 Apr 2013 08:06**

Could you please clarify what product you were referring to?

Posted: **Thu 18 Apr 2013 12:59**

Sorry, SQL Complete 4.0.72

Posted: **Fri 19 Apr 2013 13:24**

This issue will be fixed in the next build of the product. We will notify you once it's available for downloading.

Bug in unpivot formatting fully qualified ?