I am kind of new in writing Procedure's or dynamic SQL's. Any suggestion that you could help me out with.

This manual work is just making me go crazy 🙁

Hi,

Thanks for the response and all those responses should certainly help. I apologize for the mistakes as this is my first post :(.

Hi,

Thanks for the response. I have given some details below. Let me know if you need more information.

Source Table:

CREATE TABLE [dbo].[CMC_BLCO_COMM_ITEM](

[BLEI_CK] [int] NOT NULL,

[CSPI_ID] [char](8) NOT NULL,

[PMFA_ID] [char](2) NOT NULL,

[BLCO_SEQ_NO]...