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

CREATE PROCEDURE dbo.MyReportQuery
@serviceCalls INT
AS
BEGIN

-- RESULT SET #1
-- Retrieve the service service call
SELECT
*
FROM ServiceCalls
WHERE PK_ServiceCalls = @serviceCalls;

-- RESULT SET #2
-- Rerieve all of the appliances for the specified service call
SELECT
SC_Appliances.*
FROM SC_Appliances
    LEFT JOIN ServiceCalls ON PK_ServiceCalls = FK_ServiceCalls
WHERE ServiceCalls.PK_ServiceCalls = @serviceCalls;

-- RESULT SET #3
-- Retrieve all of the appliance items for the service call
SELECT
SC_ApplicancesItems.*
FROM SC_ApplicancesItems
    LEFT JOIN SC_Appliances ON PK_SC_Appliances = FC_SC_Appliances
    LEFT JOIN ServiceCalls ON ServiceCalls.PK_ServiceCalls = SC_Appliances.FK_ServiceCalls
WHERE ServiceCalls.PK_ServiceCalls = @serviceCalls;

cmd.CommandType = StoredProcedure
cmd.Parameters.Add("@serviceCallPk", SqlDbType.Int).Value = ServiceCallPK

BusinessLayer.FillMultipleDataTables(cmd, _
                                                 ServiceCalls.BusinessObject, _
                                                 ServiceCalls.BusinessObject.Appliances.BusinessObject, _
                                                 ServiceCalls.BusinessObject.Appliances.BusinessObject.ApplianceItems.BusinessObject)