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.

Taidot: Microsoft SQL Server, Powershell, SQL

Näytä lisää: writing database queries mssql, mssql database syncronization, optimization mssql database, sql query examples with answers, sql server management studio query where, sql server management studio query examples, sql server management studio query commands, sql server management studio select query, sql server select where, how to run a query in sql server management studio 2012, how to run a query in sql server management studio, sql, microsoft sql server, 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

Tietoa työnantajasta:
( 0 arvostelua ) United Kingdom

Projektin tunnus: #16269082

27 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

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. Lisää

£20 GBP 1 päivässä
(48 arvostelua)
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 Lisää

£14 GBP 1 päivässä
(15 arvostelua)
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 1 päivässä
(5 arvostelua)
4.5
£55 GBP 1 päivässä
(13 arvostelua)
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 Lisää

£20 GBP 0 päivässä
(5 arvostelua)
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 1 päivässä
(18 arvostelua)
3.9
Agiletechstudio

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

£18 GBP 1 päivässä
(3 arvostelua)
3.1
£18 GBP 1 päivässä
(3 arvostelua)
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 1 päivässä
(3 arvostelua)
2.5
periyannas

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

£18 GBP 1 päivässä
(4 arvostelua)
1.8
£18 GBP 1 päivässä
(2 arvostelua)
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#, Lisää

£23 GBP 1 päivässä
(2 arvostelua)
1.7
sreenivas2903

A proposal has not yet been provided

£28 GBP 2 päivässä
(2 arvostelua)
1.1
sks198117

A proposal has not yet been provided

£18 GBP 1 päivässä
(0 arvostelua)
0.0
£18 GBP 1 päivässä
(0 arvostelua)
0.0
varamsunny8

Right now I am working on Ms SQL SERVER.

£18 GBP 1 päivässä
(0 arvostelua)
0.0
£18 GBP 1 päivässä
(0 arvostelua)
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 Lisää

£15 GBP 1 päivässä
(0 arvostelua)
0.0
josephreeves1990

A proposal has not yet been provided

£15 GBP 1 päivässä
(0 arvostelua)
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 Lisää

£18 GBP 1 päivässä
(0 arvostelua)
0.0