Archives of the TeradataForum

Message Posted: Wed, 01 Mar 2006 @ 18:02:28 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi All,

When I open a previously saved TD query in SQL Assistant, there will often be snippets of code appended to the bottom of my code.

Example:

     SELECT
                 STUFF
       FROM TABLE
     WHERE CRITERIA
     GROUP BY 1,2,3
     ORDER BY 1,2,3
     --END CODE

Save as aqry.sql

When I reopen this query it could look like:

     SELECT
                 STUFF
       FROM TABLE
     WHERE CRITERIA
     GROUP BY 1,2,3
     ORDER BY 1,2,3
     --END CODE
     WHERE CRITERIA
     GROUP BY 1,
     WHERE CRITERIA
     GR

I have the latest version of SQL Assistant. Is there a patch for this bug? Other?

Thank You!

	<Prev	Next>		<<First	<Prev	Next>	Last>>