INSERT INTO [CabalCash].[dbo].[MyCashItem] (UserNum, TranNo, ServerIdx, ItemKindIdx, ItemOpt, DurationIdx)
SELECT CharacterIdx/8, 0, 1, @item_id, @item_opt, @item_dur
FROM [Server01].[dbo].[cabal_character_table]
WHERE [Login]=1 AND [ChannelIdx]=4;
thank you its workingCode:INSERT INTO [CabalCash].[dbo].[MyCashItem] (UserNum, TranNo, ServerIdx, ItemKindIdx, ItemOpt, DurationIdx) SELECT CharacterIdx/8, 0, 1, @item_id, @item_opt, @item_dur FROM [Server01].[dbo].[cabal_character_table] WHERE [Login]=1 AND [ChannelIdx]=4;
change it: @item_id, @item_opt, @item_dur, and ChannelIdx