How can I troubleshoot MSSQL node inconsistencies and automate CSV email attachments in n8n?

Hi,

I'm experiencing inconsistent execution with my MSSQL node. Sometimes it returns the response:

'It appears that no active employees were found who match the criteria specified for the tasks required for the project.'

Other times, it responds with detailed employee data and cost calculations. Below is the chatInput sent to the webhook trigger node:

"Employee information is saved in the table ‘dbo.Employee’. The employee’s first name is in the column ‘emp_firstName’ and id in emp_ID. Employee status is the column ‘emp_status’ and a value of ‘Active’ indicates the employee is currently active.

Skill information is saved in the table ‘dbo.Skill’. The Skill ID column is ‘skl_ID’ and the Skill name column is ‘skl_desc’.

Skills of each employee are saved in the table ‘dbo.vw_EmployeeSkill’. This table is related to the Employee table by the column ‘esk_employeeID’ and to the Skill table by the column ‘esk_SkillID’. This also contains years of experience in the skill in column esk_yearsExp, skill level in the column sklLvl_Name, skill name in the column skl_Desc.

Rates of employees are saved in the table ‘dbo.EmployeeBillRate’. This table is related to the employee table by the column ‘ebr_employeeID.Rate’ information is the column ‘ebr_billRate’

The employee schedule is in ‘dbo.Schedule’ with employee id in the column ‘sch_employeeID’. Their schedule date range is between columns ‘sch_fromDateTime’ and ‘sch_toDateTime’.

Given the above information, can you recommend all employees for the following project with a budget of $6000? . Tasks for the project are listed below:

Task 1: Auditing; Skills required: SAP and Spanish; Hours: 40

Task 2: Tax Filing; QuickBooks: Hours 12

Steps to recommend employees:

Step 1: Get details of all employees who are active and available based on their current schedule for the specified project duration with Spanish and SAP skills. Include employee ID, employee name, list of skills along level of each skill, employee bill rate and employee level in the results.

Step 2: Analyze employee details and recommend employees for each task. Ensure that the project is within budget with the selected employees. Show details of recommended employees including employee name, skill level, rate for each recommended employee.

Step 3: Calculate and show the total cost of the project using employee bill rates."

When the execution is successful, I receive the following response:

YAMLCopied
Employee: JUAN
    Employee ID: 1000
    Skills:
        SAP: Novice (Rates: 245, 290, 370)
        Spanish: Native/Bilingual (Rates: 245, 290, 370)

Employee: SAMANTHA
    Employee ID: 1001
    Skills:
        Spanish: Professional Working Proficiency (Rates: 270, 295, 285)

Employee: MARK
    Employee ID: 11002
    Skills:
        SAP: Novice (Rates: 300, 330, 450)

Employee: ANGEL
    Employee ID: 1008
    Skills:
        SAP: Beginner (Rates: 100, 175)
        Spanish: Professional Working Proficiency (Rates: 215, 220)

Employee: NANCY
    Employee ID: 11098
    Skills:
        SAP: Novice (Rates: 200, 205, 210)
        Spanish: Professional Working Proficiency (Rates: 200, 210)

Other candidates with appropriate skills can be similarly listed.

Step 2: Analyzing Employee Details and Recommendations for Each Task

For the project, employees are allocated based on required skills and the $6000 budget constraint.

Task Breakdown:

BASHCopied
Task 1: Auditing (SAP and Spanish); Hours: 40
Task 2: Tax Filing (QuickBooks); Hours: 12

Budget Analysis:

We need to ensure the total cost does not exceed the budget.

Recommendations for Task 1: Auditing

BASHCopied
Select 1 Employee for SAP (Mark) and 1 Employee for Spanish (Samantha)
    Employee: JUAN: SAP (Rate: 290, Work Hours 20)
    Employee: SAMANTHA: Spanish (Rate: 295, Work Hours 20)

Total Cost for Auditing:
    JUAN: 20 hours * 290 = $5800
    SAMANTHA: 20 hours * 295 = $5900 Total for Task 1: $5800 + $5900 = $11700 (Over Budget)

Alternative for Auditing (Change Employee Rate):

BASHCopied
Recommendation:
    Replace SAMANTHA with a candidate using a lower rate, selecting other options from the list to stay within budget.

Task 2: Tax Filing

BASHCopied
Employee: NANCY (Best Option for Quickbooks)
    Bill Rate: 210
    Work Hours: 12

Total Cost for Tax Filing:

BASHCopied
NANCY: 12 hours * 210 = $2520

Overall Cost Summary:

BASHCopied
Final Calculations should consider:
Total Cost = Cost for Auditing + Cost for Tax Filing.
Compare against budget limits.

Conclusion:

BASHCopied
Once you finalize the employees and their rates, provide the modules (skills) offered, hours they can work on and bill rates acceptable towards building the correct tax filing strategy and retain long mentorship values on task sustainability. Adjust as needed to ensure the project cost stays under $6000.

I also need assistance with:

-> Generating a CSV file after executing the query.

-> Attaching and sending this CSV file via email.

Screenshot (attached) shows the CSV format requirements:

[]

Workflow Overview:

BASHCopied
(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

My current workflow uses several nodes including Webhook, AI Agent, Respond to Webhook, Microsoft SQL, and more (detailed JSON below). The issue may be in intermittent query conditions or connection stability. I've also checked that parameter assignments and middleware nodes (like Window Buffer Memory and Edit Fields) are configured appropriately.

Could anyone help troubleshoot the MSSQL inconsistency and suggest the best approach to automate creating a CSV file and sending it as an email attachment in this n8n setup?

---

Information on my n8n setup:

• n8n version:
• Database (default: SQLite):
• n8n EXECUTIONS_PROCESS setting (default: own, main):
• Running n8n via (Docker, npm, n8n cloud, desktop app):
• Operating system:

Thanks in advance for your help!