Recursive CTE in SQL Server that ties dollar amounts and employee population counts to an officer and the officers' direct reports, only. -- 2

Encerrado Postado há 3 anos Pago na entrega
Encerrado 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.

Java SQL Oracle Administração de Bancos de Dados Microsoft SQL Server

ID do Projeto: #28099711

Sobre o projeto

8 propostas Projeto remoto Ativo em há 3 anos

8 freelancers estão ofertando em média $152 nesse trabalho

DebasisB

Hello there, I am interested in the project. I have expertise in SQL server solution development and I can build the report exactly as per your requirement. I can design the drill-down/hierarchical report in MS Report Mais

$250 USD in 3 dias
(39 Comentários)
6.2
SqlDevelopment

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.

$140 USD in 2 dias
(53 Comentários)
5.4
sreenivas2903

Hello. Iam expertise in sql server and querying if u are interested ping me. i will solve ur recursive query

$111 USD em 1 dia
(21 Comentários)
4.5
Rajib143

I saw your job post and I am comfortable for the work. I have over 8 years of experience in .net technologies. I worked on multiple domain and most important point is that I can analyze any issue very firstly. If you Mais

$111 USD in 3 dias
(16 Comentários)
3.6
aap31374

Hello I have more than 15 years of experience in SQL Server database design, modelling, development and Administration. I have worked for database designing and modelling of complex business requirements at efficient Mais

$222 USD in 2 dias
(5 Comentários)
3.4
dhills

I am a very experienced, well trained SQL Server developer. My work frequently makes use of CTEs (recursive and otherwise). I also have a large amount of experience with hierarchical data. I would love to conquer this Mais

$30 USD in 2 dias
(0 Comentários)
0.0
zarnesc

I am a senior software engineer with 10+ years experience. I am an expert at SQL database architecture and performance.

$200 USD em 1 dia
(0 Comentários)
0.0