i have a sum query i need that a group by field should be based on a if statement purpose = i have two warehouse's but dont want each item to show double only if its not there in the first do i want it to show from the 2nd job will be done by loggin in remotely its a query based on other query the whole structure might need to be redone should
...of a bunch of different platforms, including Twitter, Facebook, and YouTube. The text required in the logo is "SudoStrike" - which can be written as "SudoStrike" or "Sudo Strike"; and the only required element to the icon is a Hexagon (Preferably, though not necessarily with the Hexagon sitting flat ( With lines parallel to the top and bottom of the
I need a SQL expert to create a query for me that will display a category list for me in a specific format. I will provide more details to a qualified bidder. Project budget: $30 Delivery Time frame: 1 hour
...don't intend to sell anything on the site, but it would serve as a guide and hotel/food price comparison. I have other projects as well which I'll be posting soon. Hoping to strike an understanding for long-term work on the basis of this project. Anyone with knowledge of Hindi could be preferred. Not a must though. Please ask if I've left anything out
I have a php page that is taking a long time to execute and in addition in some cases its timing out. I need the mysql query optimized. ** Note: Plz only bid if you can start now Give me a guideline of how you will manage to do it. Provide of how long you think it will take you For your convenience, I've uploaded the file
Looking for someone to create a simple table that pulls and displays pre-sale and on-sale events from [login to view URL] via their API. Had one created by someone using Pythonanywhere but no longer have access to it. Should be a fairly simple project. You can use any language you prefer. I just care about the end result.
I have a website where I want to create a menu that everybody who buys a plan of bitcoin mining, it must generate the amount of what we set there. This is not a big thing but I'm not a programer so feel free to contact me and I will give you more infos for what I need.
This is an existing /running website built using Java, Jsp, Angular js, Query, and MongodB as backend. It needs to have My Eclipse, Tomcat 7 and JDK 7 to run, We need to enhance its look and feel and few very essential functionality as mentioned below. Working experience on any payment gateway (credit card, debit card, ACH transfer processing) would
I have a mysql query that with large data sets does not complete. I need a mysql expert to tell me where the bottlenecks are and revise to complete faster. With the largest data set, current run time for a limit of 5 rows is over 3 minutes. With all rows 9,000 plus it does not complete. Attached is the query code. I know some variables are missing
I have two queries that work individually. The first query creates a list of records. The second query selects the latest entry for each id of the first query. I want them joined so that it will operate as a single query.
...widget for a Shoutcast radio stream that displays the DJ Status. For instance, A code would be embedded in the site where the status is to appear. Then there would be another link to a script before the </body> tag. The embedded code would display a graphic, perhaps in blue and the DJ status would be displayed. If the Auto DJ was playing, it would say
I have some work, in an Excel spreadsheet.
Hi there, I need a Web Service to be built using PHP or Python. It would be a Scraper that would scrape google images based on a query and provide a link to that image in a REST API. I want to control the limit of results returned in the first request and when the limit is hit, return further results. For example : If there are 50 results in total
Fix my issue with my webservice. (Webdev) Can't contact my webservice on port 8080. Status : Connection timed out:connect I can't give your access to the RDP (Only one country can connect) so we have to work trough teamviewer. API, Webservice, Windev...
The website is fairly easy, 'standard' ASP with '__viewstate' and the usual, so the php-curl script needs to set the cookies and use those variables. The script needs to login, post (or get) a value in a form with a single text input, and get the result, which is 1 sentence, 2 sentences or 3 sentences, always in the same position. The script needs to get the value from a csv fi...
Hey I need an app showing the internet status on the icon (shortcut). For example green icon when connected to the internet and red when not. (this should happen automatically - without the user have to click the icon.) Mike
Need little help with coding In Office 2010 I want from Excel make query in Access. The accd is already open. In Excel I code: Public Function GetCollOntvInBoho(Dosnr) As Collection Dim AccessApp As Object, SqlBoho As String, rsBoho As Object, Coll As New Collection Set AccessApp = GetObject("X:[login to view URL]").Application If Not AccessApp
I have two sql 'dump' files from a website that we run. First I need to identify the table structure that contains the data. Once I have that, I need to query the files to extract the data within certain fields.
I wan to build an HTML Page, reading from MS SQL view or query with a filter control to filter data, and to be updated from same MS SQL view or table
I need an Android game. I would like it designed and built. a counter strike game that can be connected via wifi and can be played with friends
...Dynamic Query Builder with JSON as input 1)Use Standard SQL in Google Big Query 2)Define your JSON input file . Parse the JSON to form the exact query . When two or more tables are involved Create View and then Query on the view 3)Use filters for where conditions and also keep in mind regarging Aggregate functions while building query . 4)Use
I am a romance author and looking for a query letter to send to literary agents for consideration for representation of sub-rights management. My author website is [login to view URL] and the book I'm submitting for is Sweet Promise, the first standalone novel in a trilogy (the stories of three siblings). I am only looking for someone
Pretend you are an economist giving a brief to the Federal Reserve Board of Governors. Your paper should demonstrate your perspective of the current state of the economy and support that belief with data, then give direction as to steps that the Fed and the government could do to help (or avoid hindering) the economy. Your paper should include statistics for various measures of the overall health...
I need a Counter Top Display (Tear away) box designed so I can send it through to manufacture. Logo of Thumbz Tape is attached. Happy to mix ideas up for catch phrase like "Grip it and Rip it" Idea for counter display similar attached. Pencil Case - Black with coloured zip.
I need an Android app. I already have a design for it, I just need it to be built.
Develop a responsive website where user can post status with text, video, images. other users can comment. This is not a social network you don't need to develop chat,friend request etc..,
...soft for Raspberry Pi 3 and web server. The hardware includes Raspberry Pi 3, GPS module, 3G/4G USB modem and IP/USB/RPI camera. RPI soft counts incoming and out coming people under the camera, the counter have to determine people who go close to each other (without distance). It is going to work like a head counter. Parts of project: 1) People
Hello Develop a simple social network which will have only status updates posting and comment system like facebook. Just a Signup/login page, Post status with image,video,link and text.
Product Overview Utilizing existing MLB Weather query tool database as the source for historical team performance, we will create a predictive analytics tool for current day baseball games for each day of the MLB season, for all active games on that day. Product Deliverables • Responsive web application which provides pre-generated game-day MLB statistical
Hi there, I like to add an promille counter to my website. it should be shareable as a widget for other users. The required fields are height, weight, gender of a person, the hours of the consume of alcohol, the amount, promille percentafge and beverage. All should work together as I enter the different numbers. An example is here [login to view URL]
...cover are: sexy female, with white skin and long dark hair the creature - wolf/(dragons etc. if needed on background) Full ownership, royalties and rights stay with me. If we strike a deal, I will retain the copyright of the property. You may not publish it anywhere on the internet, even as a sample. It must not already exist anywhere on the internet.
I making website farmer query system which run on localhost in visual studio(ASP.NET). i have a database on farmer query system which is connect with SQL SERVER . But problem is that answer is not display according to query text . 1. Answer display if i type whole querytext as it is in website . if i use single space and single upper case or lower