Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Optimizing a SQL command
Message
De
13/09/2013 11:44:33
 
 
À
13/09/2013 11:29:14
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01583170
Message ID:
01583177
Vues:
42
SELECT Task.Numero AS LXPrimaryKey,Task.Title,RobotTimeFrame.Title_E AS RobotTimeFrame,'' AS PrecisedTime,
Task.Instance,Task.Class,Task.Method,Robot.Title_E,Server.Title_E AS Server,'' AS Log2,Task.LoopDateStart,
Task.LoopDateEnd,Member.LastName,Task.AddDate,Member2.LastName AS LastName2,Task.ModDate,Task.Precised,Task.Log
 FROM Task (NOLOCK) 
 INNER JOIN Robot ON Task.NoRobot=Robot.Numero 
 INNER JOIN Server ON Robot.NoServer=Server.Numero
 LEFT JOIN RobotTimeFrame ON Task.NoRobotTimeFrame=RobotTimeFrame.Numero
 INNER JOIN Member ON Task.AddUser=Member.Numero
 INNER JOIN Member AS Member2 ON Task.ModUser=Member2.Numero
 ORDER BY Task.Title
I'm assuming from this query that the results for RobotTimeFrame.Title_E could be NULL in some cases, and therefore the LEFT JOIN?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform