Find Jobs
Hire Freelancers

Optimize MS-SQL query

R$30-90 BRL

キャンセル
投稿日: 7年以上前

R$30-90 BRL

完了時にお支払い
SELECT distinct [MISTERCHEFNET].[dbo].[Lojas].[Nome Loja] as 'Loja' ,c.[Código Vendedor] as 'Código Entregador' ,a.[Nome Funcionário] as 'Entregador' ,c.[Data Caixa] ,c.[Data/Hora Vencimento] ,(c.[Tempo Total Entrega] - c.[Tempo Preparo]) as 'Tempo Entrega' ,c.[Tempo Preparo] ,c.[Tempo Total Entrega] ,((select sum(p.[Valor]) FROM [MISTERCHEFNET].[dbo].[Contas a Pagar] p where a.[Nome Funcionário] = p.[Credor] and DATEDIFF(MONTH, p.[Data Vencimento], c.[Data Caixa]) = 1) + ((select count(x.[Nome Funcionário]) from [MISTERCHEFNET].[dbo].[Comissões] z full outer join [MISTERCHEFNET].[dbo].[Funcionários] x on x.[Código Funcionário] = z.[Código Vendedor] and x.[Loja]=[login to view URL] where DATEDIFF(MONTH, z.[Data Caixa], c.[Data Caixa]) = 0 and [login to view URL] = [login to view URL] and z.Repique=0 and z.[Código Vendedor] not like 0 and x.[Nome Funcionário] = a.[Nome Funcionário])*3)) / (select count(x.[Nome Funcionário]) from [MISTERCHEFNET].[dbo].[Comissões] z full outer join [MISTERCHEFNET].[dbo].[Funcionários] x on x.[Código Funcionário] = z.[Código Vendedor] and x.[Loja]=[login to view URL] where DATEDIFF(MONTH, z.[Data Caixa], c.[Data Caixa]) = 0 and [login to view URL] = [login to view URL] and z.Repique=0 and z.[Código Vendedor] not like 0 and x.[Nome Funcionário] = a.[Nome Funcionário]) as 'custo' ,[MISTERCHEFNET].[dbo].[Clientes].[Código Cliente] ,[MISTERCHEFNET].[dbo].[Clientes].[Nome Cliente] ,[MISTERCHEFNET].[dbo].[Clientes].[Endereço] ,[MISTERCHEFNET].[dbo].[Clientes].[Bairro] FROM [MISTERCHEFNET].[dbo].[Comissões] c full outer join [MISTERCHEFNET].[dbo].[Funcionários] a on a.[Código Funcionário] = c.[Código Vendedor] and a.[Loja]=[login to view URL] full outer join [MISTERCHEFNET].[dbo].[Clientes] on c.[Código Cliente] = [MISTERCHEFNET].[dbo].[Clientes].[Código Cliente] and [MISTERCHEFNET].[dbo].[Clientes].Loja = c.[Loja] left join [MISTERCHEFNET].[dbo].[Lojas] on [MISTERCHEFNET].[dbo].[Lojas].[Código Loja] = [login to view URL] where c.[Data Caixa] >= '2016-01-01' and c.Loja=2 and [login to view URL] = 0 and c.[Código Vendedor] not like 0 order by c.[Data/Hora Vencimento] desc;
プロジェクト ID: 11357912

プロジェクトについて

5個の提案
リモートプロジェクト
アクティブ 8年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
この仕事に5人のフリーランサーが、平均R$89 BRLで入札しています
ユーザーアバター
Hello, I have been working with a MNC based company since last ~ 5 years, as an IT BI DWH Professional. The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped me in nourishing my talent in all the technologies around these 3 layers. Below are some key areas of my skills: • Expert in SQL Server, Oracle and MS Access Databases • Expert in BO XI, Cognos and SQL Server Reporting Service (SSRS) • Expert in & designing & Implementation of end to end ETL Process using Informatica & SSIS Tools • Expert in Designing Qlikview Dashboard BI Solution • Expert in ER & Dimension Data modeling • Complete Command on PL/SQL concept e.g. Procedures, Functions, packages and complex queries. • Basic knowledge of Unix Shell scripting • Web Development using Java, CSS, and HTML ,PHP & Java Script • Expert in excel Macro • Expert in C & C ++ Programming I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. I had conducted Informatica & DWH training for a US based training organization from Nov’14 to Dec’14. We recently started our own company “Point5Nyble Your Needs, Our Dream”. We always work to provide Best Delivery with 100 % customer satisfaction Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Ashish-Point5Nyble
R$90 BRL 1日以内
4.7 (28 レビュー)
4.7
4.7
ユーザーアバター
A proposal has not yet been provided
R$90 BRL 2日以内
5.0 (7 レビュー)
3.8
3.8
ユーザーアバター
A proposal has not yet been provided
R$95 BRL 1日以内
5.0 (1 レビュー)
0.7
0.7
ユーザーアバター
Let's start! I understand what you need and you will have a 100% complete job on time. I can assure you that if you work with me once, you will always work with me for these kind of projects.
R$75 BRL 1日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
A proposal has not yet been provided
R$95 BRL 1日以内
0.0 (0 レビュー)
0.0
0.0

クライアントについて

BOUVET ISLANDのフラグ
Rio de Janeiro, Bouvet Island
5.0
56
お支払い方法確認済み
メンバー登録日:4月 16, 2013

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。