Oh it’s just for me as a learner 😉

What I did is follow Keith’s instruction like below:

insert TBL1

select 3, Col2, Col6, Col4, Col5, Col6 -- replace Col3 with Col6

from TBL1

where...

Thanks Sean, It worked!.

If you know how to do it then it becomes very simple 🙂

Thanks all for the helps

Thanks for reply

Unfortunately this is our existing table structure – I can’t change it.

Here is my revised request again. Please help

CREATE TABLE [dbo].[MYTABLE]

(

[TND_CD] [smallint] NOT NULL,

[ACCPT_FOR_SLS_FG]

[STR_ID] [int] NOT NULL,

[HIER_ID] [int] NOT NULL,

[LOC_ID] [int]NOT NULL

)

CONSTRAINT [PK_MYTABLE] PRIMARY KEY CLUSTERED

(

[TND_CD] ASC,

[STR_ID] ASC,

[HIER_ID] ASC,

[LOC_ID]...

Thaks all for the help.

It's works great! Now can I ask more?

Sorry for not adding them all in once - just try to make it simple for myself 🙂

Col1, Col2,...

Thanks SteveB.

Actually, I didn't explain it clearly.

We are going to create a link table, but for each location specific tables we need add indetification ID to it. anyway, I have...

rbarryyoung resolved my issue and Anirban Paul helpped me learning more

Thank you both for the helps