API tools faq
paste
View difference between Paste ID: iMskAEw6 and 9vrhupYQ
SHOW: | | - or go back to the newest paste.
1
SET SHOWPLAN_TEXT ON;
2
GO
3
4
SELECT JobCandidateID AS 'ID Candidato', BusinessEntityID AS 'ID Entidad' 

5
    FROM HumanResources.JobCandidate 

6-
    WHERE ISNULL(BusinessEntityID, 1) <> 1;

6+
    WHERE BusinessEntityID IS NOT NULL;

7
GO

8
SET SHOWPLAN_TEXT OFF;
        

    


            


                                


        

            



                
    

        Public Pastes
    

    
            

    

                    

        

    





    


    
    
    
    
    
    
    
    




    


    



                

            We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.             OK, I Understand
        

    
                

            

                
                    
                
            

            

                Not a member of Pastebin yet?

                Sign Up, it unlocks many cool features!