Invoke-Query

function Invoke-Query($employeeID){
    $empID = "a.employee_id,b.employee_id"
    $queryReturn = @()
    $myQuery = @()
    $myQuery = "SELECT $empID,office_id,department_id,job_type"
    $myQuery += " FROM emp_info..sql\srvr a,org_info b"
    $myQuery += " WHERE a.employee_id =+ "'$employeeID'"
    $myQuery += " AND " + "'b.$employeeID'" + " ="+ "'a.$employeeID'"

    $queryReturn = Invoke-SqlCmd -query $myQuery
    return $queryReturn
}

$csvFileName = "Office123.csv"
$csvImported = import-csv \\server\path\$csvFileName
foreach ($emp in $csvImported){

    $empInfo = Invoke-Query $emp
    $empInfo | select-object employee_id,office_id,organization,job_code | format-table
    if($empInfo.employeeID -eq $NULL)
    {
        Write-Verbose "An Error Has Occurred"
    }
    elseif($empInfo.employeeID -eq $emp -and $empInfo.office_id -ne "123")
    {
        Write-Verbose "Employee information is from incorrect office"
    }
    else
    {
        Write-Verbose "Employee information is valid"
    }
}