Data360 Analyze

Welcome to the Data360 Analyze community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Announcements  Product Documentation  Ideas Portal

Discussions

Members

Resources

Events

 View Only
Back to discussions
Expand all | Collapse all

Please help me convert this T-SQL to Teradata SQL

  • 1.  Please help me convert this T-SQL to Teradata SQL

    Employee
    Posted 07-27-2018 11:24

    SET @Xml = CAST(('<A>' + REPLACE(@Germon, ',', '</A><A>') + '</A>') AS xml)

     

    SELECT RTRIM(LTRIM(d.value('.', 'varchar(40)'))) AS order FROM @Xml.nodes('A') AS FN (d))) AS dist)