thank you very much, i shall execute it tonight.

by the way ftvalue is there in insert, never mind, i can update it later

Dear all,

sorry to post the whole code.

1) I have to take max of all attributes in HRM_STAND_RAW

for each coilid in cool_measure_raw

2) FTValue returns the highest value amongst the two...

I have deleted many attributes in inserting,fetching

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- =============================================

-- Description:<This procedure GETS CT DEVIATED COILS FROM COOL MEASURE RAW THEN

-- GETS THE RELAVANT INFO FROM HRM_STAND_RAW,...

Thank you so much for clear cut explanation.

Thanks you so much.

I understand the process that is to be followed for Data source creation,then cube creation,then mining.I also understand what is strt schema and snow flake schema.

I am...