Filter sql query results työt

Usealla isolla yrityksellä on käytössään Suomessa eräänlainen heidän alansa ERP-paketti, joka on koodattu Visual Basicillä. Tarvitsisimme VB-osaajaa ylläpitämään ohjelmistossa mahdollisesti tehtäviä muutostöitä. Tekniikka lyhyesti: • Visual Basic -koodia noin 280-290 000 riviä • Integraatio taloushallintoon ja palkan maksuun • raporttipuolella n. 50 000 riviä • Crystal Reports • Microsoftin SQL Server -kanta Työmäärät vaihtelee, mutta keskimäärin 1-2 päivää/viikko. Välillä hiljaista.

...(Not absolutely necessary, but might come handy) * Docker In addition of allowing you to use modern development tools, you have the opportunity to witness Digital Signage business from up close. DS is a natural evolution of traditional advertising business, which enables delivery of digital content exactly where the target demographics are. You get to work with visible digital media and see the results of your work first hand. We are a small business and you will be not be hindered by traditional corporate decision-making. If you want to think outside of the box, we are always open to new ideas. The same in Finnish: Xibo CMS - kehittäjä/konsultti räätälöityä Widgetiä varten Tarvitsemme Xibo CMS - alustan käyttöliittymän...

Meillä on kaksi yritystä järjestelmässä, joilla on omat varastokirjanpidot ja osto-&myyntitilauksensa. Lokaalina serverinä toimii Windows 7 ympäristössä, visma Nova pro 9 (Windows sql server). Mikäli työn suoritus vaatii jonkin tietyn ympäristön niin kysele. Haluaisimme ajoitettuina tehtävinä ajaa allamainitut skriptit jotka muodostavat CSV tiedostot jotka on tarkoitus lähettää sähköpostina eteenpäin. Skriptin asetusten muokkaus skriptin alussa. Muuttujat ja funktiot kommentoituna. Lisätyönä voi tarjota näiden tiedostojen automaattista lähettämistä (Tiedosto liitteenä + leipätekstissä luettavasti muotoltuna). --------------...

Webservicen luominen sql tietokannalle. Perus toiminnot webservicelle ja kehitys ympäristön pystytys. Tarkempi speksi on saatavilla NDA:n kirjoituksen jälkeen. Kehitys mielellään Eclipse ympäristössä.

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.

Excel Add-In joka hakee ja tallentaa taulukkomuodossa olevaa dataa Azure SQL-kannasta/-taan. Lisäksi ohjelmallista Excel muokkausta ja hallintaa C#-koodilla. Osaan Excel muokkauksista valmis VBA-script, joka muutettava C#-kielelle. Visual Studio 2015 alkukoodi, SQL Azure tietokanta ja kyselyt valmiina.

Java, J2EE, JDBC, SQL, java Threading,GWT,Html,CSS

Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)

Moi! Osaatko kuinka hyvin sql:n perusasiat? Onnistuuko asentaa tietokannan hallintajärjestelmä, luoda ja hallinnoida tietokantoja sekä käyttäjätilejä ŠŠ ,seurata ja optimoida tietokannan toimintaa. Jos perusasiat hoidossa niin ota yhteyttä :)

Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)

I am searching for a freelancer to enhance my local search rankings by creating and managing map citations on Google My Business to reach the top 3 positions with guaranteed results. If you cannot provide a guarantee, please do not apply for this job. Key Responsibilities: - Create high-quality Google Map Citations for my business - Ensure all information is up-to-date and accurate - Regularly monitor and update the citations to maintain their effectiveness Ideal Candidate: - Experience in local SEO and Google My Business - Proven track record in improving local search rankings through map citations - Detail-oriented and a stickler for accuracy - Capable of managing and updating the citations on an ongoing basis - Strong communication skills for reporting and discussing the progre...

