1 2
| bcp "select 'D' as '@type',( SELECT ltrim([417].[dbo].[orsrg].regel) as '@number', ltrim([417].[dbo].[orsrg].ordernr) as 'OrderNumber', [417].[dbo].[orkrg].docnumber as 'YourRef', [417].[dbo].[orkrg].debnr as 'Account', convert(nvarchar(10),[417].[dbo].[bacodiscussions].ModifiedDate ,120) as 'Date', [417].[dbo].[orsrg].artcode as 'Item/Code', CAST([417].[dbo].[orsrg].esr_aantal AS INT) as 'Quantity' FROM [417].[dbo].[orkrg] left join [417].[dbo].[orsrg] on [417].[dbo].[orkrg].ordernr=[417].[dbo].[orsrg].ordernr left join [417].[dbo].[bacodiscussions] on [417].[dbo].[orkrg].DocAttachmentID=[417].[dbo].[bacodiscussions].ID WHERE [417].[dbo].[orkrg].ord_soort = 'V' AND [417].[dbo].[orsrg].ar_soort = 'V' AND [417].[dbo].[orkrg].afgehandld = 0 AND ISNULL([417].[dbo].[orkrg].selcode,'') = 'SE' AND [417].[dbo].[orkrg].Ordbv_afgd=1 AND ISNUMERIC([417].[dbo].[orkrg].docnumber)=1 AND GETDATE()>= [417].[dbo].[bacodiscussions].ModifiedDate-1 AND [417].[dbo].[orkrg].fakdebnr=100000 FOR XML PATH('Line'), TYPE ) FOR XML Path('Logistic'),Root('XML')" queryout C:\EXACT\XML_ADV_LOG\Prepa.xml -SDIAI1824-1 -T -c
copy /b C:\EXACT\XML_ADV_LOG\Header.xml+C:\EXACT\XML_ADV_LOG\Prepa.xml C:\EXACT\XML_ADV_LOG\XMLRealization.xml |
Partager