Create a stored procedure called sp_shipping_date where the billing date is equal to the order date plus 15 days. The billing date will be an input parameter for the stored procedure. Display the order id, order date and shipped date from the Orders table, the company name from the Customers table, and the company name from the Shippers table. Use the following query to test your stored procedure to produce the result set listed below. EXEC sp_shipping_date 'yyyy-mm-dd' ----------- the answer I wrote is below, but is incorrect as no result from the query. Please assist to fix it. thanks. --------------------- create procedure sp_shipping_date (@billing_date datetime) as select Orders.OrderID, CustomerName = Customers.CompanyName,
SQL
SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.
Queries
A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.
Create a stored procedure called sp_shipping_date where the billing date is equal to the order date plus 15 days. The billing date will be an input parameter for the stored procedure. Display the order id, order date and shipped date from the Orders table, the company name from the Customers table, and the company name from the Shippers table. Use the following query to test your stored procedure to produce the result set listed below.
EXEC sp_shipping_date 'yyyy-mm-dd'
-----------
the answer I wrote is below, but is incorrect as no result from the query. Please assist to fix it.
thanks.
---------------------
create procedure sp_shipping_date
(@billing_date datetime)
as
select Orders.OrderID,
CustomerName = Customers.CompanyName,
ShipperName = Shippers.CompanyName,
Orders.OrderDate, Orders.ShippedDate
from Orders
inner join Customers on Orders.OrderID=Customers.CustomerID
inner join Shippers on Orders.ShipperID=Shippers.ShipperID
where @billing_date =DATEADD(day,15,OrderDate)
go
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
