SELECT judges.photoVisible, judges.firstName, judges.middleName, judges.lastName, judges.court, judges.rankTitle, judges.jurisdiction, isnull(judges.workstatus, 'active') as workstatus, judges.retiredYear, ISNULL(judges.courthouseID, 0) AS courthouseID, judges.phone as DirectPhone, judges.chambersemail, judges.photo, judges.district, judges.catTitle1, judges.catTitle2, judges.catTitle3, judges.catTitle4, judges.catTitle5, judges.catTitle6, judges.catTitle7, judges.catTitle8, judges.catTitle9, judges.catTitle10, judges.catContent1, judges.catContent2, judges.catContent3, judges.catContent4, judges.catContent5, judges.catContent6, judges.catContent7, judges.catContent8, judges.catContent9, judges.catContent10, ISNULL(CtHouse.BuildingName, '') AS BuildingName, ISNULL(CtHouse.Phone, '') AS Phone, ISNULL(CtHouse.Visible, '') AS Visible FROM weJudgeBios judges LEFT JOIN WeCtHouseDirectory CtHouse ON CtHouse.CtHsID = judges.courthouseID WHERE (judges.bioVisible = 1) AND (judges.judgeID =30584) AND ISNULL(workStatus, 'active') <> 'retired' Error accessing Database.
No error message available, result code: E_FAIL(0x80004005).
System.Data Judge Profile
Mn Judicial Branch Logo
Find Court