I have 3 TABLES (tbl_a, tbl_b, tbl_c) tbl_a is the treeview , tbl_b has related fields to tbl_a, and tbl_c which has the record to be counted: We are good so far, I got this working, the issue is to show counted record to each parent id in treeview. Example: ROOT (189) - subroot1 (132) -- sub sub1 root (72) -- sub sub1 root2 (55) -- sub sub1 root3
I want to pass team name in the url, get that name in the team database table and get their id, then use that id to get details from another table groupmatches to display games that team has won and lost to. Full script can be provided for local install. Some work in progress in attached file, it shows wins but not losses. [log masuk untuk melihat URL]
Create a template in excel of pivot charts from a pivot table. Want the original CSV data to be able to be imported from same format everytime. CSV file source with columns is attached. Graphs Needed are below Clinical Trial size: <100, 100-499. 500-999. >1000 Number of Trials Initiated Per Year Study Types Locations: United States, China, Japan, EU
This project will be to parse a PDF file with a table structure with a fixed structure and save the information into a table. Information to be extracted include the Bill of loading and the information about containers such as Container No, size, Gross weight and number of packages. See attachment.
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 geographic c...
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.
SUPER URGENT need within 20 min I have three tables tgmessage, tgchannels and tgusers in a MySQL 5.7 What I need is to create is 4th table with the data I selected (Look attched PDF) by join tgmessage channel id with tgchannel channel id and same thing for tgmessages user id with tgusers user id. (See correct names in PDF) 4th table shall cotain
...Senior level DBA to help with database indexing and speeding up our php queries and Lookup table creation. We are getting page timeouts and slow query responses for a very Active site. You'll work with my Front and Backend developers to help speed up our pages and database queries. Full Time Freelancer wanted for ongoing work with a very Active website
I have built a website using Eclipse and I added MongoDB to it. After that, I deployed my website using AWS, then I convert it to using th...it to using the android studio, but suddenly I lost access to the database. I realized that I lost access to the database when I deployed it. I need a quick help by creating tables on the MongoDB database on AWS.
SQL srvr, 5 tables are with huge data, need to archive
i need a very experienced MS access programmer dev...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.
IN head I wrote 2 but it shall be three csv files/tables. Hi I have three tables in CSVs format that I need an import to Mysql and then join them to one table on the mysql server or before upload.
PLEASE READ CAREFULLY BEFORE YOU BID. I'm looking for an expert in MySQL and good understanding of WordPress tables work. I'm looking for an expert SQL developer to load bulk CSV data into 4 WordPress MySQL database tables. My preference would be that the data is loaded via PhpAdmin. However, I'm open to other ideas such as WordPress Bulk Data Load
Editing WORD REPORT of 60 pages , the Report has Tables and Charts, needs editing , make sure them of Table and Charts on All Chapters Of Study has similar looks, edit font, alignments, make Table of Contents , Table of Contents for Table, Table of Contents for Graphs. Delivery will be PDF and WORD
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.
...to fix my [log masuk untuk melihat URL] in my project so that it uses values from my table called Dozvola (username and password). I dont want to use any of the ASP.NET pre-generated tables like AspNetUsers, AspNetRoles etc. This is a micro project, I just want you to enable me that I can log in with values from table Dozvola (for example admin 12345). Budget
...2 projects done in MVC, one with code first approach, other with db first. I want authorization of my code first to be by using my tables, and not with AspNetRoles, ASPNetUserRoles and other automatically generated tables. For someone who knows what he is doing this should be easy under 15 minutes work. Here are the 2 projects i mentioned: DB first:
we have a large Excel worksheet that describes all costs and income that are planned in a start-up company. We Need to have a couple of pages tha...We Need to have a couple of pages that can be inserted into a business plan. For this, some Information needs to be condensed (e.g. staff costs). Tables and diagrams need to be formatted as MS Word tables.
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 location. * fix report pag...
I've 2 database tables, one contains the user name and their id, the other contains their user id inside of player1, player2 and winner, for those I want to display the users name. More details and images in the attachment.
PAY IS $10 1 - job is to make 2 bootstrap tables into data tables (data tables plugin). table 1 = [log masuk untuk melihat URL] table 2 = [log masuk untuk melihat URL] 2 - I will provide ftp info + the tables ALREADY exist. 3 - you just need to login and configure datatables plugin for both. 4 - include data tables script cdn urls 5 - the functionality o...
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 [log masuk untuk melihat 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
...have a linked MS Access *.mdb file. I need someone to write a visual basic program to translate tables in those files to Microsoft SQL server file (2013) The linked Access files uses ODBC from ProvideX 32 bit (Mas90) to gain access. I need the VB file to be compatible with 2008 version and SQL to be in 2013 version. This should be straightforward
I have to add these informations to the table oc_manufacturer_description INSERT INTO oc_manufacturer_description (manufacturer_id, language_id, description, meta_description, meta_keyword, custom_title) VALUES (id, 2, 'Test', 'Test', 'Test', 'Test') where manufacturer_id it doesn't exist Check attachment
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
Create Pages on Laravel & [log masuk untuk melihat URL] to Add, Delete, Modify from 3 MySql Tables
I need to create 7 tables with 2 columns using divs and css. Table have a heading with different colors. Please see attachment. You will submit a html with css embedded in the head section. Font is Lato. Edit based on questions received: Layout should be 100% width to page (responsive), height according to content. Icons should be delivered as PNG
We need to create a catalogue in indesign. At the moment we have the tables in word and it is necessary to move them to indesign There are approximately 50 tables. Indesign tables must be editable. Word 15.26 Indesign cc 13.1
I am looking for a data entry specialist to manually convert 100 pages of old tables from a PDF into an Excel spreadsheet. If the work is done well, I have additional documents which must be digitized. See the Project File for an example of 2 pages (out of the 100). Accuracy is quite important, and I expect that all transcribed data will be correct
Immediate availability Need fast assistance from someone who's well versed with SSIS/CDC/SQL Must communicate with me so I can understand what's happening via Skype. - Create 6 Staging Tables for CDC (based on existing) - Generate Query to Return Data - Assistance with Best practices for Query and CDC Package Deployment
I have a very small project I need completed ASAP. I have two tables with a many to many relationship between them. I have an API route that updates both tables. Each table sits in it's own model. I need the route to insert data into one table, then take the primary key of that table and insert it into the other table as an fk constraint. The API
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.
Using MySQL #Consider a schema as follows: Supplier(SI...how many records will ittake to represent a DNA molecule if each record can hold exactl 4 nitrogen bases (A,G,C,T) 9. What base can pair with base G and base T 10. Given A SQL Statement of the form "select a,b,c from table t" and its output, can you determine the number of columns in table t?
...On the final results page it displays 4 maps embeded from Google Fusion Tables: [log masuk untuk melihat URL] (You should fill out the form form the previous URL for this page to display all results) Here are the 4 Google Fusion tables: [log masuk untuk melihat URL]