Test sql server 2008 query commandsemplois

...aurait été trop facile et j’aurais dupliqué un et renommé la partie de la taxonomie) Me voilà coincé avec un bout de code avec de très très mince connaissance en php et query donc besoin d’aide Voici le code normal d’un élément dans step3 : <?php /* * AREA */ ?> <div class= &raq...

Nous avons besoin d'une formation pour configurer et utiliser un serveur "Windows Server 2008 R2" hébergé en VPS chez OVH, il me semble qu'une demi journée serait nécessaire

i waint a rdp 2008 R2 '(remote desktop ") connexion = 1 GB Disk dure = + 200 Gb Ram = + 2 gb

I need an app that sends SMS messages to a pre loaded number and depending on the returned sms it must update a graphical dashboard. For example: 1.- Pre loaded name: Pivot 2.- Pre loadad number of Pivot: XXXXXXX 3.- Dash board options: 3.0.- On status and red or green status light 3.1.- Start button 3.2.- Stop button 3.3.- Aligned: red or green status light 3.4.- Pressure: red or green status...

Hi need help with a ms sql query, need top select top 1, in a inner join. start comment with "SQL1" i will send you the query

I moved my website from Opencart to Magento, and i have some queries used on Excel for get information on Opencart Db that i have to use for the same extraction for Magento. I'm looking for someone able to send me back a tested queries for Magento for get the same informations In atthacmente the queries, i will give you db structure when you will accept my job

I want to be able to create a quert which will show all posts order by timestamp from a user friends. How can I do this in Firestore in Android Studio?

I want to create an Android app, a social one. I am hiring someone to create the database model. Firestore is a NoSQL database so you can't use foreign keys. How can I achieve what I want? Please help me.

...please do not apply for the project If you do understand Toolset, here is the scenario: Views for a custom taxonomy allows specific query filters, however it is limited so you can not have multiple operators in a query like WHERE ( $something = $something ) AND ( ( $something = $something ) OR ( $something = $something ) ) I require a custom

We use a relay board for home and industrial automation (Domotic), we would like to add a voice command to our system, we found Amazon Alexa API and we think that can be useful. Our electronic board use HTTP GET command to turn on and off the relays. So, the electronic board has an ip address, for example it has the [se connecter pour voir l'URL] ip address, if you send this GET command: [s...

Please read a file called "[se connecter pour voir l'URL]" in the zip file

...launched) WooCommerce website. The successful provider must be able to diagnose issues and resolve problems with SQL queries (remove duplicate queries, reduce requests, etc), locate/fix plugin conflicts, and (ideally) be able to adjust MySQL server config settings. Some PHP/JavaScript customization could be needed if plugin conflicts exist. The main issue

I have a database system project for my university. I have created a database design and I have 4 query to be solved. 1. Function that takes as parameter month and year and product and returns the amount of money 2. Employee name, customer name, number of orders 3. Customer name, distinct product name 4. Procedure that takes as parameter customer name

i need a function to display a table after running a mysqli query $result = mysqli_query($link, $query) or die(mysqli_error($link)); display_datatable($result);

I need to run a query in mysql that give me a count but not count some of the records fld1 is a date fld2 is a customer# fdl3-10 i only want to count a customer once per day.

Veuillez vous inscrire ou vous connecter pour voir les détails.

Hi, I am looking to create a table in MySQL that calculates the balance (with fixed interest rate) for each user. there are expected to be more than 1 million customers and they will be allowed to withdraw and deposit continuously. 1. Users will have to keep the deposit untouched (no withdrawer) for 90 days (balance_nowithdraw) - interest rate (say 10%) and days (90 days)fixed so the final number ...

python script that has a menu of things to do like (accept, drop, reject input/output) for a specific port or ips, port forwarding from source to destination, list configured iptables rules, saving and flush or rules, live monitor (tcpdump). (maybe some rules can be added)

I work for a small charity in the UK. Our sql database holds a lot of financial information such as how much each event we run needs to be invoiced. As we are moving over the Xero we want to be able to transfer this data into Xero to create invoices. I have a query in Access, with data in that i need to export into a Xero csv template. i need some

Hi I need the mysql query to consult the Grade History, where can be configured the required Course (by Course_id) to Moodle 3.4 BD . It's required experience over Moodle Database and Grades tables , grade_items_history. Just 50 dollars available to this query. By example, the data is same obtained by the same Moodle on "Grade History" Report disponible

Want to built a hana query for BOM

