Home Forums SQL Server 2008 SQL Server 2008 - General How to diagnose a query with a sub-query against another server. RE: How to diagnose a query with a sub-query against another server.

  • August 29, 2012 at 6:49 am

    #1531356

    Have you tried a JOIN instead of the IN?

    I've read there can be unexpected problems with cross-server queries.

    SELECT --USE DISTINCT if there are multiple rows in vwCRMServiceProviderAccess

    SP.[ServiceProviderGuid],

    SP.[ServiceProviderTypeGuid],

    SP.[ServiceProviderName],

    SP.[ServiceProviderId],

    SP.[MainPlant],

    SP.[ServiceProviderParentGuid]

    FROM ServiceProvider SP

    JOIN vwCRMServiceProviderAccess SPA ON SP.[ServiceProviderGuid] = SPA.[ServiceProviderGuid]

    WHERESPA.[UserGuid] = '4D569648-C703-47BA-BF66-D8E39F5C9D49'

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2