EBOI
9/29/2017 - 8:26 AM

Skopiowanie użytkownika z innego EBOI

Skopiowanie użytkownika z innego EBOI

INSERT INTO Appuser 
SELECT * FROM E3_PROD_GMINA_ALEKSANDRW_DZKI_26994_.dbo.Appuser WHERE usr_Login = 'EBOI_xc79_testPlatnosci1'


INSERT INTO CustomerWebCreationData
SELECT * FROM E3_PROD_GMINA_ALEKSANDRW_DZKI_26994_.dbo.CustomerWebCreationData WHERE cwcd_Id IN 
(SELECT cus_CreationData_cwcd_ID FROM E3_PROD_GMINA_ALEKSANDRW_DZKI_26994_.dbo.customer WHERE cus_EID = 'testPlatnosci1')

INSERT INTO Customer 
SELECT * FROM E3_PROD_GMINA_ALEKSANDRW_DZKI_26994_.dbo.customer WHERE cus_EID = 'testPlatnosci1'