Thanks Phil Its works fine for me

Thanks

Manoj

• This reply was modified 9 months ago by  manojsemwal1 40990.

Dear Phill,

Sorry for that, in my previous post column values are shifted .kindly see the revised  values

INSERT #TempSOR_mb
(
    item_id
   ,subitem_id
  ...

Sorry Jeff  for the  inconvenience. kindly see the below code

INSERT INTO [dbo].[10_SOR_MB]
           ([item_id]
    ...

table data is like this and out put of the data is mentioned in earlier post

I have a GUI where the user has to fill in the data activity- and sub-activity-wise in the form of length, width, and height of the structure measurement  as per...

Thanks Jeff Moden,

Its working fine.

Manoj