Hello,

You can use following link for brief explanation about Performance Tuning,

http://msdn.microsoft.com/en-us/library/ms190957(v=sql.105).aspx

Hi Lowell ,

Thanx for reply.

worked for me.... 🙂

Hi Manoj,

You just need to union this query with

ParentIntermediaryID != IntermediaryID and ParentIntermediaryID not in

(SELECT ParentIntermediaryID FROM Intermediaries I1 INNER JOIN

(

SELECT DISTINCT ParentIntermediaryID

FROM Intermediaries

WHERE IntermediaryID =...

Hi,

you can use case statement.

Hi,

Looks like you don't have access to that file.