Hi, I am a developer and I need a more experienced backend developer to make my API production ready. There are several tasks to complete but for now, I'm looking for someone to refactor my backend queries for speed and stability. Also I'm having trouble indexing from a new DB (similar to this: [se connecter pour voir l'URL]). Please put the word Mongo as the first word in your r...

Hello, I have following query: SELECT * FROM WWW_Stock_Cpnr_Winkel WHERE ArtikelKode = 'MKN198A005107M/659' I either want to select all products that start with same data before the backslash /. Any idea to make this? Thanks. Keep in mind the Artikelkode change each time. This query is just one example

here is the detail of my project: [se connecter pour voir l'URL]

Need help with the sql query for the following: Need to add a subquery to the Supplier table script - select supplier ID (d1_fornece) and invoice date (d1_emissao) from table SD1330, join to SF1330 (as in the Invoice query) and then from that table to SE4330 where payment terms are in the field E4_DESCRI. Select only the most recent record, by invoice

...causing infinite loops in the process there by increasing WaitQ in my litespeed server. And it is not possible to detect just which process is causing that, So i usually kill all process running under that user to bring back the WaitQ. I am using the litespeed web server which maintain the live report in a file which i gave in the attachment, hdwrock1

Hello, I need a programmer with experience in: 1. Python - jupyter notebooks 2. lxml library to parse xml file I will send you a large XML ~1.2Gb with a reasonable schema (large list of relatively simple and flat xml tags) The result should by a single jupyter notebook that parse this file and then executes 5 simple queries on it (simple queries such as search for all elements that has a sub-eleme...

Need some one to work on multi-level complex SQL Query

...naturally ask questions. If you love a creative and exciting front end development project this job is for you. You MUST have experience with the Google Cloud stack including Big Query, Data Studio, NLP and AutoML. Plus strong experience with JavaScript. Any experience with a big data front end would be beneficial. If you think you are expert of this,

I have 10 excel workbooks with indentical excel sheets (same structure). I want a query (in power BI - DAX) to retrieve the information in these sheets in a single data sheet.

I have an Oracle Database File I would like to pull a simple query out and export to excel.

Develop small app based on Python or Google Go to bulk query rest api, with 3000 database entry and store all response in same database

Hello We built an application using code codeigniter and MySQL database (MariaDB), we are facing server issue to getting few record results takes 1-5 min to execute the result. We need DBA to consult us on the solution and fix it.

This is a project regarding the Arab world and the successes and failures of them.

I have created a Microsoft Access database that consists of 2 tables. I need someone to create queries, and reports for me. This is a basic project but I am finding myself very short on time.

Goal: #1: Using "Report" Sheet when a user types in the Start Date and End Date of data they need, the query will search the "Returns" sheet and display all the rows that fall between those two dates. #2: On "Report" Sheet in Cell B5, total Column G (Price) *Returns sheet will have an infinite amount of rows

Hello i have a database of millions of records of lat & lon I wish to find the center where most points are concentrated Example: if 30% of the data is around Location A (within 20m radius), 20% at random Locations, and 50% around Location B (within 20m radius), the final result should tell me the center of Location B (since most points are around that area)

...automate the following search process that returns the number of results found for a search. For example, for EHS management system, the query: site:[se connecter pour voir l'URL] "EHS management system" returns 40 results while the same query for another website returns no results: site:[se connecter pour voir l'URL] "EHS management system" Sc...

This is a game review HTML website for a project that i will need to develop in 2 days. I have already written most of the back end (Models, Controllers and Routes) So i just need someone to create the simple front end then write scripts in NodeJs to display the data from Mysql database onto the html site.( database is also done) BUDGET:$80 to 100 need the following functions: *3 color scheme...

Given the sample tables below, write a SQL query to show the combined Account MRR by Region for active contracts of at least 6 months with at least one Success engagement. See attached image for the tables. Accounts Example ID 100005 Name Acme MRR $1,500 Region EMEA Subscription Example ID 80003 AccountID 100005 ContractLength (mo) 3 MRR $1,000

Hello, I want someone that will build a PHP search query form based on start and end dates. This is how the form will work: 1. Select start and end dates and click the search box 2. The system will populate the form with the names, payment months and years based on the selected dates I already have a working system but its not working online on

I have data on employees that I export on a weekly basis and have to sort csv in excel. I want to be able to upload the CSV into my website, then be able to run a query on one employee and have it output/display the items associated with that employee (Licenses/CPR, expiring items) in an easy to see list.

I have a script that is rather long. In one section I need the below portion to be executed only if a specific table is not empty. ...just need someone to help with making this happen. If the table has records, then the below snippet will run and then the rest of the script will continue. if the table does not have records, then the below snippet will not run and then the rest of the script will c...

Hi, I am a developer and I need a more experienced backend developer to make my API production ready. There are several tasks to complete but for now, I'm looking for someone to refactor my backend queries for speed and stability. Also I'm having trouble indexing from a new DB (similar to this: [se connecter pour voir l'URL]). Please put the word Mongo as the first word in your r...

Project is to write commands for solaris servers. The commands should display Cpu utilization for Salaris server.

Please see video to see how application is to work. Applicant must work remotely on my test workstation, use linq to access the SQL database.

Please see video to see how application is to work. Applicant must work remotely on my test workstation, use linq to access the SQL database.

...built in any front end framework so creating a complete new css file based on media Query is probably the quickest way to implement. I would do it myself if I had the time. Structure for implementation should be 1 x [se connecter pour voir l'URL] file which will be called based on media query and 1 x [se connecter pour voir l'URL] file which will be called based on chan...

Hello Freelancers! This project requires 2 fully analytical documentation on my already implemented Java code - related to PLC commands. Kindly reach me out if interested :) Deadline is 29 January and budget aprox $30AUD. Happy Biding :)

Hi Everyone, I have a requirement to update a bunch of query when you click on a button in an excel sheet. The query is based on a Odata feed from D365FO(dynamics AX).