 ,                         CASE WHEN 0 = 0                              THEN ( SELECT TOP 0                                             sFirstName + ' ' + sLastName                                     FROM    Lead                                     WHERE   iLeadID = objTemp.iLeadID                                   )                              ELSE ''                         END AS LeadName ,                         CASE WHEN 0 = 0                              THEN ( SELECT TOP 0                                             sEmail                                     FROM    Lead                                     WHERE   iLeadID = objTemp.iLeadID                                   )                              ELSE ''                         END AS LeadEmail ,                         CASE WHEN 0 = 0                              THEN ( SELECT TOP 0                                             iUserID                                     FROM    AssignLeadUser                                     WHERE   iLeadID = objTemp.iLeadID                                   )                              ELSE ''                         END AS AgentID ,                         CASE WHEN 0 = 0                              THEN ( SELECT TOP 0                                             sFirstName + ' ' + sLastName                                     FROM    UserAccount                                     WHERE   iUserID = ( SELECT                                                               iUserID                                                         FROM  AssignLeadUser                                                         WHERE iLeadID = objTemp.iLeadID                                                       )                                   )                              ELSE ''                         END AS AgentName ,                         CASE WHEN 0 = 0                              THEN ( SELECT TOP 0                                             sEmail                                     FROM    UserAccount                                     WHERE   iUserID = ( SELECT                                                               iUserID                                                         FROM  AssignLeadUser                                                         WHERE iLeadID = objTemp.iLeadID                                                       )                                   )                              ELSE ''                         END AS AgentEmail ,                         CASE WHEN 0 = 0                              THEN ( SELECT TOP 0                                             iGroupID                                     FROM    AssignLeadUser                                     WHERE   iLeadID = objTemp.iLeadID                                   )                              ELSE ''                         END AS GroupID ,                         CASE WHEN 0 = 0                              THEN ( SELECT TOP 0                                             s