what is logging in ssis | event handlers in ssis | ssis tutorial Part 56

[@thee_draagon]

Thank you for the content

[@ssunitech6890]

Thanks for your appreciation

[@roshnisingh7661]

Very common interview question..

[@ssunitech6890]

Thanks dear..
Please share to others

[@arun_sql_msbi480]

Hi Sir,
I have a two tables one is employee other is dept
Employees table
Eid name gender salary date-details departmentId
Department table
DeptId deptName
Query:- Find highest salary in each department wise and year wise

[@ssunitech6890]

1. Department wise highest salary-
Select d deptname,max(salary) as salary
From employees as e
Inner join department as d
On e.deptid=d deptid
Group by d.deptname
2.year wise highest salary-
Select year(date) as year ,max(salary) as salary
From employees as e
Group by year(date)

[@arun_sql_msbi480]

@@ssunitech6890 Thanks for reply Sir,
But Sir we need details of employee as well Max salary year wise and development wise
Like I'd name gender and Max salary department wise and year wise
Problem is that if select a detailes of employee and then Max and group wise then getting error
So please help me out in this regard

[@vaibhavsingh4043]

Nice video 👌👌

[@ssunitech6890]

Thanks

[@ramprakash7883]

Nice

[@ssunitech6890]

Thanks

[@gobikak7031]

Can we remove logging in multiple child package .

[@ssunitech6890]

Yes you can disable that.

[@gobikak7031]

Is there any option is available for child package loggings deletion in a dynamic way