Sample Stored Procedure, Query for SSRS

CREATE PROCEDURE prCustomerOrders
@startDate DATETIME, @endDate DATETIME
AS
SELECT
c.CustomerID, c.CompanyName,
c.City, c.ContactName,
o.OrderID, o.OrderDate,
od.UnitPrice, od.Quantity,
od.UnitPrice * od.Quantity AS ExtendedPrice
FROM
Customers c
INNER JOIN
Orders o ON c.CustomerID = o.CustomerID
INNER JOIN
[Order Details] od ON o.OrderID = od.OrderID
WHERE
o.OrderDate BETWEEN @startDate AND @endDate
ORDER BY
c.CompanyName, o.OrderDate

---------------------

SELECT
S.OrderDate, DATENAME(weekday, S.OrderDate) as Weekday,

S.SalesOrderNumber, S.TotalDue, C.FirstName, C.LastName
FROM
HumanResources.Employee E
INNER JOIN
Person.Contact C ON E.ContactID = C.ContactID
INNER JOIN
Sales.SalesOrderHeader S ON E.EmployeeID = S.SalesPersonID
WHERE
(S.OrderDate BETWEEN (@StartDate) AND (@EndDate) AND
S.SalesPersonID IN (@SalesPersonID))