Convert sql query sql query 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.

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'm looking to convert my current WordPress website to , using the template from The main focus of this project is enhancing the speed of page loading and ensuring that the site is fully optimized for mobile devices. Key Points: - The current WordPress website consists of less than 10 pages, each of which needs to be accurately and efficiently converted to Next.js. - The converted website should have improved page loading speed compared to the original WordPress site. - Mobile responsiveness is a critical aspect. The site should be designed to operate smoothly and effectively across a wide range of mobile devices. - As for the design and layout, I have a specific reference website in mind. I will provide further details and guidance

I'm looking to convert my current WordPress website to , using the template from The main focus of this project is enhancing the speed of page loading and ensuring that the site is fully optimized for mobile devices. Key Points: - The current WordPress website consists of less than 10 pages, each of which needs to be accurately and efficiently converted to Next.js. - The converted website should have improved page loading speed compared to the original WordPress site. - Mobile responsiveness is a critical aspect. The site should be designed to operate smoothly and effectively across a wide range of mobile devices. - As for the design and layout, I have a specific reference website in mind. I will provide further details and guidance

I'm looking for a skilled PHP developer who will be responsible for converting dynamic HTML, generated by PHP, into a PDF form for printing purposes. Key Responsibilities: - Convert dynamic HTML into smooth, printable PDFs - Ensuring the converted files maintain their original layout and quality Ideal Candidate: - High proficiency in PHP, HTML, and PDF conversion - Previous experience working on similar projects - Meticulous with an eye for detail to maintain design consistency.

I'm seeking a seasoned Instagram manager who is adept at increasing followers and engagement while drawing attention to my interior design services. I'd like you to: - Focus on growing my follower base dramatically. - Stimulate and interact with my audience, resulting in higher engagement. - Convert this increased visibility and engagement into actual business. Ideal candidates should have: - Extensive experience in managing social media, particularly Instagram, for businesses. - A track record of building followers and promoting engagement. - Knowledge of the interior design industry or a willingness to research and learn. - Skills in presenting services attractively to professionals and parents. - Expertise in turning social media engagement into real-world business. ...

I am Dr. Bratati Das working as a postdoctoral researcher at IIS, University of Tokyo. We have a polymer that changes its color from blue to red when a pressure is applied by e.g. scratch. Our goal is to make a package that visualizes the damages during the transportation and a corresponding mobile app, where users can take a photo of the red scratches on the package and convert the red intensity into the applied pressure values. Below we explain these steps. 1. Users scan the red scratch by taking a photo with a mobile. 2. The app separates the photo into R, G, B images. 3. The app only uses R channel (discard the rest). The app detects the starched line from the R channel image and extract the average value of the red intensity on the scratched line. The app also detects th...

converting existing stp file to blender and improve groups and textures

I'm looking for a unique and vibrant business card design. The card should have an excellent color scheme and typography. The propose is to understand my logo concept and convert it to the business card with standards quality and correct print layout setting. Key Points: - Color Scheme: I'm open to colorful combinations like red, orange, yellow, green, blue, purple, and white. However, I'm also open to minimalistic options. - Typography: I need a design with excellent typography. The text should be clear and easy to read. - The business card needs to embody the qualities of brand recognition, professionalism, and be appealing enough to attract customers. - It should be visually striking, yet simple and memorable. Ideal Skills: - Graphic Design: A freelancer with...

I am in need of a skilled Odoo developer to create an Odoo module. I have a node script that I want to convert to a Odoo Module. The node script create an XML from an invoice, sign the XML file (under XADES_BES standard), send it to a server and receive the files authorized by the server.

I'm in need of a skilled .NET developer to create...additional integrations may be required in the future. Experience with integrating external systems and APIs would be beneficial. - User Roles and Permissions: The application may need to support multiple user roles and permissions. While this is currently marked as 'unsure', the ability to handle this efficiently would be a plus. Ideal Skills: - Proficiency in .NET development - Strong knowledge of SQL databases and data management - Experience in user authentication and registration systems - Previous work involving user role and permission management - Flexible to adapt and integrate external systems when required If you're a skilled .NET developer with a track record of creating user-centric web applicatio...

helps how to convert excel sheets into a document

I have a backend code for a pre-existing fully function website and mobile app. The backend code is currently all written in php. I need someone to convert this existing php code into fully functional python code which I can deploy.

I'm looking for a skilled professional to convert an image to HTML. The purpose of the HTML conversion isn't specified, but likely it will be a website or template. Ideal skills and experience include proficiency in HTML, CSS, and experience in image-to-HTML conversion. The ability to understand and replicate the design elements of the image is critical.

I'm looking for an experienced freelancer who can convert my Excel sheets into Word documents. The documents need to be in text only and follow a specific format, for which I'll need help in creating a template. Ideal Skills: - Proficiency in Excel and Word to ensure accurate conversion. - Experience in template creation and design to help structure the documents appropriately. - Attention to detail to ensure the final Word documents are error-free and cohesive.

I'm in need of an experienced developer to bring my SQL codes with the triggers to life with a well-designed Apex Oracle application. The app is expected to have the following features: - Implementing data entry forms that are intuitive and user-friendly. - Developing robust data analysis reports that provide valuable insights in an easy-to-understand format. - Setting up a comprehensive user authentication and security system. - Creating a visual design that aligns with my company's corporate branding while also being colorful and vibrant. - Ensuring the application is responsive and works seamlessly on both desktop and mobile devices. - Implementing an efficient navigation and information architecture to enhance user experience. The ideal candidate for this project sho...

I have a series of photos in PNG format that I need to be converted to JPEG. Additionally, I need some color correction done on the images. Key Requirements: - Convert PNG photos to JPEG format - Perform color correction on the images Please note, I won't need any background removal or other edits. The focus here is simply reformatting and color correction. Ideal Skills and Experience: - Proficiency in photo editing software - Experience with color correction - Attention to detail and ability to follow instructions

I'm in need of a skilled web developer highly experienced in both Angular and Javascript. The primary objective for this project is to create a website with a responsive design that aligns with my provided brand guidelines. Key Qualifications: - Proficient in Angular and Javascript - Extensive experience in responsive design - Extensive experience in .Net Core and SQL Responsibilities: - Adhere to design and branding guidelines during web development - Create a website that is user-friendly on all devices. Please ensure to provide examples of past work with responsive web design during your application.

...in a formidable partnership with an experienced app developer to construct meticulously cloned versions of a food and beverage (Fnb) application and a condo management app, tailored for the Filipino market. For the Fnb app, the quintessential features should include: - Ordering food online - Making reservations - Menu customization - Incorporating a rewards system - Point systems - Option to convert points into vouchers As for the condo management app, it should function by: - Facilitating communication between residents - Managing visitors to the condos - Handling maintenance requests The selected freelancer should have significant expertise in app development, and previous experience in cloning apps would be an advantage. They should have a good understanding of both Fnb and...

This is a fast and small job. I need hands, otherwise I can do it myself. It is like 1-2 hours work only(please read my profile before you bid). I am in need of a skilled Wordpress developer to convert my current HTML website to Wordpress. I would like to maintain the same look and keyword details of the current site during the transition. The project will not be considered complete unless the website aesthetics and keyword details mirror the original. In addition, I want a blog section added to this website. The site is VERY small and is more a information pillar for th company. I will be providing all the necessary content for the blog, so no content creation is required. Ideal skills and experience: - Comprehensive Wordpress knowledge - Experience in HTML to Wordpress conv...

...Remove the "//const MongoClient = require("mongodb").MongoClient;” line 2 - Run ‘docker compose up’ to start the code 3 - Fix the code so it does not crash 4 - Demonstrate a working connection between the application and a remote Mongo Atlas database (you will need to create one yourself or point to one). The data does not matter, I just need to see examples of: a) A READ query, b) An UPDATE query, c) A CREATE new record query Error See this file for a description of the error which needs to be fixed - Debugging The application connects to a remote Mongo Atlas database correctly if the code is run outside the container. I’ve developed a simple Mongo connection js file which tests this. The output is shown here - h...

...applications, with the aim to identify and eradicate any potential vulnerabilities. Key Tasks: - Perform Open Source Intelligence (OSINT) - Port scanning - Man-in-the-middle (MiTM) attack simulation - Focus intensively on injection attacks (SQL, XSS) - Authentication and session management puncturing - Cross-Site Scripting (XSS) evaluation The ideal freelancer will have: - Strong experience in cybersecurity and penetration testing - Excellent knowledge and experience with Linux-based systems - Proven experience in web application security testing - Firm understanding of SQL, XSS and authentication vulnerabilities Your final deliverable will be a complete penetration testing report, detailing vulnerabilities found, their potential impact, and recommended remediation step...

I'm looking for a skilled designer who can convert my 2D logos into 3D with a silver metallic effect. The project involves transforming a series of logos into 3D representation with a sleek, professional silver finish. Key Requirements: - Transform 2D logos into 3D models - Apply a realistic, visually appealing silver metallic effect - Ensure high quality and attention to detail The final 3D models should be in OBJ format to optimize for use in 3D software and eventually for printing. Ideal Skills: - Proficiency in 3D modeling and rendering - Experience with metallic effects in 3D design - Ability to maintain the integrity of the original 2D logos in the 3D models LOGO FILE: Example: see attached Please provide samples of similar work in your proposal. Looking forward

I am interested in Kindle books that specialize in Asian International Cuisine. Knowledge of Asian cooking is helpful Ideal Skills and Experience: - Authoring or ghostwriting cooking books, especially in international cuisine - Familiarity with ...books, especially in international cuisine - Familiarity with eBook format, specifically Kindle publishing processes -software used to create kindle books and upload them to amazon The freelancer should be able to provide sample work related to this field. I'm looking for content that is not only informative but also engaging and easy to follow for both experienced and novice cooks. Looking. to convert. 3 books into kindle design. freelancer needs to format and upload to kindle Looking to have one cookbook ghostwritten. materials w...

I'm in need of an experienced Python developer to assist with the development of critical web security tools. While specific tools aren't outlined below - Subdomain Enumeration: Subdomains to be listed and categorized. - Directory Enumeration - Sensitive Parameter Detection - XSS Testing - SQL Testing

...(SOC), and state of health (SOH) based on the paper. Set up the objective function to minimize charging time while minimizing battery degradation. 3- Optimization Method: Implement the Legendre-Gauss-Radau (LGR) pseudo-spectral method. Use adaptive multi-mesh-interval collocation to transcribe the optimal control problem into a nonlinear programming (NLP) problem. 4- Algorithm Implementation: Convert the differential equations for each submodel into a numerical format compatible with optimization algorithms. Write the pseudo-spectral method for numerical optimization using libraries like SciPy for Python or built-in MATLAB optimization tools. 5- Optimization Execution: Define multiple test cases for minimum-time, minimum-aging, and balanced charging. Analyze results and generate ...

I require an experienced Arabic translator to convert business-related social media posts from English into Arabic. The content will be specific to a private school and I expect the translation to maintain the context and essence of the original posts. *Understanding of business terminologies and the social media landscape will be a plus. *Translator should ensure the translated content fits into cultural and language nuances. *Timeliness and attention to detail are key for this job. *Previous experience in translating business-related content or social media posts will be considered an added advantage. *A good understanding of both English and Arabic languages is a must.

I'm seeking a talented sales marketer for both B2B and B2C strategies, aiming to boost sales of selected products and services for . The ideal part...seeking a talented sales marketer for both B2B and B2C strategies, aiming to boost sales of selected products and services for . The ideal partner for this project will possess a versatile skill set, capable of reaching diverse consumer and business audiences. Key Duties: - Devise and implement marketing strategies enhancing visibility and appeal of our products and services. -Follow up and convert generated leads into sales. Skills and Experience: - Proven experience in both B2B and B2C sales marketing. - Excellent ability to adapt strategies for different markets. - Demonstrated success in driving sales growth for product...

I'm looking for an experienced digital marketer to create an engaging marketing page for my pharmacy business. The primary goal of this page is to generate leads, so I need it designed to convert. Key Information: - One of the key elements I want highlighted on this page are the range of services we offer. Potential customers need to know right away the breadth of services we offer. - I also want to showcase customer testimonials. Testimonials are powerful conversions boosters that can convince potential customers to choose us. Desired Actions: - I want the page to motivate visitors to either fill out a contact form or call for more information. Both of these actions should be very prominent and easy to complete. Ideal Freelancer: - Has experience with digital marketing and...

...processes it in Wordpress. The Incremental link makes a POST request to this script containing the data. In the script you see 3 types of actions in a switch: Add (new vehicle) Change (vehicle exists, adjustment is being pushed) Delete (vehicle is deleted) Below is a brief explanation of the three functions involved: add_post Here I build a Wordpress Query containing data from the POST request. Then I run a "wp_inset_post" function with this query. From that Wordpress function you will then receive a "post_id" with which I will add photos to the post. change_post Same as "add_post" but I use the "update_post" function because I already know the post_id. Then I'll delete all the photos from this post and add them again. I do ...

I require the skills of a professional who can cohesively convert a lengthy e-book into a single digital image that reflects the entirety of the book using a grid layout. Details include: - This image should support each page of the e-book in miniature, expandable form. - The preferred final format is flexible at this point, so your expert recommendation on whether JPEG, PNG or PDF would be best suited is desired. - In terms of layout, a grid format is preferred for the arrangement of the pages in the digital image. - A key requirement is a zoom feature: however, only limited zoom capabilities are necessary. Full zoom is not required. The ideal candidate for this project will have experience in digital design and conversion, with a strong understanding of image scalability an...

...already converted 50-60% to ) and also transfering our .NET to .NET CORE and our MS SQL to PostgreSQL Details of our current project STACK can be seen here -> Prerequisites: For this optimization task you can bid your normal hourly rate but for the long term project the starting wage will be as stated below. 1) Accept initial hourly rate of U$5.00 2) Accept and start work immediatly 3) Have 20+ hours a week for long term ongoing support and development. 4) If you are awarded the project accept IMMEDIATELY 5) Work hours: predominantly 20:00 to 03:00 (UTC -3 Brazil TIME) 6) Be available to work on weekends. Our projects use: GITLAB -> , ag-grid, C#, .NET API, MS SQL 2017 , WooCommerce digital product sales This is for ongoing long term development and

Preciso uma programação para SQL donde será trocados dados sensíveis entre clientes y um vendedor. Esta exigido encryption. A aparência dos dados deve ser com boa visão geral e também com busca fácil na base de dados. A SQL deve ser conectado no front end também para o público unidirectional de mandar ficheiros.

I have a vector cartoon character, currently in an .ai format, which I urgently need to be converted into a 3D model. Key Requirements: - Proficiency in converting .ai files to 3D models - Promptness as the project has a high priority - Suggest appropriate 3D output file format, as it was not specified Ideal Skills: - Proficiency in software like Maya, 3DS Max, Blender or similar - Experience with diverse file formats conversions - Ability to work under tight deadlines.

I need a talented designer to convert our current logo into a high-quality, scalable vector format. Additionally, the colors need to be adjusted to give the logo an updated feel. Key Responsibilities: - Convert a jpeg logo to a vector file - Modify the colors to create a vintage appearance Ideal Skills and Experience: - Proficient in Adobe Illustrator or a similar vector design tool - Experience in logo design and color adjustment - Understanding of vintage design elements Please note that I am only looking for professionals with a strong portfolio in logo design and vector graphics. Your understanding of the vintage style is crucial in this project.

I'm looking for a capable developer with a good understanding of Bootstrap CSS to convert a moderately complex Figma web design into a responsive HTML. Key Requirements: - Conversion specifically from Figma Web App - Ability to handle moderate complexity designs - Ensure responsiveness across desktop, tablet, and mobile - Use of Bootstrap CSS to maintain consistency and speed up the development process Please only bid on this project if you have a strong knowledge of Figma, Bootstrap and responsive web development. Your experience in similar projects will be a strong asset.

I'm in need of an experienced 3D artist who can convert a simple passport-sized photo into a 1-foot 3D model. This project is for a business purpose and needs to be completed as soon as possible. Key Requirements: - The model should accurately represent specific facial features, expressions, hair texture, and clothing details from the provided photo. - Prior experience in character modeling is a must. - A portfolio showcasing similar projects or relevant work is highly preferred. The ideal candidate will have a strong attention to detail and exceptional skills in 3D modeling. Your creativity and ability to capture the essence of the photo in a 3D model will be crucial to the success of this project. If you're up for the challenge, I look forward to seeing your bid.

I'm seeking an expert in Revit 2021 to trace an existing DWG file for a residential building. Key Requirements: - Proficient in Revit 2021 with a strong portfolio demonstrating intricate architectural modelling work. - Ability to accurately convert DWG files to Revit models without losing any essential data. - Attention to detail is crucial - the model must capture the existing layout and structure of the building. The perfect candidate should be a skilled architectural modeller with a good eye for detail, and experience with residential building projects. Your work will be the foundation for future design and documentation, so precision and accuracy are paramount.

I'm seeking an expert to develop a custom data dashboard focused on displaying my business's sales data. Ideally, this dashboard should represent the data through a visually engaging pie chart. Key Requirem...custom data dashboard focused on displaying my business's sales data. Ideally, this dashboard should represent the data through a visually engaging pie chart. Key Requirements: - Proficiency in data visualization tools - Strong understanding of pie chart data representation - Experience in incorporating total sales data into dashboards This project requires a professional who can effectively convert raw sales data into comprehensive visual representations. An understanding of sales analytics and data interpretation would be beneficial to the successful co...

I'm searching for an expert graphic designer who can successfully convert my mother's realistic artwork into captivating designs for various products. The intended items for utilization of these designs range from everyday essentials such as mugs, phone cases, to wellness and lifestyle products like yoga mats and cushion covers, along with a host of other merchandise. The potential graphic designer should bear in mind that these products are aimed to appeal both adults and children. I am interested in hiring a graphic designer to help transform my mother's artwork into designs suitable for various products. Her paintings predominantly feature elements such as birds and flowers, and I envision creating patterns from these elements that can be applied to a range ...

I'm in need of an expert in unbounce who can help me design 3 landing pages. These pages should be specifically tailored to generate leads for my B2B SaaS company that caters to the technology industry. Key Require...many elements that can help in achieving this, I'm particularly interested in your ability to integrate essential components. Key Tasks: - Design 3 high-quality landing pages. - Ensure these pages are optimized for lead generation. - Implement any necessary features to enhance user experience. I'm looking for someone with a keen eye for design, a deep understanding of what makes a landing page convert well, and the ability to produce quality work within a short timeframe. Prior experience with B2B SaaS landing pages and a strong portfolio in high-conve...

...not receive any pre-existing design templates such as Figma, but you may refer to a competitor's website for inspiration. The goal is to build a platform that efficiently categorizes Telegram channels and groups by country and category, facilitating easy navigation. This website will be developed using React, Node.js, and PostgreSQL. It must be fast, secure against common web threats including SQL injections, Cross-Site Scripting, and IDOR's. It should also be optimized for search engines to achieve high visibility online. Key Features of the Website: * Channel and Group Organization: Separate listings for channels and groups, categorized by countries and specific categories. * Search Functionality: Advanced search options allowing users to find channels and groups...