• Hello Sir

    SELECT S.IIATransactionId

    ,substring(rats_filename,1+patindex('%{________-____-____-____-____________}%',rats_filename),36) AS OracleTransactionId

    FROM iiafeedtransaction S,

    ratsiiafeedtransaction o

    WHERE S.IIATransactionId *= substring(rats_filename,1+patindex('%{________-____-____-____-____________}%',rats_filename),36)

    AND  o.Rats_filename IS NULL

    ORDER BY S.IIATransactionId

    i think you have executed this in Query Analyser and what you said is right. However, try exeucting this query as a view in enterprise manager and i hope you will see the result which you are interested in.

    I have seen the difference in this way in another case as well.. where the select statements brings lot of fields.

    this looks confusing but pls try once and when you get time, pls give feedback to me.


    Best REgards





  • I'm sorry, I've only got 2005 installed on my systems these days. I can't readily test this.

    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore Roosevelt
    The Scary DBA
    Author of: SQL Server 2022 Query Performance Tuning, 6th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

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

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