Project

General

Profile

Bug #760

Quét toàn bộ hàng hóa - mapping với DVCM

Added by Luc Tran Van over 4 years ago. Updated over 4 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Luc Tran Van
Start date:
12/24/2020
Due date:
% Done:

0%

Estimated time:
DATA HANGHOA LIVE AMS.txt (745 KB) DATA HANGHOA LIVE AMS.txt Luc Tran Van, 12/24/2020 02:09 PM
DATA HANGHOA LIVE AMS - FILE 02.txt (61.9 KB) DATA HANGHOA LIVE AMS - FILE 02.txt Luc Tran Van, 12/24/2020 02:51 PM

History

#1 Updated by Luc Tran Van over 4 years ago

EXEC dbo.sp_generate_inserts @table_name = 'CM_HANGHOA', -- varchar(776)
@from = 'FROM CM_HANGHOA' -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'CM_HANGHOA_DVCM', -- varchar(776)
@from = 'FROM CM_HANGHOA_DVCM' -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'SYS_GROUP_LIMIT', -- varchar(776)
@from = 'FROM SYS_GROUP_LIMIT' -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'SYS_GROUP_LIMIT_DT', -- varchar(776)
@from = 'FROM SYS_GROUP_LIMIT_DT' -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'SYS_HH_GROUP_LIMIT', -- varchar(776)
@from = 'FROM SYS_HH_GROUP_LIMIT' -- varchar(800)

#3 Updated by Luc Tran Van over 4 years ago

  • Status changed from New to Closed

Also available in: Atom PDF