Daily Archives: 19/09/2014


Syteline Customer Order Review TSQL COALESCE and FOR XML PATH

Introduction Here’s one that used a few interesting things, so I thought I’d post it. Our salesman wanted a report from our Infor Syteline 8 database that he can use to review order pattern by ship to. The example below makes use of 2 functions that are quite nice. The first […]