Database

ALTER PROCEDURE [dbo].[StaffSearch_sel]
    (
    @OverrideSecurity BIT = 0,
    @UserId INT,
    @SchoolYearId INT,
    @Name VARCHAR(500) = NULL,
    @ContractorId INT = NULL,
    @SubcontractorId INT = NULL,
    @SiteId INT = NULL,
    @OrganizationRelationshipIds VARCHAR(500) = NULL,
    @RoleTypeIds VARCHAR(200) = NULL,
    @StaffMemberNeedsAllRoles BIT = 0,  
    @Page INT = 1,
    @RowsPerPage INT = 20,
    @TotalRows INT OUT,
    @SortExpression VARCHAR(50) = 'LastName',
    @SortDirection VARCHAR(15) = 'Ascending'
    )
AS
BEGIN
 ---logic-----
END

public static List<StaffMemberPOCO> Search(bool staffMemberNeedsAllRoles, bool overrideSecurity, string name, int schoolYearId, int? contractorId, int? subcontractor, int? siteId,
    int[] roleTypeIds, int[] organizationRelationshipIds, int userId, int pageNumber, int rowsPerPage, out int totalRows, string sortExpression, string sortDirection)
{
    using (var context = new ELMSContext())
    {
        var outputParm = new SqlParameter("TotalRows", SqlDbType.Int) { Direction = ParameterDirection.Output };

        List<StaffMemberPOCO> pocos =
            context.ExecuteStoreQuery<StaffMemberPOCO>("exec StaffSearch_sel @OverrideSecurity, @UserId, @SchoolYearId, @Name, @ContractorId, @SubcontractorId, @SiteId, @OrganizationRelationshipIds, @RoleTypeIds, @StaffMemberNeedsAllRoles",
                    new SqlParameter("@OverrideSecurity", overrideSecurity),
                    new SqlParameter("@UserId", userId),
                    new SqlParameter("@SchoolYearId", schoolYearId),
                    new SqlParameter("@Name", name ?? (object)DBNull.Value),
                    new SqlParameter("@ContractorId", contractorId ?? (object)DBNull.Value),
                    new SqlParameter("@SubcontractorId", subcontractor ?? (object)DBNull.Value),
                    new SqlParameter("@SiteId", siteId ?? (object)DBNull.Value),
                    new SqlParameter("@OrganizationRelationshipIds", organizationRelationshipIds == null || organizationRelationshipIds.Count() == 0 ? (object)DBNull.Value : string.Join(",", organizationRelationshipIds)),
                    new SqlParameter("@RoleTypeIds", roleTypeIds == null ? (object)DBNull.Value : string.Join(",", roleTypeIds)),
                    new SqlParameter("@StaffMemberNeedsAllRoles", staffMemberNeedsAllRoles),
                    new SqlParameter("@Page", pageNumber),
                    new SqlParameter("@RowsPerPage", rowsPerPage),
                    outputParm,
                    //new SqlParameter("@TotalRows", SqlDbType.Int) { Direction = ParameterDirection.Output },
                    new SqlParameter("@SortExpression", sortExpression ?? (object)DBNull.Value),
                    new SqlParameter("@SortDirection", sortDirection ?? (object)DBNull.Value)
                    ).ToList();

        totalRows = ((outputParm != null) && !DBNull.Value.Equals(outputParm)) ? int.Parse(outputParm.Value.ToString()) : 0;
        return pocos;
    }
}

System.Data.SqlClient.SqlException: Procedure or function 'StaffSearch_sel' expects parameter '@TotalRows', which was not supplied.

i have two tables with same schema. i have to check table1 for any updates and insert the updates or the entire row into table2, only the most recently updated row.
so basically, table2 has the unique values from table1; for the duplicate entries in table1, there is only the most recent entry in table2.
i have tried to get the most recently updated id from table1:

SELECT distinct id
FROM table1 order by time_date desc limit 1;

now i need to use this id to get the other columns from table1 and insert the row with that id, into table2.
and i have to do this for all the entries in table1.
i have to update the row in table2 if it already exists, else insert new row. i check for recent record based on the date column, time_date.
both the tables have same schema.

any help would be great.!
thank you.

DECLARE @CompletedOrderID INT;
SET @CompletedOrderID = 3;

DECLARE @CA_ID INT, @BA_ID INT, @SA_ID INT, @CIP_ID INT, @CC_ID INT;
SET @CA_ID = (SELECT CA_ID FROM COMPLETEDORDERS WHERE CompletedOrderID = @CompletedOrderID);
SET @BA_ID = (SELECT BA_ID FROM COMPLETEDORDERS WHERE CompletedOrderID = @CompletedOrderID);
SET @SA_ID = (SELECT SA_ID FROM COMPLETEDORDERS WHERE CompletedOrderID = @CompletedOrderID);
SET @CIP_ID = (SELECT CIP_ID FROM COMPLETEDORDERS WHERE CompletedOrderID = @CompletedOrderID);
SET @CC_ID = (SELECT CC_ID FROM COMPLETEDORDERS WHERE CompletedOrderID = @CompletedOrderID);
SELECT 
   co.CompletedOrderID
 , ba.Attention
 , ba.CompanyName
 , ba.StreetAddress1
 , ba.StreetAddress2
 , ba.City
 , ba.StateCode
 , ba.PostalCode
 , ba.CountryCode
 , ba.Phone
 , sa.Attention
 , sa.CompanyName
 , sa.StreetAddress1
 , sa.StreetAddress2
 , sa.City
 , sa.StateCode
 , sa.PostalCode
 , sa.CountryCode
 , sa.Phone
 FROM COMPLETEDORDERS co
 LEFT JOIN CUSTOMER_BILLING_ADDRESS ba ON co.BA_ID = @BA_ID
 LEFT JOIN CUSTOMER_SHIPPING_ADDRESS sa ON co.SA_ID = @SA_ID
 WHERE co.CompletedOrderID = @CompletedOrderID