CREATE VIEW AView
AS
SELECT CAST(Name AS Varchar(50))
FROM Table

WHERE CAST(Employee.[Date] AS DATE) = CAST(GETDATE() AS DATE)

DECLARE @yourDate DATETIME
SET @yourDate = '2013-02-17'

SELECT DAY(DATEADD(MONTH, DATEDIFF(MONTH, 0, @yourDate), 0)) AS First,
       DAY(DATEADD(MONTH, DATEDIFF(MONTH, -1, @yourDate), -1)) AS Last

SELECT O.OrderID
FROM [Order] O
INNER JOIN (
   -- Add up cost per order
SELECT OrderID,
SUM(SoldQuantity * P.SalePrice) AS Total
FROM OrderLine
INNER JOIN Product P ON P.ProductID = OrderLine.ProductID     
GROUP BY OrderID
) OL ON OL.OrderID = O.OrderID
LEFT JOIN (
    -- Add up total amount paid per order
SELECT OrderID,
SUM(CashMovementValue) AS Total
FROM CashMovement

DECLARE @startDate DATETIME 
DECLARE @endDate DATETIME 
SET @startDate = DATEADD(day,-8,@enddate)
SET @endDate = @FromDate
;WITH dates AS  
( 
    SELECT @startdate  
    UNION ALL 
    SELECT DATEADD(d,1,[Date]) 
    FROM dates  
    WHERE DATE < @enddate 
) 
SELECT Date,DayName frOM dates

SELECT DATEDIFF(day,'2013-10-23','2013-10-31') AS DiffDate