Hi I have a query which I use in SSRS report builder 2016 to display results in a chart. Query is ok but I would like a column being pivot in the query and have never done this before. Should be less than an hours work and your need to work via Any Desk on my system to change the query. Get in touch if you can help. Thanks, John
I have 2 Spreadsheets that I have attached - Data from these 2 spreadsheets will need to fill in the 3rd spreadsheet.
...new table off the excel sheet we run a query to capture unique values using combined Inst and Mid query to extract unique string from excel field. I am encountering a challenge that the table I create from the above query has hidden charachters (?) I only see this after I export it to a text file. I need a query value to clean this up. I have tried
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
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
I am looking for people who can ge...am looking for people who can get me Direct Client (No Brokers, No consultants, No Middle-man) who outsource telemarketing campaign for my call center. It should be B2C(Business to Customer) process only. For example i am looking for clients who outsource Health insurance senior, auto insurance, final expense etc.
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 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
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
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...
Hi I am after a company that can provide full service like, Website Design/ Website Maintenance/ Creative Design/ Marketing Strategies, SEO / SEM / SMO and Google Analytics & Reporting. We have current work and new work all the time so we are looking for a long term relationship for ongoing work. Please contact me only if you offer all of these services at a cost effect price, all work is in N...
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 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
...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
I need web developers with expertise in wp, HTML, CSS to outsource my projects. I am basically outsourcing jobs. I need lowest rates possible for static, responsive web designs.
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
title sums it up quite well. We have 100k URLs that look like this [login to view URL] to look up products we offer for a particular make/model. If I understand correctly, google is treating all 100k results from our single asp page as 1 page so each result has virtually no juice. I need a pro that both understands SEO and know hows to convert above urls. but that can 1st advise authoritativel...
Small business with a 750 GB MS SQL db - need online trainer on Query Plans / Query Store to three developors. Must be able to provide this service in 1 - 2 hour sessions in Australian work hours. Have practical examples and database to test on.
I have an issue to query from same table to fetch some data select GuestNote,FName,LName,GuestID,[login to view URL] from Ondemands inner join Users on OnDemands.UserID=[login to view URL] where users.userid=3 and users.password='4201' and status='1' this return : FName,LName for userID=3 and return the GuestID which has FName,LName from same UserTable
***** No c/panel logins given don't ask.. Project for files only.. ***** Won't hire you if you can't abide...in-line in safari but scroller menu is there.. And in Chrome all images are inline but missing scroll menu.. Need the CSS fixed for multi browser.. Fix #2. Need to create a query and fetch the date uploaded like the format you see in shot...
...employee was fired for her engagement to a Pepsi employee.” "A Chinese woman stripped naked in a mall in 2015 because her boyfriend refused to buy her an iPhone 6.“ YOUR TASK: Outsource best facts in the internet, by finding the facts on various websites, such as Reddit, Facebook and such. You need to find the facts that got a lot of engagement and interest
I need a formula/query in Access that will give me the same result as the attached excel file for column B. This would be in an update query where B would be the calculated field. In excel, the formula would be Countif(B$2:B2,B2) and would drag down so that the result would show the number of times that field has been seen above. I have millions of
Here is an example of the service [login to view URL] I will be offering to my clients. I am looking to pay outsourcer a monthly retainer for providing this service. The services are helping clients get 20 - 30 highly qualified prospects each using Linkedin. The client will be paying for Linkedin Sales Navigator and any automation tools.
I need someone to write a query to map a score to a letter grade and that letter grade to a gpa and then print out that gpa. The score is not stored in a database it is generated from a formula in the report card file but the letter grade and gpa are stored in the database in a grade scale and each grade scale has a school id. The correct grading