SELECT Customer.[Customer Name], Customer.Region, Orders.[Order ID], Orders.[Order Amount], Orders.[Order Date], Customer.Country
FROM Xtreme2005DB.dbo.Customer Customer LEFT OUTER JOIN Xtreme2005DB.dbo.Orders Orders ON Customer.[Customer ID]=Orders.[Customer ID]
WHERE (Customer.[Customer Name] like @Customer_Name) And Customer.Region IN (@Region) And (Orders.[Order Date] >= @Date_RangeStart And Orders.[Order Date] <= @Date_RangeEnd)

ORDER BY Customer.Region