Convert multiple rows to columns in sqlงาน

1.พัฒนานะบบ IOT ดึงข้อมูลจาก PLC แล้วนำมาแสดงผลในรูปแบบ Web Site โดยแสดงข้อมูลเป็น Real Time 2.สามารถใช้อุปกรณ์ของของบริษัท (Embedded PC) มี SIM ออก Internet ได้ หรือสามารถใช้อุปกรณ์ที่ผู้พัฒนาถนัด แต่ต้องเป็นอุปกรณ์ที่ทนต่อสภาพการใช้งานในโรงงานครับ (ความร้อนและฝุ่น) 3.สามารถใช้ Server ของบริษัทได้ สามารถเลือกได้ตามความถนัดแบบ Windows / Linux และ Database SQL , MySQL, MogoDB , InfluxDB เลือกได้ตามความถนัดครับ 4.เก็บข้อมูลไว้ดูย้อนหลังได้ 90 วัน

ทำระบบการเลี้ยงปศุสัตว์ (Livestock Management) นำเสนอเบื้องต้นของ Development Tools: Front-end: Angular JS Language: .Net Core (Web responsive) Database: SQL Server/Azure SQL Database Operation System: Windows Cloud Solution :Hybrid Azure

ต้องการสร้างแอพ Xamarin (Cross Platform) เชื่อมต่อฐานข้อมูล Mssql ดึงข้อมูลจาก แสดงข้อมูลจากฐานข้อมูลพร้อมรูบ และ ทำระบบ Login

...เป็นงานระยะยาว ระยะเวลา 6 เดือน – 1 ปี c. การเชื่อมต่อกับระบบเดิม เชื่อมผ่าน MS SQL Server และ REST Api รูปแบบข้อมูล JSON ทั้งหมด d. การแก้ไข ระบบเดิม จะทำโดย programmer คนเดิม ไม่เกี่ยวข้องกับระบบใหม่ e. Source code และสิทธิ์ใน source code ทั้งหมด เป็นของผู้ว่าจ้าง f. ผู้ว่าจ้าง ต้องการเข้าถึง repository ของ source code ด้วย เพื่อประโยชน์ในการ review ป้องกันการสื่อสารผิดพลาด g. Platform NodeJS และ deploy บน Docker หรืออื่นๆ ที่เป็นรูปแบบที่คล้ายกัน h. แยกส่วนแสดงผล (client javascript) และส่วน Api (REST Api อย่างชัดเจน) 2. ระบบเดิม เป็น program บน Windows เป็นภาษา C# .Net framework และ MS SQL server a. เมื่อสั่งซื้อสินค้า จะสร้างข้อมูลการสั่งซื้อใน MS SQL Server และมีใบ PO ออกมา b. เมื่อรับออเดอร์แล้ว จะสร้างข้อมูลใน MS SQL Server และพิมพ์ใบงานส่งให้ฝ่า...

ต้องการ programmer สามารถเขียนคิวรี่ SQL และทำ report ระยะเวลาจ้าง 1 เดือน มานั่งทำงานร่วมกับ Programmer ของบริษํท ที่ทำงานตั้งอยู่ที่ปากซอยเพชรเกษม69 Victoria Garden ติดต่อที่ คุณท็อป [Removed by Freelancer.com Admin]

โปรแกรมสามารถแสกนลายนิ้วมือได้ โดยเชื่อต่อกับ SQL Server เมื่อลงเวลาออกสามารถ auto export file เป็น text ออกมาได้ (ต้องมีการคุยรายละเอียดกันอีกที)

Application ที่องค์กรใช้ มี ระบบ Database ใช้ MS SQL

- พัฒนาโปรแกรมโดยใช้ภาษา ASP.NET C# , Microsoft SQL Server - พัฒนาระบบเป็น web base application โดยมีเพียงส่วนของ UI และ Call Method ผ่าน Web Service - ไม่มีส่วนของ database design ,database create , database retrieve, database update , database delete - Design Web Page เรียบง่าย ใช้งานสะดวก ไม่เน้นลูกเล่น มี Concept , มีรูป ให้ 1. รถยนต์มือสอง 1.1 Download excel file format การกำหนดราคา รถยนต์มือสอง 1.1.1 Download excel file ใน Format ของการกำหนดราคา โดยเลือกเงื่อนไขได้ 2 วิธี 1.1.1.1 เลือกตามยี่ห้อ สามารถเลือกได้มากกว่า 1 ยี่ห้อ 1.1.1.2 เลือกตาม segment เลือกได้ครั้งละ 1 segment 1.1.1.3 ถ้ามีราคาที่เคยกำหนดในระบบให้แสดงด้วย 1.1.2 แสดงรุ่น รุ่นย่อยทั้งหมดตามเงื่อนไขที่เลือกด้านบน ...

