To be clear...I'm looking for asp.net EF queries. These could be Raw SQL queries, but NOT LINQtoSQL. Sorry, Freelancer won't let me updated the title of the project. I have several SQL Server tables from which I need to extract data AND perform calculations on that data. The queries will need to accept a date range and another geogr...
Make a simple website which extracts data from Excel sheet according to search. Basically there is a price list on excel sheet, user enters a word and clicks on search and the website displays the price. Two line on the website, one with search and other with price.
i need a very experienced MS access programmer developer that is able to manipulate my Access database to create custom reports, custom look up tables and custom queries to produce formatted custom print out reports all done in MS Access. Must be advanced Access user and be able to easily make custom tables and queries with resultant output for reports
I need Mysql optimized currently it has Slow queries: 9019 and some other issues which require optimisation perhaps indexing and so on. Centos 7 x64 os on VPS
We want an experienced SQL analyst to write multiple queries to extract value from data generated by our users. Databases are under Google BigQuery. After querying data we´d like to see the results in any Visualization Data Tool.
I have a website and need some changes made, see attached list with website logon to view what needs to be done. * termdate field needs fixed - does not update termfield * Add - "are you sure " when you click the delete * change "subadmin" to only allow view only * add report for subadmins - add 30-60-90 over due report email to each subadmin for each
I would like to extract json output into excel from an api endpoint . A parameter in the get is changed with values in a provided excel file. Here is an example [login to view URL] q1 will be changed according to the provided list, all results are to be in one row of excel, for each parameter variable.
...project will leverage AWS Lambda to produce and return proper Elasticsearch (6.5.x) DSL queries from data objects stored in DynamoDB. The developer will be expected to follow rules (that will be provided to the selected candidate) in order to build these queries. The developer must work in Node.js (8+) in AWS Lambda and be familiar with DynamoDB. Experience
This is a pretty fast exercise for someone with experience, there are only 5 tables that need to be denormalized. Easy and quick money before Christmas! I need an expert data model engineer to take an existing physical data model documentation and derive new tables in a denormalized format. Please only apply if you have multiple proven experience working
This task requires to apply the understanding and ability to use Relational DataBase Management Systems (RD...to apply the understanding and ability to use Relational DataBase Management Systems (RDBMS) as well as use SQL in the modelling of the physical world. Based on business scenarios required to design a database and provide related SQL queries.
...QTY) Shop(SHOPID,SHOP_ZIP) Use VOLUME = SUM(QTY) #SUPPLIER with SID supplies this part. PTYPE can be Perishable or Imperishable. # there can be more than one SHOPID per SHOP_ZIP and more than one Supplier per Supplier_ZIP # more than one supplier can supply a PART 1. Which SHOP_ZIP sold the most volume in the year 2016? 2. Which SHOP_ZIP sold
...solve this issue. Some SQL query issues solve which is near about 6-7 convert this whole project to 5.6 to 7.2.1 it's a really easy task just because I am using atom so just 3 query to convert the whole project. Connect with firebase and chat HTML is ready to code that page. Condition: We can't transfer the whole code and SQL database so the programmer
Design User interfaces, ER diagram, Table structures, Table data, Forms, Queries and Reports.
I have a JSON database, for which I want to develop normal and some complex search queries using Elastic Search
...serverless site runs dynamodb queries which return lots of records in one go. The peaky demand needs to be improved to optimise performance and cost. The data is IoT data collected every second and queries can include data from a few minutes to several years. The job is to optimise the loading and queries so the queries complete in less than a minute
...marketplace (website) in Brazil. Marketplace is intended mostly for corporate clients but may be used by individuals. We need 2 lists of Google search queries: 1. Queries that are used by Brazilians to sell agricultural/farmer commodities 2. Queries that are used by Brazilians to buy agricultural/farmer commodities Examples of commodities: vegetables, sugar
...the front glass. - left side with get - the back side is a wall with box to save the lost items. - a special place for handicapped while chairs. - upper panel written on it queries. - 1 meter down with the branding - a corner for lost children with a table and games - Open source is requested in 3 D max. - the design requested ASAP - more information
Hi can you help to solve simple sql queries and help to create simple api using python
In this project you have to do below tasks: 1:ER Diagram 2:Normalization 3:Create tables in oracle and insert some data 4:Answer some sql queries This is not a tough project if you have a knowledge of database [login to view URL] detail will be shared in a chat box. Moreover,The budget of this project is limited so bid accordingly. Thanks
I have a Visual studio Form written in c++. This is for a business and i need my sales data put into text boxes on my Visual studio form. The database is already integrated and being used in the project. Thanks Aaron
identify single fact schema, logical schema. Populate sample date is mySQL. Provide OLAP queries
Show evidence of understanding... understanding of various Business Intelligence concepts, through the design of data marts and implementation of OLAP queries. Implementation is performed in R/MySQL environment, while students need to perform OLAP queries and investigate the use of R for performing multidimensional analysis over Big Data Sets.
We are a small manufacturing shop. We are looking for a mid-to high-level of expertise in using the E2 Shoptech system (which is essentially an Access DB) to perform analyze and make data corrections, perform data entry, and produce reports. Expertise in Crystal Reports would be ideal to create new reporting from the system.
I need a php programmer to create a php script file that performs 10 essential queries on the sql database tables that have information. The results should always be based on 2 specific reference points, which will be user_id and page_id. Please bid with actual cost. this should be able to be inserted into a header file as require once, to be referred
These are the queries I want you to write. Refer to the attachment for more info. Find all the pairs of musicians (give names) who share an address. Find the songs that are not performed by any musician. Find the musicians (names) who played all the songs written by 'John' (musician author name = 'John'). Find the musicians who perform a song they
I want someone expert to help with the topics and he has good experience with programming
We need a MySQL Coder who can write a Stored procedure or Join Queries, I have a PHP code that is timing out so the whole logic of the PHP page has to be written in SQL Queries there are less then 6-8 tables to pull data from. The work has to be done on TeamViewer
...hosting with 8GB RAM. Issue to be rectified is once there are more calls continuously mysql is not returning/responding which is delaying the queries and very slow responses. There are API calls like 300-500 queries per every 10 seconds,have to fix this and response should be very quick in milliseconds,sometimes its slow and sometimes its fast,when there