I'm in need of a skilled freelance...- Implementation: Your primary task will be to implement the schema markup for the individual product pages. This includes ensuring that the markup is correctly placed and configured for maximum visibility and performance. - Testing & Optimization: After the implementation, you should conduct thorough testing to ensure that the schema markup is properly functioning and delivering the expected results. If there are any issues, you should be able to identify and address them promptly. Please make sure to provide examples of previous schema markup work you have done, especially for physical products. The ideal candidate will be committed to delivering high-quality work and have a track record of successful schema markup implementations on ...

I'm in need of someone with strong experience in PostgreSQL for some critical tasks. - The ideal candidate should be well-versed in PostgreSQL, with a background in both database administration ...be well-versed in PostgreSQL, with a background in both database administration and development. - You must be able to handle complex issues that may arise with the database and be capable of performance tuning when necessary. - I expect you to understand the nuances of PostgreSQL and be able to provide solutions to potential problems with the database. - Any experience with data migration, query optimization and database design will be a plus. Please make sure to include your past work and experience with PostgreSQL in your application. Your detailed project proposals are high...

i have one php script which used to load in a few seconds now takes 4 minutes not sure why it suddenly lags need optimised - the mysql query hittin some bottleneck somewhere by looks of it

I am in need of a skilled ...will be used across various platforms including our company website, our LinkedIn profiles, and other social media accounts. The photoshoot will take place outdoors, hence, I'm looking for someone who has experience and can masterfully utilize natural light for high-quality results. Ideal Skills and Experience: - Proven experience as a professional headshot photographer - Expertise in outdoor photography utilizing natural lighting - High quality portfolio demonstrating past work - Ability to guide subjects for best results in terms of posture and expressions. Your bid should include the total cost for the entire photoshoot and delivery of edited, print-ready images. Communication skills, professionalism, and timeliness are essential for su...

Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.

I am in need of a skilled SPSS expert to assist me with a small project. I require someone who is proficient in statis... I require someone who is proficient in statistical analysis and interpretation using SPSS, particularly for basic descriptive statistics. Key Responsibilities: - Conducting basic descriptive statistical analysis on the data provided - Interpreting the results in a clear and concise manner - Presenting the findings primarily through graphs and charts You must have: - Proficiency in using SPSS for statistical analysis - Strong background in basic descriptive statistics - Capability to interpret data effectively - Ability to present results clearly through graphs and charts Your assistance in this project will greatly help me in understanding the data and ...

I need a professional who can analyze the logs of my Apache PHP-FPM server and help me troubleshoot errors. The main focus of this task is to identify and resolve any issues that might be impacting the performance of the server. Key R...server and help me troubleshoot errors. The main focus of this task is to identify and resolve any issues that might be impacting the performance of the server. Key Requirements: - The ideal candidate should have a solid understanding of Apache PHP-FPM logs and their structure. - Good troubleshooting skills are necessary to pinpoint the root causes of the errors. - Ability to present the analysis results in a detailed report is crucial. The main goal is to ensure the server is running smoothly and efficiently. The server use Centos 7, Apache a...

I'm in urgent need of an experienced Laravel developer for a VPS-hosted application. The application is facing some critical issues which n...immediate attention. Key Responsibilities: - Quickly identify and resolve user interface issues. - Address database errors and ensure data integrity. - Implement necessary optimizations to ensure smooth running of the system. This project requires immediate action as the application is currently not functioning optimally. Hence, the ideal candidate should be able to work under pressure and deliver results within a limited time frame. Skills and Experience Required: - Proven experience with Laravel, particularly in debugging and fixing issues. - Strong knowledge of VPS hosting environments. - Ability to work under pressure and meet t...

I'm looking...an existing machine learning model into a Discord bot. The bot should cater to three main functionalities - sending daily race predictions, responding to user queries about race outcomes, and providing real-time race updates. Key Requirements: - Integrate an existing machine learning model into a Discord bot - Implement a feature to send daily race predictions on a specific channel - Develop a query system that effectively responds to user queries about race outcomes - Enable the bot to provide real-time race updates Your Skills: - Proficiency in machine learning model integration with Discord bots - Experience in developing chatbots, particularly for Discord - Knowledge of horse racing and related terminologies - Ability to create an efficient and responsive r...

One of our clients is looking for a literature search with a view t...following link. The candidate performing the job should be skilled in performing medical literature database searches, able to collate the results and write an academic document containing citations style of Vancouver Style. There is no restriction on the number of words. Requirements: - Conduct a thorough search on PubMed focusing on Medical Informatics - Provide a detailed summary of abstracts found in the search - Ensure the search is comprehensive and up-to-date Ideal Skills: - Proficiency in using PubMed - Knowledge and understanding of Medical Informatics - Ability to summarize and report on the search results Please ensure that you have experience in this area before bidding on the project.

I am in need of a skilled SPSS expert to assist me with a small project. I require someone who is proficient in statis... I require someone who is proficient in statistical analysis and interpretation using SPSS, particularly for basic descriptive statistics. Key Responsibilities: - Conducting basic descriptive statistical analysis on the data provided - Interpreting the results in a clear and concise manner - Presenting the findings primarily through graphs and charts You must have: - Proficiency in using SPSS for statistical analysis - Strong background in basic descriptive statistics - Capability to interpret data effectively - Ability to present results clearly through graphs and charts Your assistance in this project will greatly help me in understanding the data and ...

...Channels: - Phone Calls: You'll be expected to make outreach calls to potential customers, explaining our services and generating interest. - Email Marketing: Crafting engaging emails to showcase our offerings and convert leads. - Digital Advertising: Leveraging online platforms to run targeted campaigns and boost our brand's presence. Ideal Skills and Experience: We are looking for a proactive and results-driven candidate with a strong background in sales and marketing. In addition, the following skills will be essential for this role: - Proven track record in lead generation and sales - Expertise in social media marketing and digital advertising - Excellent communication and negotiation skills - Understanding of the landscaping, gardening, or related industry is a pl...

I am looking for a skilled Google Ads expert to help me run an effective campaign. - Ideal candidate will have expertise in all areas of Google Ads: Search, Display, and Video Campaigns. - The primary goal of this campaign is to increase website traffi...Search, Display, and Video Campaigns. - The primary goal of this campaign is to increase website traffic. - The target audience for these campaigns is yet to be determined. The successful candidate should be able to provide insights on the target audience and develop a strategy that can effectively drive traffic to my website. You should be able to propose a campaign that can provide measurable results. The ideal candidate should have a proven track record of managing successful Google Ads campaigns, ideally for clients with simi...

I'm looking for a skilled freelancer with experience in image stitching using OpenCV. The primary goal of this project is to merge two images into a single image. Project requirements : You will be able to choose 2 grayscale images from the graphical interface. The images will be read from the disk and displayed, and the mouse will be used to choose corr...after at least 3 corresponding points in the images have been identified. Ideal Skills and Experience: - Proficiency in OpenCV - Strong understanding of image processing techniques - Previous experience with image stitching projects - Familiarity with algorithms such as affine mapping and inverse mapping If you have the necessary skills and are confident in your ability to deliver high-quality results, I'm looking ...

I'm seeking a skilled professional well-versed in MAXQDA software and data analysis to assist with my upcoming project. The work will involve the analysis of multiple sets of data - primarily surveys, interviews, and focus groups. Key tasks involved: • Coding data sets on MAXQDA • Analyzing coded data • Delivering insightful interpretations of results The job will involve approximately 40 surveys, 12 interviews, and 2 focus groups. It's therefore crucial that the successful individual or team is able to perform this task efficiently, maintaining high-quality data analysis throughout. Having previous experience in a similar job, and professional knowledge of Windows operating system, is highly desirable. Therefore, this job is best suited for someone ...

I'm in need of an experi...services. The role of the freelancer would be to verify the employment dates and job title of a candidate. The results of the verification should be presented in a written report. Key responsibilities include: - Verifying employment dates and job title - Ensuring accuracy and reliability in the verification process - Compiling all the verified information into a clear and concise written report I'm looking for a professional with: - Previous experience in employment verification - Strong attention to detail - Excellent written communication skills - Understanding of the importance of confidentiality in this process The ideal candidate will be able to deliver accurate and timely results, providing us with the information we need to make...

... Ideal Skills and Experience: - You must have the ability to handle the data analysis that we will provide you to target the right target audience. - To have proven experience in marketing campaigns that rely on data analysis. - To have proven experience in paid advertising on Facebook Ads, Instagram Ads, Snapchat Ads, TikTok Ads, and Twitter Ads. - Ability to analyse and optimize campaign results based on our target audience data analysis. - An excellent understanding of how different social media platforms work. - Exceptional creativity and originality. - Excellent communication and teamwork skills. Prerequisite: The freelancer must be able to provide previous work samples that demonstrate his ability to handle similar marketing projects. Please, work samples should be ...

Please develop a Python script to retrieve restaurant data from Google Maps using the Maps/Places API. The script should specifically target restaurants that have a phone number but *without* a website. The inputs I need to enter are: - Location (latitude and longitude) - Search Radius (meters) - Restaurant Type...Search Radius (meters) - Restaurant Type (including catch all types in the "Food and Drink" category) Key Data to Retrieve, output in a .CSV: - Name - Address - Phone Number - Google Maps URL Ideal skillset: - Proficient in Python - Strong experience with Google Maps/Places API - Ability to deliver results promptly and efficiently - Attention to detail to ensure accurate data retrieval

I'm seeking a seasoned Google AdWords specialist to help increase the traffic to my e-commerce website. Key Points: - I'm looking to drive more visitors to my site, helping to establish a broader online presence. - I am open to a strategy that will increase both quality and quantity of traffic to the site. - W...- Strong expertise in Google AdWords and PPC campaigns with a proven track record of success. - Prior experience working with e-commerce businesses is a big plus. - Excellent knowledge of driving website traffic and understanding of e-commerce dynamics. - A creative and analytical approach to optimizing AdWords campaigns. - Strong communication skills to keep me informed about the progress and results. Please share your relevant experience and approach to this ...

We're a dynamic agency specializing in helping businesses stand out on YouTube. We're currently on the lookout for a YouTube SEO specialist to boost the visibility and ranking of our high-quality content on the platform. Key Responsibilities: - Implement advanced SEO techniques to improve the ranking of our videos in search results. - Conduct comprehensive keyword research and optimize video content accordingly. - Enhance the appeal and engagement of our videos through creative thumbnail and title optimization. - Dive into analytics and user engagement data to constantly refine and improve our strategies. Ideal Candidate: - Proven experience in YouTube SEO, with a track record of improving video ranking and visibility. - In-depth knowledge of keyword research tools and S...

...Registration and Login: The platform should provide a seamless registration and login process to users. - Search and Filter for Priests: Users should be able to easily search and filter for priests based on location, preferred language, and availability. - Booking and Scheduling System: An efficient booking and scheduling system is required. This should allow users to select their preferred date and time for the service or event, receive confirmation and reminder notifications, and make payments online. Ideal Skills and Experience: - Proficiency in front and back-end development - Experience in building user-friendly interfaces for seamless user experiences - Strong knowledge of search and filter functionalities - Previous experience with booking and scheduling sy...

I'm looking for a dedicated sales executive to join my real estate team. Your primary responsibilities will include: - Lead Generation: Acting as the first point of contact for potential clients, you'll be responsible for identifying and purs...satisfaction, maintain strong relationships, and address any concerns they may have in a timely and professional manner. Ideal candidates should have: - Previous experience in real estate sales, preferably within the residential sector. - Proven success in lead generation and closing deals. - Excellent communication and negotiation skills. - Strong customer service orientation. - A proactive and results-driven approach to work. If you're a sales professional with a passion for real estate and a track record of success, I...

...multiple users to view and edit information for subscribers (names) in a database. Those users must be able to login on a web page, with a username and password. All users will see same information. But certain fields, those they will be able to edit, will be visible only to that specific user (and admin). Multiple users must be able to enter data (different) for each subscriber. User must be able to filter certain columns, search in all fields, hide/show columns. Online (on web) visible to users, will be only the fields mentioned in table visible) MS Access (local file) Administrator must be able to see and edit all after importing with an interface you will create in Microsoft Access (locally) Administrator must be able to see for each voter the data each user entered for it ...

Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.

I...need for a Facebook ad manager. My company would greatly benefit from someone who can consult on the best methods and strategies when it comes to ad management, specifically focusing on ad placement and ad creative. Key responsibilities will include: - Set-up, targeting, creation, and design of Facebook Ads related to my business. - Performance tracking and optimization to guarantee the best results from our advertising efforts. The ideal freelancer would have extensive experience in managing Facebook Ads and a proven track record in driving web traffic and generating leads. Your ability to provide expert advice on targeting audiences will be pivotal for our success. In a nutshell - I need someone who can take ownership of managing my Facebook Ad manager account, and excel in...

...Digital filter algorithm/ code in C for ARM processor for processing real time raw sensor to removal of noise & unwanted signal Algorithm / code for Digital Filter low bandwidth Real time Sensor Signals 1. Analogue Raw data acquisition in real time at 1000 samples per second in 24 bit precision 2. Raw data signal bandwidth /frequencies restricted to less then 1000 hz by hardware RC anti aliasing filter to avoid aliasing 3. Following Digital in sequence to be applied to raw signal . a. low pass filter 0-170 hzs ( to remove high frequency random / white noise b. High pass filter 1 hz to 400 hz (to remove low frequency dur DC signal coupling ) c. Very steep(narrow band) notch filter at 50 hz / 60 hz to remove power line interference ...

I am looking to establish a long-term relationship with a talented person to scrap thousands of dating profiles from popular dating websites. This person should have years of experience dealing with the various countermeasures these sites will employ to discourage scraping. The use of proxies may be needed to achieve satisfactory results. The end goal to to have a system capable of delivering 20K - 40K profiles per day.

...Windows platform. Ideal Skills & Experience: - Proficiency in Desktop Application Development - Strong MySQL and Database Monitoring Skills - Experience with WYSIWYG Template Management - Previous experience in PDF generation applications - Knowledge of Windows Application Development Additional Notes: a. application will need to determine which template to use based on a query b. Must be able to create, edit templates in an easy wysiwyg way. c. naming convention based on db record. d. Ability to add an option password to the PDF required. e. The resulting PDF must be stored in up to 2 locations (one maybe a unc path with username and password required) f. must be able to use multipl...

Create a bright and bold 12' x 40' billboard to effectively promote our B2B Virtual Assistant service. This design should turn heads, deliver a clear message, and drive results! Use the below information to craft the best billboard you can do! You may utilize some of the copy provided or create your own copy based on the information provided. Company/Service Information: • We are a US-based staffing agency that provides Virtual Assistant Services to micro-, small-, and medium-sized enterprises worldwide. • Our Virtual Assistants come from all over the world. • We have been in business for more than a decade. Our services: • Admin Support • Business Support • Marketing Support • Technical Support Industries we serve: • Constructi...

I'm in need of a skilled SEO professional to help me improve my website's visibility and search engine rankings. Your mai...website's visibility and search engine rankings. Your main goals will be to increase organic traffic and ultimately increase leads/sales. Key Tasks: - Conduct an SEO audit to identify current gaps in the website's SEO - Implement on-page and off-page SEO strategies - Monitor and report on performance and any improvements Ideal Skills: - Proven experience in SEO optimization with tangible results - Knowledge of the latest SEO trends and best practices - Familiarity with tools like Google Analytics, SEMrush, and Moz - Great analytical skills to interpret data and adjust strategies accordingly Feel free to reach out if you have any q...

I require a straightforward, user-friendly spreadsheet that calcula...user-friendly spreadsheet that calculates energy savings based on specific input. My needs are very particular. Here are the key aspects: Input Specifications: - It should only take one input: an initial savings value representing the savings our product offers. Calculation Requirements: - I expect the spreadsheet to perform calculations for both percentage and dollar amount savings. Results Format: - The results should be shown as simple numbers; I don't need them displayed as percentages or any graphical representations. The freelancer fit for the task should be proficient in spreadsheet software and have experience in building similar savings calculators. A good understanding of energy savings ...

Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.

I'm in urgent need of someone who can help me create and optimize social media accounts on Facebook, Instagram, Twitter, Snapchat, LinkedIn, and TikTok. Key Responsibilities: - Create and setup the accounts on...the specified platforms. - Optimize the accounts to make sure they are appealing and professional. - Ensure all accounts are interconnected and well-coordinated for a consistent online presence. Ideal Candidate: - Proficiency in creating and optimizing social media accounts on Facebook, Instagram, Twitter, Snapchat, LinkedIn, and TikTok. - Ability to work efficiently and deliver high-quality results in a short timeframe. - Strong communication skills and attention to detail are a must. I need this done as soon as possible, so only serious and experienced freelancer...

...Reports: Documentation of clinical validation and technical testing results. - Security and Compliance Documentation: Evidence of data security measures and regulatory compliance. - Deployment Plan: Strategy for deploying the app and AI models. - Maintenance and Update Plan: Ongoing support and improvement strategy. Specific Tasks for the AI Builder/Programmer 1. Requirement Analysis and Planning Understand Objectives: Collaborate with stakeholders to understand the specific requirements and objectives of the AI app. Technical Specifications: Develop detailed technical specifications and project timelines. 2. Data Collection and Preparation Data Gathering: Collect relevant datasets, including patient histories, lab results, symptoms, and lifestyle information ...

I'm on a quest to flatten my company's efficiency curve and reduce the hours we spend on manual tasks. I need a savant familiar with Power Apps to help me achieve this. Skills Required: - Proficient in Power Apps, preferably with experience in teaching others. - Able to develop advanced, customized solutions tailored to my business. - Expertise in leveraging Offic...teaching others. - Able to develop advanced, customized solutions tailored to my business. - Expertise in leveraging Office 365 integrations within these solutions. - Proficiency in constructing complex, efficient databases. The ideal candidate should have a comprehensive grasp of Power Apps and a passion for education. Seeking to build a one-on-one relationship that will deliver measurable results on the...

...property. The photo app will have the following main functionalities: - Setting up a photo shoot job - Selection of a suitable photo shoot date - Selection of additional photo shoot services - Short-term storage of photos - Allowing the real estate agent to download the resulting photos via API - Everyone will see the photos they have permission to. He will be able to filter and sort them on a basic basis - Photographer rating system System users: - Broker ◦ Establishes a request for a photo shoot ◦ Selects the date and service ◦ Sees his orders including the resulting photos ◦ Evaluates - Photographer ◦ Sees assigned jobs with a schedule (calendar) of jobs ◦ Confirms the job ◦ Inserts...

...map should be the centerpiece of the affiliates page, showing all sister radio station locations globally. - A static map design with clickable markers is preferred, enabling users to easily navigate through different stations. - Search Functionality: - A search bar is necessary to allow users to find a specific station by entering either its name or location's zip code. This feature should filter and update the markers on the map accordingly. - Station Information: - For each radio station, the page should display: - Station Name: This is the primary identification of the station. - Location Address: The physical address of the station. - Contact Information: Details such as email, phone number, or website link for users to connect with the stations. I ...

I came across a minor issue on my website on Digital ocean cloud server. Refer the below error information. I need someone who can fix me immediately in an hour. Error 500 PleskExceptionDatabase DB query failed: SQLSTATE[HY000] [2002] Connection refused