• SQL Query - Sage Intelligence - Custom Container

    Greetings SI & SQL Gurus! I built customer SI containers for tables containing UDFs as part of a larger project. Some of those UDFs are date fields, which are typically null. This doesn't present a challenge for Sage, SQL, or the custom Crystal Reports…
  • CSV export repeats headers with each field value

    I know this is going to be a really simple answer... when I export my header comes out on each export line preceding the fields that are being exported. I want the header line to export in csv in the 1st line, with the record lines underneath. wa…
  • Microsoft query to export time card data into excel?

    Can someone tell me what table/s I need to include to export the time card data for a job code using Microsoft query? When I select various tables thus far, no data is showing up. I know I can export the time card report to excel directly, but the data…