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).