DSXchange

it is exactly similar to this query here....

Select
dept_id,
department_name,
sum(salary)
From
employee
group by
dept_id,
department_name

Hi, In one of my ODBC sources am having an user defined SQL Query with a group by clause in it. Inspite of the source definition having all the columns required the job fails giving the following error message : "SQL statement has incorrect number of result columns" The sql works fine and ...