การทำงานตามคลิปที่ส่งให้ดูครับ เรื่องการออกแบบก็ประมาณนี้ -สามารถสมัครสมาชิกได้ (แยกระหว่าง user และ owner / loginด้วยfacebook ได้) -ทำงานเสร็จสามารถส่งไฟล์ทั้งหมดเช่น sql api apk อื่นๆ เพื่อการพัฒนาต่อไป -เพิ่มร้านค้าและเมนูเองได้ทีหลัง

...เอฟเฟ็คตอนใช้สกิล , ฟันมอนสเตอร์ , เปลี่ยนแปลงอาวุธของตัวละคร 2. ใช้ Unity Network 5 , Javascript , C# ในการเขียน (หากใช้ Tools อื่นก็ลองเสนอมาได้ครับ) 3. สามารถกำหนดจุดเกิดมอนสเตอร์ได้ และผู้เล่นคนอื่นเห็นมอนสเตอร์เหมือนๆกัน 4. กำหนดการดรอปของไอเทมเวลาฆ่ามอนสเตอร์ได้ และผู้เล่นคนอื่นเห็นไอเทมเหมือนๆกัน 5. ระบบ Inventory สามารถดึงข้อมูลไอเท็มของตัวละครแต่ละคนได้ ใช้ database mysql หรือ ms sql ครับ 6. ระบบแชททั่วไป และแชทส่วนตัว 7. ระบบปาร์ตี้ ให้สามารถมองเห็นหลอดเลือดของคนในปาร์ตี้ และตำแหน่งปาร์ตี้ในแผนที่ 8. ทำคู่มืออธิบายวิธีการใช้งานสิ่งที่ทำมาคร่าวๆครับ ใครสนใจเสนอราคาค่าจ้าง และประวัติผลงาน มาด้วยนะครับ

ค่าจ้างตามตกลง Programmer C#.Net MS SQL HTML etc.

Build a Easy website with codeigniter+sql. Built it as easy as you can. สร้างเว็บไซต์ด้วย codeigniter+sql.

Software and Application OCR Scan or Take Photo of Document OCR TO SQL

Programming with c # or C ++ connected to the camera. Face Detection with Face snapshot datetime into the database with MySQL. CCTV ( Detection Face of multiple pages on a single ticket )

รับเขียน ออกแบบ แก้ไข software ทุกประเภท ทั้งงานทั่วไป และ ในโรงงานอุตสาหกรรม ประสบการณ์ใน บริษัท และ โรงงานอุตสาหกรรม มากกว่า 10 ปี -VB -Delphi -MS SQL -Oracle -MS Access -Barcode reader, RFID - อุปกรณ์เชื่อมต่อกับระบบคอมพิวเตอร์ I/O Card, Machine controller และ อื่นๆ เรามีความเป็นมืออาชีพ ทำงานเร็ว คุณภาพเยี่ยม คุ้มค่า คุ้มราคาแน่นอน ติดต่อเรา

I'm in the process of launching a consulting business focused on staffing services. I'm in need of a talented Client Acquisition Specialist to help me secure freelance staffing clients. Key Responsibilities: - Engage in the overall sales process , from lead generation, initial outreach and closing deals. - Develop an effective client acquisition strategy. - Reach out to prospects through various channels (e.g., email, social media, networking). - Present our service offerings in a compelling way to convert leads into clients. -Secure deal closures by skillfully managing negotiations and terms. -Establish and sustain robust client relationships. Ideal Candidate: - Proven experience in client acquisition, ideally with...

...experienced Unifier consultant to streamline our project management system and provide strategic guidance on process optimization. Key Tasks: - Conduct a thorough process review and analysis to identify inefficiencies and areas for improvement. - Implement workflow optimization strategies that enhance project efficiency and reduce time-to-completion. - Integrate multiple systems to ensure seamless data flow and accurate project tracking. Challenges: - Inefficient communication between teams: The current system hampers cross-functional collaboration and slows down project progress. - Manual data entry and duplication: We're struggling with data accuracy issues due to manual entry and duplication. - Lack of automation: The absence of auto...

I'm in need of a comprehensive, multi-tasking personal assistant AI to support me in a variety of ways. In addition to the standard tasks like scheduling appointments, managing emails, and setting reminders, you'll be responsible for quite a bit more: - Daily Eating Plan: This will involve keeping track of my dietary requirements and suggesting meal plans. - Warnings: I need to be alerted of any potential issues or conflicts that might arise. - Sports: I require assistance in tracking my sports activities and training regimes. - Calorie Calculations: It's important for me to track my calorie intake, so I'll need you to help me with this. - Heart Rate: Monitoring my heart rate and keeping track of this data....

1 Need to build a website monitoring program to monitor changes in sub-pages of the landing page Detailed requirements: The website needs to have SQL function because batch site monitoring needs to be uploaded. 2 Identify the link to the final sub-page login keyword such as Proxy function and mobile phone UA because mobile phone batch UA is required Multi-thread monitoring 3 Filter duplicates and monitor changes in subpages of the website Set a custom time to refresh the web page 4 Send the new URL of the subpage change to the created group through the telegram machine

Write 'CHINESE' OR I BLOCK YOUR BID DEADLINE is 48 hours from accepted project. I need a skilled translator who is fluent in both Chinese symbols and Danish to help convert a medical journal. The journal's focus is on a specific medical field, and it requires a high level of accuracy. Key requirements: - Fluency in Chinese symbols and Danish - Translation experience in medical content - Attention to detail - Clear, concise language skills - Ability to meet a deadline Please provide your portfolio of previous translations, especially those in the medical field. The deadline for this project is definite, so I need someone who can meet it promptly. Thank you.

...design expert to create a clean, minimalist landing page focused on promoting my product/service. Please make sure to integrate the following details about my offerings into the design: - Specifications of product/service - Testimonials/reviews - Comprehensive price list - Terms and conditions - List of services The ideal freelancer for this task would have extensive experience in minimalist design and a keen understanding of marketing fundamentals to optimally position the product/service. The aim is to communicate these details clearly while still maintaining a clean and uncluttered aesthetic. Experience in conversion optimization and user experience principles will also be a significant advantage, as the end goal is not just to inf...

I'm in need of a skilled Laravel developer to create a QR scanner-enabled webpage. This webpage should be capable of updating a database based on the scanned QR code information. I'm not entirely sure whether an existing database can be used for this project, so your experience in setting up databases would be a plus. Key requirements and decisions to be made: - Setting up a Laravel project with QR scanner functionality - Integration of the scanner with a database to update it according to scanned QR codes - The system should handle multiple scans of the same QR code by the same user by ignoring subsequent scans - The primary action the system should take is a check-in/check-out registration process, triggered by the QR ...

I'm seeking a talented designer to assist with our company rebranding. Here's a brief of what we're after: - A fresh and unique rebranding design concept. - As the company name and specific services weren't stated, we're looking for someone who can provide a wide array of design services or is open to collaboration on multiple fronts. Ideal skills and experience for this project: - Strong experience in branding and rebranding initiatives. - Portfolio demonstrating a broad scope of work in different design streams. - Availability to collaborate and communicate on refining our brand vision. I look forward to seeing how your creativity can benefit our brand transformation.

...experience in Power Apps and Power Automate • Experience in developing Canvas and Model-driven Power App applications • Experience in developing the applications connecting to SharePoint, SQL, Oracle and external APIs • Experience in building automation workflows using Power Automate Development 1. Hands-on Expertise in Power Platform • Expertise in design and develop custom business apps (Canvas Apps, SharePoint Form Apps, Model Driven Apps, Portals) • Expertise in implementing Power Automate Flows (Automated, Instant, Business Process Flow and UI Flows) • Expertise in DataVerse and Azure Databricks and MuleSoft 2. Experience implementing Collaboration Portals,...

I need a freelancer to convert a series of simple, text-based PDF documents into Word. Your job is to ensure that the text in the Word documents is fully editable, and that the original formatting is preserved. Key Responsibilities: - Convert multiple text-based PDF documents into fully editable Word documents. - Ensure the text is accurately extracted and maintained, without any errors or omissions. - Preserve the original formatting of the documents in the Word version. Ideal Candidate: - Proven experience in PDF to Word conversion, especially with multiple documents. - Proficient in software for text extraction and formatting preservation. - Attention to detail and ability to meet deadlines. ...

I need an experienced designer who can convert 2 existing posters into vector format using Adobe Illustrator. This is to ensure that the posters can be printed at a size of 120 cm width and 180 cm hight without any loss of quality or pixelation, so the final product is crisp and clear. Key requirements: - Posters are ready and do not need any design changes - Conversion to vector format is the main task - I will be printing the posters at a size of 120 cm width and 180 cm hight, so the vectorization must be of high quality to accommodate this - The final deliverable should be in a format that will not lose quality when scaled, such as SVG or PDF. - Experience with large format printing is a plus The deadline for this project is ASAP. Please let me know ...

...skilled developer to convert my current RSPS client to NXT. The main motive behind this conversion is to enhance the graphics and optimize the overall performance of the client. Key Aspects: - Improve Rendering Speed: The client should be able to render game elements swiftly without any lag or delays. - Enhance Resolution and Texture Quality: I aim to make the game visually appealing by upgrading the resolution and texture quality. - Ensure Frame Rate Stability: It's crucial that the client maintains a stable frame rate throughout the gameplay. Ideal Skillset: - Proficiency in Java: Since the current client is based on Java, it's essential that you possess strong Java programming skills. - Experience with Game Development: A b...

I'm in need of a Power Automate expert who can create a workflow system for me. This project involves getting tasks from rows in Excel and mapping them to individual tasks on a Planner board. Ideally, each row in Excel would correspond to a separate task on the Planner board. Skills & Experience: - Mastery in Power Automate - Solid experience with workflow creation - Strong knowledge in data management - Familiarity with Excel and Planner integration - Ability to deliver tasks promptly and accurately Your job is to ensure a seamless process of data management, with all tasks neatly organized and displayed on the Planner board. With your help, task automation will come to life, enhancing my productivity...

I need a professional to convert the information in the attached document into an organized, well-formatted Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and charts in the document accurately into the Excel. - Maintain the original formatting of the data in the document. The Excel document should: - Include all columns and rows from the original document. - Not require any additional formulas or functions.

I'm looking for a skilled and experienced professional who can convert a 50-100 page PDF document into an editable Word file. The primary goal of this conversion is to facilitate content editing in the Word document. Key Requirements: - Convert 50-100 page PDF to Word - Ensure the Word document is editable - No specific formatting style required Ideal Freelancer: - Proficient in PDF conversion to Word - Detail-oriented with high accuracy - Previous experience in similar projects Feel free to ask any questions for further clarification.

I need automation load tester to simulate multiple users on a website and test its performance under heavy loads. I need this automation loadtesting to be done using Jmeter Your primary responsibilities will include: - Developing a robust load testing system that can simulate high load of concurrent users - Running tests against the website to identify performance issues under heavy load - Providing reports and recommendations to improve the website's performance The ideal candidate should have: - Proven experience in developing automation load testers - Strong understanding of website performance testing and optimization - Ability to work with minimal supervision and deliver high-quality results - Previous experience in test...

I have a bulk of handwritten records that needs to be typed into a spreadsheet. The data will be used for analysis, so accuracy is important, though minor errors are acceptable. Key requirements: - Convert handwritten records into a digital format - Enter the data into a spreadsheet - Ensure moderate accuracy with minimal errors Ideal Skills: - Data Entry - Fast Typing - Attention to Detail - Basic Knowledge in Data Analysis - Experience with Handwritten Data Conversion would be a plus

...proven experience and expertise in Wikipedia editing. Requirements: -Content Creation: You'll be responsible for writing the content for the Wikipedia page. The content should be well-researched, informative, and neutral. -Notability Verification: We have multiple reliable third-party sources to verify the notability of our company. You should be able to effectively use these sources to establish the credibility of our page. -Approval and Publication: Once the page is written and ready, your job will be to get it approved and published. We will only pay after the page is successfully live on Wikipedia. Key Skills: -Professional Wikipedia Editing: Demonstrable experience in creating and editing Wikipedia pages. -Research Skills: Abi...

I urgently require a proficient SQL Server expert, particularly conversant with SQL Server 2012. My primary challenge is recovering deleted records. Ideal Skills: - Comprehensive understanding of SQL Server 2012 - Expertise in data recovery processes Experience Required: - Proven track record in database recovery - Past work with SQL Server 2012 Your immediate availability for this project is essential. Please, only serious and experienced candidates should bid.

I need a Python developer to help me convert a PDF file into an XML file. And Share that Python Code With me as well. Key Requirements: - The primary task is to extract text from the PDF and structure it into an XML file. Ideal Skills: - Strong proficiency in Python, with a good understanding of its syntax and libraries, particularly for PDF processing. - Experience in text extraction from PDFs is a plus. Please note that I do not have a predefined XML structure in mind, so I'll need some guidance on how to structure the output.

I'm in need of a website developer with a flexible skillset, considering the purpose and type of the website and design preferences were not specified: - Since the type of the website wasn't chosen, it's likely that we may have to go through a few iterations before landing on the final product. You should have experience with developing a variety of website types including but not limited to E-commerce, blogs, and portfolio websites. - The purpose of the website is also open-ended, so freelancers with a background in creating websites that serve multiple purposes such as sharing information or content, selling products or services, and showcasing portfolios or projects would be ideal for this task. - In terms of design, you will b...

I have a scanned PDF that needs to be converted into a Word document. The text formatting in the Word file should mirror the original PDF. There are no images in the PDF that require editing or enhancement. Key Requirements: - Convert a scanned PDF document into a Word file - Maintain the text formatting of the original PDF - No image editing or enhancement required Ideal Skills and Experience: - Proficiency in OCR (Optical Character Recognition) software - Experience in PDF to Word conversion - Attention to detail to ensure formatting accuracy

...utilizes Google Chrome to perform searches and click on search results multiple times. Key Project Requirements: - The tool should be built using Python, Java or Visual Basic - The primary goal of the tool is to perform automated web browser searches and click on various results - The tool should utilize Google Chrome as the web browser To give you a better idea, the tool should: - Conduct multiple web searches on Google - Click on a configurable number of search results from the returned search page Ideal Skills and Experience: - Proficient in Python, Java or Visual Basic - Experience in browser automation and web scraping - Familiarity with Google Chrome's automation capabilities If you have experience with similar projects or ...

I am looking for a skilled graphic designer to assist with the rebranding of my company, PumpSpec, along with its divisions R&D Pumps & Power, National Mining & Civil Solutions, , and Thinkwater Fleurieu. The primary goal is to create a cohesive and modern visual identity that reflects our businesses. Key deliverables include: - Design of letterheads and business cards for each division, aligned with the new visual identity - Incorporating the chosen color scheme of Black and Blue, with the option to add other complementary colors - Inclusion of essential information on the stationery such as company name, address, phone number, website and email address, logo and tagline we want all businesses to be on the footer The desired design style should ...

I'm in immediate need of a skilled data entry operator located in Pune, India, to rectify a Microsoft Office Word document. This task is essential as it requires meticulous attention to detail. Key Tasks: - Rectify the formatting errors and spelling/grammar mistakes in the document. - Make necessary table and layout adjustments for improved readability. - Remove the 'Year' field from one of the rows in the table. This project demands: - Proficiency in Microsoft Office Word. - Exceptional eye for detail to correct formatting, spelling, grammar, and table-related issues. - Ability to follow instructions meticulously. - Excellent communication skills for any clarification or feedback. Please only apply if ...

I have an edited Excel spreadsheet that needs some final touches. I have a macro that needs to be created to hide and unhide rows in the sheet. Key tasks include: - Creating a macro that enables the user to hide and unhide specific rows using a button Ideal Skills: - Expertise in Excel macro creation - Proficient in data manipulation and Excel functions - Experience in creating user-friendly interfaces - Attention to detail to ensure the macro functions correctly and efficiently This project is straightforward and should be quick for an experienced Excel user.

...UltraDisplayAds. The goal is to acquire 1000+ customers within the first 6 months. Key Responsibilities: - Develop a comprehensive marketing strategy that targets small businesses, medium-sized businesses, and large enterprises - Plan and execute marketing campaigns to drive customer acquisition - Monitor and track the effectiveness of the strategy and campaigns to optimize results Requirements: - Proven experience in SaaS and/or tech industry marketing - Ability to create and implement strategies that will help us grow from zero to 1000+ customers within 6 months - Proficiency in various marketing channels such as email marketing, social media advertising, and SEO optimization is a plus (though we are open to new ideas) - Under...

Saya cukup familiar sebagai development website, memahami Hosting, Cpanel, Spanel dll, maintenance website, mempercepat loading speed website, debug sistem, revamp website, membuat company profile, blog, ecommerce, news portal, forum, salespage, landing page. Convert PSD to HTML (Slicing + Responsive Layout All Device), menguasai CMS wordpress (13th), Woocommerce (pengalaman 11th), plugin wordpress, blog Wordpress, CMS online shop opencart (pengalaman 11th), CMS Ecommerce Magento (pengalaman 6 tahun ), framework CI, php native. Selain develop website, Saya juga bisa membantu website dengan mengoptimalkan SEO User Friendly. Menguasai DIgital Marketing, Google Analytics, Google Map Business, Google Ads, Google Adsense, Facebok Ads, Instaram Ads, Menguasai Search Engine Marketin...

I'm looking for a social media manager to help me grow my presence on various platforms. Your primary goals will be to increase brand awareness, drive website traffic, and grow my social media pages. Key Responsibilities: - Manage accounts on Facebook, Instagram, Twitter, Pinterest, and LinkedIn. - Develop and curate engaging and shareable content tailored to each platform. - Monitor and respond to audience comments and engagement. - Implement strategies to increase followers and engagement. - Drive traffic to my website through well-planned campaigns. Ideal candidate: - Demonstrable experience managing social media accounts across multiple platforms. - Strong understanding of each platform's analytics and how to interpre...

I am in need of a skilled developer to assist with an existing API integration between SilverStripe website and REX Software, with a focus on correcting a data issue that is causing the server to fail with backing up the website due to disk usage. The server technician said: "The disk usage is at 80% so a dump would fail as it would need more space to create a sql file to be transferred. It looks to be an issue with REX and the website framework SilverStripe. It may be that REX is not configured to remove (dump) old data." Your role will involve correct the error so the server does not continue to reach its disk usage and implementing a seamless API integration that successfully synchronizes and updates prope...

I need a professional to develop an engaging medical education website for a written/video format course with an integrated question bank. Here, the primary objective is e-learning of anatomy through a substantial base of over 1000 multiple-choice, true or false questions and short answer questions. Ideal skills and experience to have: - Expertise in e-commerce website development - Experience in creating intuitive, user-friendly layouts - Knowledge of online education or e-learning websites would be advantageous - Familiarity with designing interactive question types, such as multiple-choice and true or false questions - Capacity to handle widespread content effectively Your job will be to incorporate these aspects to ensure...

I am in need of an Excel expert who can create a dynamic and well-structured line graph based on data from a questionnaire that automated itself using text and numeric data. This project requires knowledge and practical experience with: - Excel data manipulation - Advanced graphing techniques - High attention to detail. The project specifically involves working with three or more different data sets and multiple excel books. The right candidate should have a track record of creating visually stunning and effective Excel graphs that allow for easy interpretation and extraction of meaningful insights from text data. The line graph should allow for a comprehensive overview of all data sets at once. It should make it easy to identify trends and changes over time...

โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด

โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด

I'm looking for a skilled professional to set up a Virtual Box on my dedicated server, running Windows OS. The primary function of this setup is to have multiple virtual terminals of Windows operational. Key requirements: - Installation of Virtual Box on a dedicated server - Configuration for simultaneous operation of 5 virtual terminals of Windows Ideal skills and experience: - Proficiency in Virtual Box and working with dedicated servers - Strong knowledge and experience in setting up and configuring Windows OS - Ability to ensure smooth and efficient operation of multiple virtual terminals