RaphaelVeiga
Member
Hello,
I am using SQL Developer to extract the data from JDE, but I installed the SQL Server Management Studio recently in my PC, as it faster and allow me to connect to excel
I tried to use the same query from the SQL Developer in SQL Server Management Studio, however the code SDROUT doesn't exit in SQL Server
The code which I am using
select SDROUT, SDKCOO, SDSRP2,SDDOCO, SDDCTO,SDDOC,SDDCT,SDAN8,SDECST/100,SDAEXP/100,SDLITM,SDPQOR,SDADDJ,SDMCU,SDPQOR,SDPQOR, ABAC16,ABAC15, sdnxtr,sdcrcd,sdcrr,imbuyr
FROM stage.dbo.F4211
JOIN stage.dbo.f0101 on sdan8=aban8 JOIN stage.dbo.F4101 on sditm=imitm
Does someone knows which field would represent SDROUT in SQL Server?
regards,
I am using SQL Developer to extract the data from JDE, but I installed the SQL Server Management Studio recently in my PC, as it faster and allow me to connect to excel
I tried to use the same query from the SQL Developer in SQL Server Management Studio, however the code SDROUT doesn't exit in SQL Server
The code which I am using
select SDROUT, SDKCOO, SDSRP2,SDDOCO, SDDCTO,SDDOC,SDDCT,SDAN8,SDECST/100,SDAEXP/100,SDLITM,SDPQOR,SDADDJ,SDMCU,SDPQOR,SDPQOR, ABAC16,ABAC15, sdnxtr,sdcrcd,sdcrr,imbuyr
FROM stage.dbo.F4211
JOIN stage.dbo.f0101 on sdan8=aban8 JOIN stage.dbo.F4101 on sditm=imitm
Does someone knows which field would represent SDROUT in SQL Server?
regards,