Find Jobs
Hire Freelancers

Expand data on SQL Database

$30-250 USD

În desfășurare
Data postării: circa 11 ani în urmă

$30-250 USD

Plata la predare
I have information in some database tables. I would like to do two things (in two separate applications) 1) Expand the information on the tables by adding columns. For example: A) I have tables with the names AAPL, MSFT and CSCO, all with the same rows: INDEX,OPEN,CLOSE,HIGH,LOW,VOLUME B) I provide the program with a XML file like this: _MOVING_AVERAGES SELECT [INDEX],[OPEN],[CLOSE],HIGH,LOW,VOLUME, (SELECT AVG([CLOSE]) FROM {1} B WHERE B.[INDEX] > (A.[INDEX] - 5) AND B.[INDEX] (A.[INDEX] - 10) AND B.[INDEX] (A.[INDEX] - 5) AND B.[INDEX] (SELECT AVG([CLOSE]) FROM {1} B WHERE B.[INDEX] > (A.[INDEX] - 10) AND B.[INDEX] < A.[INDEX]) THEN 'YES' ELSE 'NO' END AS MA5OVERMA10 FROM {1} A MSFT,AAPL,CSCO C) The program will create 3 new tables MSFT_MOVING_AVERAGES, AAPL_MOVING_AVERAGES, CSCO_MOVING_AVERAGES with the original columns plus MA5, MA10 and MA5OVERMA10. Note that the program needs to iterate through all the values in the VARIABLES.1 tag, and that it must replace the {1} in the query for the different values MSFT, AAPL, CSCO. It also needs to create the table, but I think a SELECT INTO statement would take care of that. This will be a command line application that takes the following parameters: /// /// args: (case sensitive) /// -src:[Path of the XML file] /// -S:[Db Server Name] /// -D:[Db Name] /// -U:[Db User Id] /// -P:[Db Password] /// -E ;use Db Integrated Security 2) Another program that will generate some very specific reports that I provide in a similar format to the one in the previous requirement. a) I provide an XML configuration file like this: SELECT {4}, B.[OPEN] AS {2}_OPEN_D1, B.[CLOSE] {2}_CLOSE_D1, [login to view URL] AS {2}_HIGH_D1, [login to view URL] AS {2}_LOW_D1, C.[OPEN] AS {3}_OPEN_D1, C.[CLOSE] AS {3}_CLOSE_D1, [login to view URL] AS {3}_HIGH_D1, [login to view URL] AS {3}_LOW_D1, D.[OPEN] AS {4}_OPEN_D1, D.[CLOSE] AS {4}_CLOSE_D1, [login to view URL] AS {4}_HIGH_D1, [login to view URL] AS {4}_LOW_D1 FROM {1} A LEFT JOIN {1} B ON A.[INDEX] = B.[INDEX]+1 LEFT JOIN {2} C ON A.[INDEX] = C.[INDEX] + 1 LEFT JOIN {3} D ON A.[INDEX] = D.[INDEX] + 1 AAPL,MSFT,CSCO AAPL MSFT CSCO "CASE WHEN ([login to view URL] - [login to view URL]) > .1 THEN 'TRADE' ELSE 'NO_TRADE' END AS LABEL", "CASE WHEN ([login to view URL] - [login to view URL]) > .2 THEN 'TRADE' ELSE 'NO_TRADE' END AS LABEL", "CASE WHEN ([login to view URL] - [login to view URL]) > .3 THEN 'TRADE' ELSE 'NO_TRADE' END AS LABEL", "CASE WHEN ([login to view URL] - [login to view URL]) > .4 THEN 'TRADE' ELSE 'NO_TRADE' END AS LABEL "CASE WHEN ([login to view URL] - [login to view URL]) > .5 THEN 'TRADE' ELSE 'NO_TRADE' END AS LABEL", "CASE WHEN ([login to view URL] - [login to view URL]) > .6 THEN 'TRADE' ELSE 'NO_TRADE' END AS LABEL", "CASE WHEN ([login to view URL] - [login to view URL]) > .7 THEN 'TRADE' ELSE 'NO_TRADE' END AS LABEL", "CASE WHEN ([login to view URL] - [login to view URL]) > .8 THEN 'TRADE' ELSE 'NO_TRADE' END AS LABEL", "CASE WHEN ([login to view URL] - [login to view URL]) > .9 THEN 'TRADE' ELSE 'NO_TRADE' END AS LABEL", b) The program generates and executes queries similar to this one: SELECT CASE WHEN ([login to view URL] - [login to view URL]) > .1 THEN 'TRADE' ELSE 'NO_TRADE' END AS LABEL, B.[OPEN], B.[CLOSE], [login to view URL], [login to view URL], C.[OPEN], C.[CLOSE], [login to view URL], [login to view URL], D.[OPEN], D.[CLOSE], [login to view URL], [login to view URL] FROM AAPL A LEFT JOIN AAPL B ON A.[INDEX] = B.[INDEX]+1 LEFT JOIN MSFT C ON A.[INDEX] = C.[INDEX] + 1 LEFT JOIN CSCO D ON A.[INDEX] = D.[INDEX] + 1 By iterating through the different values of the parameters. In this example it will run 27 times, because it needs to iterate through 3 values of {1} and 9 values of {5} c) The program runs with similar parameters as part one, but it also provides an option to save the results to a table, a .csv file (with the headers), or both. Name the files or tables the same as the xml file plus numbers 01, 02, etc.
ID-ul proiectului: 4279430

Despre proiect

5 propuneri
Proiect la distanță
Activ: 11 ani în urmă

Vrei să câștigi bani?

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal
Îți primești plata pentru serviciile prestate
Evidențiază-ți propunerea
Te înregistrezi și licitezi gratuit pentru proiecte
Acordat utilizatorului:
Avatarul utilizatorului
Bid placed! Please see my private message.
$60 USD în 10 zile
4,9 (126 recenzii)
5,7
5,7
5 freelanceri plasează o ofertă medie de $139 USD pentru proiect
Avatarul utilizatorului
C#.Net expert with tradesoftware
$250 USD în 10 zile
4,6 (2 recenzii)
2,9
2,9
Avatarul utilizatorului
Hello, We are ready for that job. Please check Private Message. Thanks & Regards Tera Technolabs
$150 USD în 5 zile
5,0 (1 recenzie)
1,2
1,2
Avatarul utilizatorului
I can get this done.
$30 USD în 7 zile
5,0 (1 recenzie)
1,0
1,0
Avatarul utilizatorului
I can do it for you very easily. You can review my resume.
$35 USD în 25 zile
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
I'm and more than capable of completing the project successfully. I've been working with databases for almost 20 years including dBase, MS Access, and SQL. I also have a Master degree in programming. I'm ready to provide you two high quality applications.
$200 USD în 10 zile
0,0 (0 recenzii)
0,0
0,0

Despre client

Steagul UNITED STATES
Miami, United States
4,5
28
Metoda de plată a fost confirmată
Membru din feb. 7, 2013

Verificarea clientului

Mulțumim! Ți-am trimis prin e-mail linkul pe care trebuie să-l accesezi pentru a revendica creditul gratuit.
A apărut o eroare la trimiterea e-mailului. Încearcă din nou.
Utilizatori înregistrați Totalul proiectelor postate
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Se încarcă previzualizarea
S-a oferit permisiunea de depistare a locației.
Ți-a expirat sesiunea pentru conectare sau te-ai deconectat. Conectează-te din nou.