Project

General

Profile

Support #527

Khi chạy script Insert data người dùng lên môi trường LIVE. Quên chưa chạy script insert những nhân viên mới (317 nhân viên được đồng bộ mới)

Added by Luc Tran Van almost 5 years ago. Updated almost 5 years ago.

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

0%

Estimated time:
DATA NHAN VIEN CHUA DUOC DONG BO QUA AMS.xlsx (42.1 KB) DATA NHAN VIEN CHUA DUOC DONG BO QUA AMS.xlsx Luc Tran Van, 10/26/2020 01:08 PM
SCRIPT IMPORT DANH SACH NHAN VIEN BI THIEU.txt (107 KB) SCRIPT IMPORT DANH SACH NHAN VIEN BI THIEU.txt Luc Tran Van, 10/26/2020 03:58 PM
SCRIPT IMPORT DANH SACH NHAN VIEN CON SOT (317 NHAN VIEN).txt (211 KB) SCRIPT IMPORT DANH SACH NHAN VIEN CON SOT (317 NHAN VIEN).txt Luc Tran Van, 10/26/2020 04:09 PM

History

#3 Updated by Luc Tran Van almost 5 years ago

EXEC dbo.sp_generate_inserts @table_name ='CM_EMPLOYEE',
@from = 'FROM CM_EMPLOYEE WHERE EMP_CODE IN (''03996'',''04215'',''03982'',''04241'',''04402'',''04184'',''04234'',''04406'',''04378'',''04098'',''04453'',''04434'',''04470'',''04474'',''04513'',''04516'',''04521'',''04203'',''04102'',''04338'',''04313'',''04353'',''04401'',''04435'',''04397'',''04269'',''04111'',''04468'',''04501'',''04471'',''04459'',''04445'',''04124'',''04175'',''04042'',''04258'',''04396'',''04149'',''04446'',''04112'',''04093'',''04502'',''04121'',''04110'',''03994'',''04289'',''04497'',''04506'',''04281'',''04498'',''04481'',''04262'',''04223'',''04118'',''04263'',''04335'',''04363'',''04062'',''04457'',''04145'',''04086'',''04346'',''04465'',''04078'',''04414'',''04508'',''03991'',''04049'',''04369'',''04109'',''04424'',''04188'',''04296'',''04147'',''04074'',''04487'',''04160'',''04389'',''04300'',''04407'',''04031'',''04280'',''04198'',''04239'',''04058'',''04478'',''04385'',''04035'',''04399'',''04193'',''04105'',''04161'',''04013'',''04341'',''04114'',''04106'',''04133'',''04103'',''04477'',''04440'',''04347'',''04472'',''04322'',''04245'',''04148'',''04180'',''04209'',''04012'',''04426'',''04195'',''04169'',''04286'',''04116'',''04490'',''04451'',''04357'',''04492'',''04113'',''04001'',''04129'',''04069'',''04356'',''04327'',''04303'',''04437'',''04514'',''04210'',''04372'',''04072'',''04052'',''04187'',''04512'',''04252'',''04251'',''04452'',''03987'',''04273'',''04108'',''04267'',''04183'',''04367'',''04360'',''04132'',''04293'',''04211'',''04304'',''04257'',''04090'',''04382'',''04427'',''04282'',''04480'',''04441'',''04244'',''04361'',''04065'',''04060'',''04179'',''04238'',''04276'',''04140'',''04250'',''04489'',''03961'',''04037'',''04087'',''04150'',''04442'',''04418'',''04499'',''04354'',''04315'',''04134'',''04495'',''04443'',''04081'',''04247'',''04217'',''04006'',''04119'',''04253'',''04395'',''04017'',''04122'',''04099'',''04379'',''04486'',''04473'',''04057'',''04155'',''04275'',''04055'',''04503'',''04024'',''04292'',''04167'',''04362'',''04227'',''04201'',''04444'',''04192'',''04436'',''03986'',''04033'',''04270'',''04025'',''04491'',''04002'',''04422'',''04429'',''04298'',''04463'',''04358'',''04034'',''04004'',''04228'',''04272'',''03973'',''04095'',''04509'',''04174'',''04484'',''04299'',''04415'',''04089'',''04125'',''04265'',''04094'',''04190'',''04015'',''04390'',''04417'',''04349'',''04430'',''04312'',''04220'',''04404'',''04283'',''04461'',''04020'',''04483'',''04405'',''03985'',''04412'',''04216'',''04373'',''04219'',''04431'',''04500'',''04073'',''04028'',''04212'',''04365'',''04277'',''04318'',''04260'',''04364'',''04504'',''04079'',''04176'',''04494'',''04377'',''04019'',''04274'',''04271'',''04343'',''04085'',''04123'',''04092'',''04467'',''04479'',''04323'',''04048'',''04476'',''04054'',''04051'',''04496'',''04413'',''04182'',''04314'',''04475'',''04482'',''04284'',''04462'',''04488'',''04202'',''04246'',''04165'',''04146'',''04295'',''04261'',''04084'',''03999'',''04394'',''04009'',''04409'',''04131'',''04080'',''04040'',''04297'',''04171'',''04331'',''04505'',''04336'',''04305'',''04469'',''04279'',''04115'',''04425'',''04018'',''04450'',''04151'',''04126'',''04254'',''04158'',''04290'',''04339'')'

#4 Updated by Luc Tran Van almost 5 years ago

  • Status changed from New to Closed

Also available in: Atom PDF