Here are the table definitions, index and constraints...

CREATE TABLE [dbo].[DIM_ACCT_DATE](

[ACCT_DT_LVL_1] [char](25) NOT NULL,

[ACCT_DT_LVL_2] [char](25) NOT NULL,

[ACCT_DT_LVL_3] [char](25) NULL,

[ACCT_DT_CD] [char](25) NOT NULL,

[ACCT_MO_YR] [smalldatetime] NULL,

[ACCT_DT_ORDER] [int] NOT NULL,

[ACCT_DT_OPERATOR] [char](1) NOT NULL,

[ACCT_DT_CALC] [varchar](500)...

Thanks for your reply... But can u tell me how it should be done without a loop thru store proc...