Posted on: 5/6/2011 11:54:43 AM | Views : 275

SELECT dbo.tblLabourFiles.LabID, dbo.tblBoardAppointment.OfficerID, dbo.tblBoardAppointment.DateAppt as [Date Appointed], dbo.tblSupportStaff.Initials, COALESCE (dbo.tblSupportStaff.FirstName, '') + COALESCE (' ' + dbo.tblSupportStaff.LastName, '') AS Officer, dbo.tblLabourFiles.Disposition as [Final Disposition], dbo.tblEmployerName.EmpName as [Employer, dbo.tblLabourFiles.CaseNum + N'/' + dbo.tblLabourFiles.CaseYear + N'/' + dbo.tblLabourFiles.Act AS [Case], dbo.tblLabourFiles.DateDec, dbo.tblLabourFiles.OpenDate, dbo.tblCaseType.CaseType as [Case Type], --[ApptType] CASE WHEN dbo.tblBoardAppointment.InformalAppt = 1 THEN 'Informal Appointment ' ELSE '' END + CASE WHEN dbo.tblBoardAppointment.FormalAppt = 1 THEN 'Formal Appointment' ELSE '' END AS Appoint, --[SettledWhen] CASE WHEN dbo.tblBoardAppointment.SettledPrior = 1 THEN 'Settled prior to hearing ' ELSE '' END + ...

Go to the complete details ...