Gloria A.E

[admin]

αυτο ειναι το sql script που τρεχουμε ετσι ωστε να συνχρονιστουν ολα τα ειδη παλι με το eshop (μηδενίζει το revision)

Κώδικας: Επιλογή όλων

Declare @Id uniqueidentifier; Declare Cur Cursor For Select GID From ESFIItem Where StringField10 Is Not Null And fCompanyCode='001'; Open Cur Fetch Next From Cur Into @Id While @@FETCH_STATUS = 0 Begin Execute Z_DSP_SYNC @Id, 0; Fetch Next From Cur Into @Id End Close Cur Deallocate Cur

[Georgia]

Κώδικας: Επιλογή όλων

Declare @Id uniqueidentifier; Declare Cur Cursor For Select GID From ESFITradeAccount Where ESFITradeAccount.[Type]=0 And fCompanyCode='001' And (Select Count(0) From ESGOUser Where ESGOUser.fCompanyCode='001' And ESGOUser.UserID=ESFITradeAccount.Code)>0; Open Cur Fetch Next From Cur Into @Id While @@FETCH_STATUS = 0 Begin Execute Z_DSP_SYNC @Id, 1; Fetch Next From Cur Into @Id End Close Cur Deallocate Cur