Recursive CTE in SQL Server that ties dollar amounts and employee population counts to an officer and the officers' direct reports, only. -- 2
$30-250 USD
Pago na entrega
I need a procedure/cte that correctly does the following: I have a project that involves associating employees and their charitable donations to an officer within the company so that a high level report can be provided. Distinct employee counts also need to be accounted for as well as a comparison of current day giving compared to giving at a fixed date in the past (I have that dataset separated already). However, this needs to be a drill down report meaning that if an officer is a 6th line employee (top of the list) the drill down report needs to go down to the 5th line employees that report to the 6th line. That said, each of the the employees that are 4th, 3rd, 2nd, 1st and 0 levels need to have all of their donations associated with their respective 5th line and then that 5th line will tie back to the 6th line employee.
ID do Projeto: #28099711
Sobre o projeto
8 freelancers estão ofertando em média $152 nesse trabalho
I can qualitatively help you to implement required algorithm. I am Senior SQL Developer with ten-plus years of development experience with highly extended skills in implementation of complex SQL queries.
Hello. Iam expertise in sql server and querying if u are interested ping me. i will solve ur recursive query
I am a senior software engineer with 10+ years experience. I am an expert at SQL database architecture and performance.