SQL statement for generating & Send Activity reports to related supervisor and subordinates using sql agent

Hi Friends,

Can any one help me?

i am just searching sql statement/code for send hierarchical level report in management.

In my case we have Sr.Manage/GM/AVP will get daily activity reports of his/her all subordinates.

sql server send all activity report to concern team head daily at fixed time (Ex. at 12am every day).