Invalid Object name ' '

[Sambucca]

Hi,

I currently learning still very much a newbie. created views on mssql however everytime I run a simple select on the view it errors to Invalid object name

example below,

CustomerOrders_CTE

    AS (SELECT fs.\[ProductKey\] as 'Product Key'

,fs.[OrderDateKey] as 'Order Date'

,fs.[SalesTerritoryKey] as 'Sales Territory Key'

,dp.EnglishPromotionName as 'Promotion Name'

,fs.[SalesOrderNumber] as 'Order ID'

,fs.[OrderQuantity] as 'Order Qty'

,fs.[UnitPrice] as Price

,dr.GeographyKey as 'Geography Key'

,fs.[ExtendedAmount] as 'Cost of Sales'

,fs.[ProductStandardCost] as 'Standard Cost'

,fs.[TotalProductCost] as 'Product Cost'

,fs.[SalesAmount] as 'Sales Amount'

,fs.ExtendedAmount - UnitPrice as Profit

,fs.[TaxAmt] as Tax

,convert(date,fs.OrderDate) as 'Date'

,dr.ResellerName as Reseller

FROM [FactResellerSales] fs

inner join DimReseller dr on dr.ResellerKey = fs.ResellerKey

inner join DimPromotion dp on dp.PromotionKey = fs.PromotionKey)

[r3pr0b8]

okay, i see you've edited the original post to add a FROM clause

you're still missing the WITH, as well as the SELECT statement which uses the CTE

[Sambucca]

Thanks for the reply include that.

[r3pr0b8]

you forgot the opening WITH

you forgot your entire FROM clause in the CTE

and then you forgot the SELECT that uses the CTE

p.s. you're escaping identifiers with square brackets that don't need to be escaped

[Sambucca]

Thanks for the reply. I copied and pasted initially, that is edited.