Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE AdventureWorks2008;
- WITH ShippingTime(OrderDate,ShipDate,DaysToShip) AS
- (
- SELECT OrderDate, ShipDate,DATEDIFF(day,OrderDate,ShipDate)
- FROM Sales.SalesOrderHeader
- )
- SELECT *
- FROM ShippingTime;
Add Comment
Please, Sign In to add comment