Thanks a lot for the reply. Its worked for me. Need your help in one more thing.

From your query, I am extracting min and max day_id's into temp table and...

Hi Serg,

Thanks for your quick reply.

Yes. Here my intention is, if the max level of table is '5', need to balance the other records in the table to the level 5.

For example: If the...

Hi Serg,

I have other query to modify the existimg code. My data is looking like this

CREATE TABLE [t_dim_product_temp](

[product_cd] [varchar](100) NOT NULL PRIMARY KEY CLUSTERED,

[product_desc] [varchar](100) NOT NULL,

[product_parent_cd] [varchar](100) NOT NULL,

[product_id]...

Thanks a lot. Your solution helped me a lot.

Hi Serg,

I have gone through the link, which you have provided in order to use the dynamic levels instead of hardcoding values. I am very new to SQL Server technology,particularly...

Hi Serg,

It worked for me. Thanks a lot for your quick response.

Instead of hardcoding the level values 1..8 can we do it dynamically based on the max level of the...

Hi Drew,

Thanks for your response. For your query on balancing of hierarchy-- we are displaying this data in a cube. For example max level hierarchy is 4. Few of the...