Tuesday, November 02, 2004

WO -SIBDB-BrainsDealer changed SQL

For some reason they (re)create new dealer, need run this sql for some data

select sibid, dealerid from csifile where dealerid=38168672570002 or dealerid=36427939879009;
update csifile set dealerid=38275357190830 where dealerid=38168672570002 or dealerid=36427939879009;

select sibid, dealerid from RingAroundReportData where dealerid=38168672570002 or dealerid=36427939879009;
update RingAroundReportData set dealerid=38275357190830 where dealerid=38168672570002 or dealerid=36427939879009;

select sibid, brainsDealerCode, fullName, usercode from SIBUser where brainsDealerCode=38168672570002 or brainsDealerCode=36427939879009;
update SIBUser set brainsDealerCode=38275357190830 where brainsDealerCode=38168672570002 or brainsDealerCode=36427939879009;




select sibid, brainsDealerCode from DealerWiseLocation where brainsDealerCode=38168672570002 or brainsDealerCode=36427939879009;
update DealerWiseLocation set brainsDealerCode=38275357190830 where brainsDealerCode=38168672570002 or brainsDealerCode=36427939879009;

select sibid, brainsDealerCode from LexusDealer where brainsDealerCode=38168672570002 or brainsDealerCode=36427939879009;
no change

No comments: