Closed

Write some queries for my MSSQL database

Hello,

I have a powershell script that pulls in various crypto coins prices from a web api, and added to a SQL database hosted locally on my machine. These prices are added into a table called 'Prices'.

I've created two other tables - Mean and Standard Deviation. When a price is added into the Prices table i'd like the mean and standard deviation recalculated for that coin. Once this information has changed, another calculation in the prices table must update for that coin also.

Skills: Microsoft SQL Server, Powershell, SQL

See more: writing database queries mssql, mssql database syncronization, optimization mssql database, write data excel database macro, can write queries sql envoriment need, convert mssql database backups, primavera install mssql database, install mssql database aspnet site, create mssql database schema, integrating google maps mssql database, google map latitud mssql database, write queries mysql, mssql database designer, setup automatic daily backup mssql database, google maps mssql database

About the Employer:
( 0 reviews ) United Kingdom

Project ID: #16269082

27 freelancers are bidding on average £21 for this job

codetod

Hi I am a database expert with 15 years experience in handling MS SQL databases. I have worked as DBA for large ERP databases and use to write and do performance tuning for SQL queries, procedures and triggers. More

£20 GBP in 1 day
(48 Reviews)
5.8
mjkaja

Hello. I am an expert software engineer with expertise in SQL Server. I have write complex, optimized queries for you in no time. Kindly let me know If we can work together. I have understood your requirements More

£14 GBP in 1 day
(15 Reviews)
4.7
SiarheiTk

Seems like it can be done immediately by applying trigger on table. Need to see your database and values. please contact me.

£18 GBP in 1 day
(5 Reviews)
4.5
£55 GBP in 1 day
(13 Reviews)
4.2
SergioAlfaroV

I am a MCSA SQL Server 2014 certified professional, with more than 10 years of experience in SQL related projects and tasks. I can have this delivered using triggers and native MS SQL Server statistic functions. At a g More

£20 GBP in 0 days
(5 Reviews)
3.9
vw7590795vw

Please review my profile. https://www.freelancer.com/u/vw7590795vw.html I have 8 years and 3 months experience in SQL Server. Please let me know more details and when we will start. Sky pe: jikenjd

£13 GBP in 1 day
(18 Reviews)
3.9
Agiletechstudio

Sir i read your initial requirements and i have some question regarding to your [url removed, login to view] we discuss it on chat ?

£18 GBP in 1 day
(3 Reviews)
3.1
£18 GBP in 1 day
(3 Reviews)
3.5
AndreyBarykin

Have big expirience as Senior Database Developer. Expert in MS SQL. Know well sql, make queries of any complexity. Make good solution for you.

£16 GBP in 1 day
(3 Reviews)
2.5
periyannas

Let me do it quickly. Tx Relevant Skills and Experience Mssql

£18 GBP in 1 day
(4 Reviews)
1.8
£18 GBP in 1 day
(2 Reviews)
1.6
sahumk2000

Hi Greetings of the Day, I understood requirement, I am interested in this task, I am full time freelancer carrying 13 yrs of experience in Mobile development, Web and Windows development using ASP.Net, MVC, C#, More

£23 GBP in 1 day
(2 Reviews)
1.7
sreenivas2903

A proposal has not yet been provided

£28 GBP in 2 days
(2 Reviews)
1.1
sks198117

A proposal has not yet been provided

£18 GBP in 1 day
(0 Reviews)
0.0
£18 GBP in 1 day
(0 Reviews)
0.0
varamsunny8

Right now I am working on Ms SQL SERVER.

£18 GBP in 1 day
(0 Reviews)
0.0
£18 GBP in 1 day
(0 Reviews)
0.0
mozammalidbctg

Hi, I am experts in .Net, C#,Vb,Windows application,Asp.net Web Forms, MVC,WCF Service, Web Service, Web API,MSSQL Server 2014,2012,20082,2008,2005,2000,Crystal report ,Krypton Toolkit for Windows application Desi More

£15 GBP in 1 day
(0 Reviews)
0.0
josephreeves1990

A proposal has not yet been provided

£15 GBP in 1 day
(0 Reviews)
0.0
tomarooks

I am a data management professional with extensive experience in data flow development and data processing. I have developed data warehouses, ETL and reports for national retailers and the NHS. Relevant Skills and Exp More

£18 GBP in 1 day
(0 Reviews)
0.0