datahai

DROP VIEW LDW.vwFactSales;
GO

CREATE VIEW LDW.vwFactSales
AS
SELECT *,
CAST(fct.filepath(3) AS DATE) AS SalesOrderPathDate
 FROM 
OPENROWSET 
(

datahai

//create the message structure
WebVisitMessage webvisitmessage = new WebVisitMessage
{
	SessionID = SessionID,
	EventType = "visitwebsite",
	EventDateTime = dateincrement,
	URL = URL,
	Device = device
};

datahai

SELECT DATALENGTH(20120101),
        DATALENGTH(CAST(20120101 AS INT))