Hello Experts,
I have a problem with OPENROWSET:
exec('
select x.*,getdate() as datum
from openrowset(''SQLOLEDB'',''SERVER1'';''user'';''pw'',''
select anr,alist,aidnr,
(select sum(bpstueck) from nachschau.dbo.bestkp where bpbeltyp=''B'' and bpidnr=mlidnr)
from main.dbo.table1
left join...