Post reply

Help with UNION ALL Join -

  • July 16, 2004 at 1:59 pm

    #108791

    Hai all,

     I have two tables t1 and t2, I am trying to UNION ALL betn them and Order by time stamp columns in the table. I created alias to time stamp in one of the table to other tables timestamp column name and tried to order by it,

    But i am getting the following error.

    Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

    [Microsoft][ODBC SQL Server Driver][SQL Server]Only text pointers are allowed in work tables, never text, ntext, or image columns. The query processor produced a query plan that required a text, ntext, or image column in a work table.

    Help would be really appreciated

  • July 16, 2004 at 2:48 pm

    #514957

    Can you give us some ddl and a sample query to work with? Also if you separate it out to individual queries do they all run?




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply