Public Shared Function ServiceCallMaintenance_AllData(ByVal PK_ServiceCalls As Integer, ByVal includeServiceCallRecord As Boolean) As SqlCommand
     '-- Establish Locals
     Dim cmd As New SqlCommand()
     '-- Determine if the Service Call record will be included
     If includeServiceCallRecord Then
          cmd.CommandText = "SELECT dbo.ServiceCalls.* FROM dbo.ServiceCalls WHERE dbo.ServiceCalls.PK_ServiceCalls = @PK_ServiceCalls;"
     End If
     '-- Add the Appliances query for the selected Service Call, ordered by the Appliance Service Date.
     cmd.CommandText &= "SELECT dbo.SC_Appliances.* FROM dbo.ServiceCalls " & _
"INNER JOIN dbo.SC_Appliances ON (dbo.ServiceCalls.PK_ServiceCalls = dbo.SC_Appliances.FK_ServiceCalls) " & _
"WHERE (dbo.SC_Appliances.FK_ServiceCalls = @PK_ServiceCalls)" & _
"ORDER BY dbo.SC_Appliances.ServicedDate;"
     '-- Create the parms
     cmd.Parameters.AddWithValue("@PK_ServiceCalls", PK_ServiceCalls).SqlDbType = SqlDbType.Int
     '-- Return the results
     Return cmd
End Function