SQL query needed. I have a three columns of data. First column is Business Segment, [A, B, C] second column is Nationality(English, Australian, American, German, French, Indian, Spanish, Itlalina, Turkish and so on.....), third column is count with value of 1 for each row. Total records are 2000. (please create mock up of data yourself) need to SQL
Need a console app, in C# that does the following. 1)...database, call a stored procedure, to get data. Will get a list of Invoicenumber, Text, Timestamp 2) Send this to an SQL database. Thinking the best way to batch this into a temp table in SQL database. 3) Call a stored procedure in the SQL database that will do (Not set yet) with the data.
I have a list of ~10,000 companies. Please CONVERT the PDF tables into EXCEL spreadsheets with the same columns. ADDITIONALLY, I need one more column with their EMAIL DOMAINS (I don't need the actual email addresses).
Please see attached pic of very basic design, I'm looking for that to be recreated with more precision. In the border surrounding the outer ring (race track) I'd like the words 'Neighbours & Numbers - NN - Neighbours & Numbers' repeating over and over, except in one part is like the words ©Future-Gaming to appear just once. If the racetrack was to be printed arou...
Hello, I need You to make C# MVC project from ready made Sql Server 2014 database with all Views and stored procedures and displaying results and filters for results in Ready Made Bootstrap 4 Web Ui template. Also you have to make the Home page dynamic, taking from database New Products and Products on sale, for which we have ready made Stored Procedures
I have compiled the table of contents from several top-rated dog training books into a document. I would like someone to examine these and create an original table of contents for a book that I would write on this subject. Ideally, the final deliverable would be a detailed Table of Contents with about 8-10 chapters that would cover the main themes
I need someone to take the ratings in the attached spreadsheet and make it into a ratings table in Wordpress. The table will be inserted with a future post. The table needs to be responsive and easily understandable on all devices. The styling should match the theme of our site... organiclifetips.com. If a plugin is needed, prefer a lightweight free
Healthcare claims and physician datasets, to gain insights on this data, Its POC concept project. Not related any organization or School or university.
I need to create a page to put inside my website, in this page there will be 5 fields, one of them the client will enter a value and on top of it the other fields will be filled automatically. It is for this autocomplete that I need help. For example, the customer types the value of a car he wants to buy from there and will automatically be given the
We're developing a restaurant table management system, and would like to outsource a component which is responsible for drawing and transforming a table by scale, move and rotate. The component is half written in Java for Android. Attached is the source code of the component, you just complete it according to the specification. The specification is
Design a HTML table to insertion into a Clickfunnels website. The table is attached. Reproduce it so it looks professionally designed. All text must remain the same. Font: Lato The website: [login to view URL] Site colours: #870e81, #17b80d + whatever else looks good.
Hello, I need to migrate Jooma K2 Ca...should be a standard Wordpress WooCommerce Item. - Migrate categories from Joomla K2 to Wordpress Woocommerce - Migrate images from Joomla K2 to Wordpress Woocommerce Product - SQL DB details provided - Wordpress environment provided for testing Here is the Jooma site using K2 plugin: [login to view URL]
I run a script on Matlab that takes data from an IOT sensor and transforms it (filters and integration over time). The result is output to a 6 column spreadsheet. I want to do this transformation without using Matlab, but instead run on a Azure SQL environment. Script is attached.
A NodeMCU ESP8266 is connected to a sensor and collecting approximately 10 seconds of data. I want to sen...sensor and collecting approximately 10 seconds of data. I want to send this data to a mobile phone app via wifi; when the phone receives all the data, it will send it to my SQL server. The only purpose of the app is to receive and send the data.
i need to add a web-socket to a data-table to make the data live. data always update and have it showing in real-time across all user browser. Websocket and php. Think about it just like when you receive an email and it just how on the inbox and you don't have to click refresh I already have the codes, just need to put it together. needs completed
...(stored procedures) that run when a user tries to modify data through a data manipulation language (DML) event. When data is modified in a table I need an INSERT, UPDATE, or DELETE trigger to update the same exact table located in another database. For example (assuming sbtydysd_lime68 is the master database for the application and sbtydysd_dash68 is a
we need to develop a timetable for schools based OptaPlanner to integrate with PHP interface like Moodle
edit microsoft world outline table and page number issue each title must be assign to the right page number
Within my sample MVC application, there is a scrollbar at the bottom of the top. I would like the bottom scrollbar duplicated so that it is as the top of the table as well. So 2 scrollbars, top one functions the same as the bottom,
The example is attached as a screenshot along with all the conditions. In addition to the table I need a green color for stocks/indexes that has been showing Strength/Bulish signals (with a small message describing which one of the conditions were met) ie. moving up the tables/better rating while the name should be stated in Red when Weakness/Bearish
Hi! I run an up and coming car club called Valiant Mafia. I’m looking for talented artists/graphic designers to help us create some awesome shirts. I’m looking for several different designs and I’ll be picking a few lucky individuals to work with us! These shirts will be sold to our current members and the car community. Whether it’s JDM, American Muscle
I need the services of an experienced SQL/XML Developer. You will have expert experience of reading and writing or manipulating complex XML documents which includes various child layers within a parent layer and exporting data to either SQL table or other XML fields. Experience with Creation of SQL to Tables, Views, Functions, Stored Procedures, Triggers
...freelancer as I already sent confirmation to you f. Above term is non-negotiable 7. Technology Stack a. Front End i. MS Visual Studio Framework ii. ASP.net, C# b. BACKEND i. SQL SERVER DATABASE Above stack is mandatory, another technology stack will not be accepted. 8. Complete Flow - check attachment Standard ASP Encryption and decryption to be used.
I have this error: [login to view URL]: Login failed for user 'root'. I am looking for an expert on Windows Server 2012 to fix the error about the sql database connection. The work need to be done right now.
i moving form a old server to a new one , so i move also to new database server MariaDB my website (joomla) run sql query to to the database trough function so need to convert the database for make it work on new system and joomla i have a SQL dump form old server in form of a .sql file need new .sql file ready to import into phpadmin
To extract the data and create report
Hi I want make application in C# to Synchronize local Sql server database with online sqlserver database For more info : The agent work like replication in sql server as you know the replication not work on online sql server database
build a query that will filter out all customers in PS_customers and PS_adresses that are meeting those criteria: (with the output i will then import PS_customer and ps_a...for all customers (arbitrary sample phone , easy.) for the right freelancer this will take only half an hour, be sure to bet only if you know prestashop and the structure table.
I need to modify in Magento 22.214.171.124 the default table view in a Grouped product from table to a dropdown menu as seen in the screenshots, it should work with everykind of products associated, simple, virtual, etc. I understand that this is doable modifying the file: app/design/frontend/rwd/default/template/catalog/product/view/type/[login to view URL] I'm
Hello Team, We want to create a Customer Support Request System with Internal task distribution process.
The project is small sized. Should take no more than a few days to complete. You need knowledge of SQL in order to take part in this project. My maximum budget for this project is £25 If you are interested, contact me for further information.
build a sql query for prestashop that will extract selected customer from PS_customer. from this new table assign an unique mobile phone number to all customers [phone # provided] the phone field must be mobile phone. then on prestashop php part, we need to lock the phone attributed to the customers so they cant edit it. new customers will be able
I'm using a combustion code which produces many data files containing results as columns and I need to create a 2,3&4 lookup table from these columns of results using matlab. The missions requires to convert the columns to matrices in a proper way which guarantees that the independent variables match the dependant variable (the one that needs to be
I have to make an SQL that simulates an online booking flights company, I would need all the elements (Plane, airport, client...) wit associations and I have a document with all the requirements. It is not something complicated for someone who knows sql. The document is in romanian, but you can translate it.
have a ms sql data table with the fields per the attached pdf. I am wanting to have a query that will pull the records where "agent = 188" and it will pull the most recent (based on time in xtime field) from each lead number sorted so I have the most recent xtime record first - then the next most recent record from a different lead, then the next
I need advisor to tell me the right server to host my web application and I need to install SQL SERVER STD 2014 ,IIS WEB SERVER, NETFARME WORK 3.5 AND 4.5 ,antivirus on that server