Hi,

If I give you starting 5 to 10 rows of the merchandise week table stmts is that enough to test?

Something like below.........

insert into dbo.T_AGGR_MERCHANDISING_WEEK_DIM(MERCHANDISING_WEEK_DIM_ID,MERCHANDISING_WEEK,MERCHANDISING_YEAR,

MERCHANDISING_WEEK_START_DATE,MERCHANDISING_WEEK_END_DATE)

values (186,'wk27',2012,2012-07-01 00:00:00:000,2012-07-07 00:00:00:000),

values (187,'wk28',2012,2012-07-08 00:00:00:000,2012-07-14 00:00:00:000),

values (188,'wk29',2012,2012-07-15 00:00:00:000,2012-07-21 00:00:00:000),

values (189,'wk30',2012,2012-07-22 00:00:00:000,2012-07-28 00:00:00:000),

values (190,'wk31',2012,2012-07-29 00:00:00:000,2012-08-04 00:00:00:000),

values (191,'wk32',2012,2012-08-05 00:00:00:000,2012-08-11 00:00:00:000),

values (192,'wk33',2012,2012-08-12 00:00:00:000,2012-08-18 00:00:00:000),

values (193,'wk34',2012,2012-08-19 00:00:00:000,2012-08-25 00:00:00:000),

Thanks

Gopi