GROUP BY Clause for Complex TCC Projections with Substring/Switch-Case

Summary

GROUP BY Clause for Complex TCC Projections with Substring/Switch-Case

Content

Hi

I would like to know what is the equivalent SQ-XML for the below SQL statement.

SELECT

SUBSTRING([group], 1, 3) AS [group]

FROM table

GROUP BY

SUBSTRING([group], 1, 3)

I know how to create projections and use groupings in TCC. But there is no documentation available on how to group a projection which has a complex projection like above or with a switch-case statement in it.

Please assist.

 

Kind Regards