終了

SQL Script

Have a database with several tables. One view/report we offer lists transactions for person. But if a certain day did not have a transaction, there is no record, and it doesn't show on a plot chart. For instance if we showed a week of transactions for Person A and they only spent on M-W-F there would be a line connecting money for each day but not dropping to 0 on axis for days T-TH-S-S.

Hope I explained the problem clear enough. We'd like a solution for this using a SQL script. We thought we could add a record between dates of transactions so they say $0 on, for example, T-TH-S-S. This way it plot on a graph. But open to suggestions.

BEFORE

1111 1 ABC $50.00 10/1/14

1112 1 ABC $90.00 10/7/14

1113 1 ABC $71.00 10/13/14

1114 1 ABC $95.00 10/20/14

AFTER

1111 1 ABC $50.00 10/1/14

0000 1 ABC $0.00 10/2/14

0000 1 ABC $0.00 10/3/14

0000 1 ABC $0.00 10/4/14

0000 1 ABC $0.00 10/5/14

0000 1 ABC $0.00 10/6/14

1112 1 ABC $90.00 10/7/14

0000 1 ABC $0.00 10/8/14

0000 1 ABC $0.00 10/9/14

0000 1 ABC $0.00 10/10/14

0000 1 ABC $0.00 10/11/14

0000 1 ABC $0.00 10/12/14

1113 1 ABC $71.00 10/13/14

Also if we go this route we can't have these $0 records count as a 'real' transaction so some sort of flag or new field. Because in another view, for CRM purposes, it will show days since last transaction - to help with sales nudge. Could make TransID all zeros then skip this when running this script (IF TransId ='0000' etc).

Field EX: TransID, CustID, Customer, Cost, Date

Thanks.

Need asap. Will be paid immediately.

スキル: データベース管理, MySQL, SQL

さらに表示: sales person on line, route graph, problem graph, make a graph chart, graph problem, connecting to a mysql database, make a line graph, sql script , mysql sort field, last days sql, date mysql sort, transactions script, route sales, sql script mysql, mysql graph database, add tables sql, 1111, graph mysql, chart script, sales report script

採用者について:
( 8件のレビュー ) Lee, United States

プロジェクトID: #6601800

26人のフリーランサーが、このジョブに平均$20/時間で入札しています

leomedina01

Hi sir, My name is Leonardo Medina, and I´m from Brazil. I have lots of experience in PHP. Please drop me a line, so we can discuss this project in details and I can make a proper bid. I'm an experienced Web D もっと

$16 USD / 時間
(87件のレビュー)
6.4
codetod

Hi SQL expert here with 12+ years of experience. I assume you already have stored procedure with two date parameters, and procedure returning the data between these dates. What we need to do is to have a temp ta もっと

$12 USD / 時間
(80件のレビュー)
6.4
feninsoftech

Hi, This can be achieved by Populating all days and then a LEFT join with data table and returning 0 where NULL. I have 8.5 years experience in SQL Server 2005|2008|2008R2|2012 and involve in designing databases, もっと

$22 USD / 時間
(50件のレビュー)
6.7
ibbuzz

Are you using this stored procedure? Do you want the output or want to insert these missing days data in the table? Do let me know i can start this right now. Thanks

$15 USD / 時間
(51件のレビュー)
5.3
NTechcorporate

Expert Here Dear Sir, We have gone through project description. Our team is very much interested to carry your job by targeting on time delivery along with perfection of project. [login to view URL] もっと

$11 USD / 時間
(4件のレビュー)
5.4
kevinross100

Hi there, This is quite a common problem to face and an easy one to work around. You have a couple of options which I am happy to talk you through or I could show you both on your server with screen sharing. Oh a もっと

$14 USD / 時間
(レビュー1件)
3.2
alitoruiz

Hi, the best way to do this... would be insted of doing transactions->days; would be to do days->transactions; this way you can eventually get day (1-10) 0 transaction... and you didn't insert any fake data to your tab もっと

$11 USD / 時間
(2件のレビュー)
2.8
MarcoAGarcia

I have more than 30 years experience with SQL (Transact SQL, Oracle PL/SQL, MySQL, MS-Access SQL, etc.), the last 20 working for international organizations (Inter-American tropical Tuna Commission , in San Diego, CA, もっと

$38 USD / 時間
(2件のレビュー)
2.9
edwinfmn

Hi, I would like to help you, I understood what you need and I don't think it's difficult. If you accept me, I will send this funcion or script by today. Please contact me to discuss the details. And always you can もっと

$20 USD / 時間
(3件のレビュー)
2.4
claytonEtillman

Hi! My name is Clayton. I see that you need a SQL solution to feed $0's to your graph of transactions so that the line connecting the days doesn't skip days on which the employee did not have a transaction. I alread もっと

$14 USD / 時間
(2件のレビュー)
1.6
abubakar88

Hi employer, Hope you are doing good. I have rich experience in databases writhing queries and report making. I understand you requirement and eager to work with you. We can further discuss the project, send me a ms もっと

$12 USD / 時間
(レビュー1件)
0.4
martinbelic

Hello, I see no problem to do this. Contact me and after I recive the table you want to transform I can write you sql script to do this. Have a great day!

$15 USD / 時間
(0件のレビュー)
0.0
ACETYLENE

A proposal has not yet been provided

$11 USD / 時間
(0件のレビュー)
0.0
sitedataview

Hello! My name is Kimberly Killian and I am with SiteDataView. I specialize in Web and Database Solutions. I am located in Metro Detroit which is in the Eastern time Zone. I have over 20 years experience in the もっと

$55 USD / 時間
(0件のレビュー)
0.0
rlpenn

I hope that you have already found the solution, but if you still need help I can make this work. I have programmed in Access/SQL/VBA for over 15 years. I speak Texas English. Contact me.

$12 USD / 時間
(0件のレビュー)
0.0
kumarir01

In my understanding, the project requirement is to add records in between the real transaction ,where there is a gap to display the record in Chart without dropping to 0. I would see the point for this requirement and もっと

$12 USD / 時間
(0件のレビュー)
0.0
yaradahlia

Good day to you. First of all let me say that your approach in adding records with zero is wrong, you are introducing garbage data into your database. I propose to you the following. We construct a table with day もっと

$8 USD / 時間
(0件のレビュー)
0.0
robertsanda

I have experience in designing and querying database, in software development and business analysis.

$11 USD / 時間
(0件のレビュー)
0.0
Pehu

Hi, i had 7 years of exp. in Sql 2000,2005,2008 .in past also done many challenging task in sql .Definitely complete ur task on time with quality. Give a chance to proof my self

$8 USD / 時間
(0件のレビュー)
0.0
BretCamble

I build queries like this all the time for charting purposes. There's a trick I use that involves subqueries and a separate time table. I know your issue very well, as I run into it a lot when feeding data to jQuery-ba もっと

$12 USD / 時間
(0件のレビュー)
0.0