Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

RE: Expand / Collapse
Author
Message
Posted Thursday, July 27, 2006 6:30 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 15, 2009 8:19 AM
Points: 4, Visits: 14

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
Satheesh

 

 


 

Post #297729
Posted Tuesday, May 29, 2007 5:44 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 12:27 PM
Points: 15,541, Visits: 27,919
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 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #369453
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse