I am trying to write the query to compare yesterday's sales and previous fiscal year same day sales as following, but got error message :

Server: Msg 107, Level 16, State...

I am sorry, I didn't explain it clear. I need this column with 1 decimal point only. If the source loads more than 1 decimal point, the column has...

Thank you Hendra, here's the scripts for all 4 table creation:

------------------------------

The MenuMixFacts:

CREATE TABLE [micros].[MenuMixFacts] (

[MmfDateKey] [int] NOT NULL ,

[MmfLocKey] [int] NOT NULL ,

[MmfMIKey] [int] NOT NULL ,

[MmfQtySold] [int] NULL ,

[MmfWasteCnt]...

I re-create the indexed view by:

----------------

SET QUOTED_IDENTIFIER ON

SET ARITHABORT ON

SET CONCAT_NULL_YIELDS_NULL ON

GO

SET ANSI_NULLS ON

SET ANSI_PADDING ON

SET ANSI_WARNINGS ON

GO

SET NUMERIC_ROUNDABORT OFF

setuser N'micros'

GO

Create View vwBKCMenuMix WITH SCHEMABINDING

AS

SELECT

micros.LocationDimension.LcdStoreNum,

...

I am sorry, can you tell me how to change the data type in a view?

I end up with drop the view and re-create by

---------------------------------

Create View vwBKCMenuMix WITH SCHEMABINDING

AS

SELECT

...

The data types of 5 columns are :

LcdStoreNum char(7),

MidMINum int,

DtdBusdate smalldatetime,

MidMiName varchar (26),

LcdEntityName varchar (50)

The script I used to create the view is :

-----------------------------------------

SELECT

micros.LocationDimension.LcdStoreNum,

micros.MIDimension.MidMINum,

micros.DateDimension.DtdBusDate,

...