Output clause in sql server exampleงาน

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

1) ชุดควบคุม ที่รับข้อมูลจากเซ็นเซอร์ 1-6 input แล้ว นำข้อมูลมาประมวลผล และสั่งการ ทั้งแบบ PID และ Relays output 2) จาก 1st stage พัฒนาต่อยอด เป็น IOT on desktop and Mobile.

ทำระบบการเลี้ยงปศุสัตว์ (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

ติดตั้ง VOIP SERVER เพื่อใช้โทรศัพท์สายในและสายนอกบน Linux

ต้องการสร้างแอพ 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 Serve...

ต้องการ 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

PBX System SIP Server on Cloud สำหรับธุรกิจขนาดกลางและเล็ก โดยไม่ต้องลงทุนอุปกรณ์ Server PABX PBX ต่างๆ ไม่ต้องเตรียม infra ให้ยุ่งอยาก เคลื่อนย้าย ไปตาม Site สะดวก โทรหา site to site ฟรี บริการค่าโทรแบบเหมา แบบรายนาที ทั่วโลก

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

Tengo 4 archivos como input. Dos XMLs con datos para mapear, 1 rdlc que especifica como se genera el PDF de salida con y que ...especifica como se genera el PDF de salida con y que debe servir como guia para posicionar los datos a pegar en el PDF y además 1 PDF con diseño basico pero que le faltan datos que deben ser desplegados segun las diposiciones del RDLC, todo esto en tiempo de ejecución. Es decir paso 4 outputs distintos y me genera un PDF con datos dispuestos coherentemente. Todos los archivos Inputs y Output van en el zip adjunto. Se puede partir con una prueba de concepto, en donde se pinten al menos un par de campos en las posiciones basadas en el RDLC y tambien la tabla de datos que corresponde de los nodos Detalles del XML llamado dtetimbrado.

I'm experiencing an issue where my website isn't loading. Thi...where my website isn't loading. This problem has emerged recently, without me making any recent changes to the website or server configurations. I need a skilled professional to help me quickly troubleshoot this issue and get my website back online. Your role will involve: - Investigating and identifying the root cause of the website's failure to load - Resolving the issue effectively and efficiently - Ensuring the website operates smoothly post-fix Ideal candidates should have extensive experience in troubleshooting websites that run on Apache servers. Strong familiarity with PHP-FPM and Webmin will be a significant advantage. Your ability to identify and remedy server issues swiftl...

...Classic Hip-Hop rap song based on a rap I've written and my voice. The song I would like to be AI-generated should be between 3 and 5 minutes in length. Key Requirements: - The freelancer should be capable of using AI tools to transform my voice into a captivating Classic Hip-Hop rap song. - The final output should maintain the essence of the original rap I've written while being in line with Classic Hip-Hop style. - I will provide the background music for the rap song. Ideal Skills and Experience: - Proven experience in using AI for music production - Strong understanding of Classic Hip-Hop music style - Excellent audio editing skills - Creativity in transforming text into music Please respond with your previous work samples and a brie...

I'm in need of a seasoned Mechanical Engineer with specific expertise in heat transfer, fluid dynamics, and thermodynamic cycle analysis to assist in the development of a revolutionary solar thermal engine patent prototype. Key Requirements: - Conducting in-depth thermodynamic cycle analysis for the solar thermal engine. - Designing the engine layout and key components to optimize its performance. - Understanding and managing the behaviors of steam vapor and condensate. - Proficiency in analyzing fluid flow, power, and pressure drop. - Knowledge of steam hammer and heat pipe behavior for this application. - Experience with developing engines within the 1-5 kW power output range is essential. Ideal Skills: - Proficiency in C...

I'm looking to automate podcast transcription service. 1. I need a service to follo...transcription service. 1. I need a service to follow Podcast Rss Feeds and listen for new episodes 2. I need Listen Notes to download the podcast audio file 3. I need Chatgpt to transcribe the audio file 4. I need an output of the transcribed text made into a google document 5. I need Chatgpt re-write the transcribed text into an article with a Title, meta text and the content of the article. 6. I need the re-written article to be saved in a Google document 7. I need the document to be re-written in 8. I need the re-written document by saved in google document You should know python and have api integration skill set you should know how to use and the process flow

I'm in need of an experienced photo editor who is skilled in facial adjustments, specifically in chin reduction. The primary task for this project involves subtle refinement of the chin area while preserving a natural and realistic appearance. Although no other facial adjustments are needed for this particular task, I'd prefer if you have a broader expertise in editing tasks such as retouching, color correction, background removal and photo manipulation. It's very important for the final output to appear natural and realistic. Therefore, a discerning eye for detail and a clear understanding of facial anatomy is a must.

I'm in need of an experienced photo editor who is skilled in facial adjustments, specifically in chin reduction. The primary task for this project involves subtle refinement of the chin area while preserving a natural and realistic appearance. Although no other facial adjustments are needed for this particular task, I'd prefer if you have a broader expertise in editing tasks such as retouching, color correction, background removal and photo manipulation. It's very important for the final output to appear natural and realistic. Therefore, a discerning eye for detail and a clear understanding of facial anatomy is a must.

I am Building AWX Server on AWS EC2 Here is the method I am using: So far, I have: I have already Created an EC2 instance for this server. Cloned the AWX Repo, I have completed all installations required (installed Docker, Docker-Compose, I have used pipx to install the Ansible package) I need help with the rest of the instructions from that link. I am building this server in VS Code Ideal skills for the job include strong understanding of AWS, proficiency in AWX tasks and familiarity with Ubuntu server.

I'm seeking a skilled 3D artist to create high quality, photorealistic renderings. These will be used for marketing and advertising initiatives. The specifics are as follows: - Output: High-resolution JPEG images. - Style: As realistic as possible. I'm after a lifelike representation. - Purpose: The renderings will be used in various marketing and advertising materials. Ideal Skills: - Exceptional ability to create photorealistic 3D renderings, preferably with prior experience in advertising contexts. - Proficiency in using state-of-the-art 3D modeling and rendering software. - Excellent attention to detail. Looking forward to your creative approach and fresh thinking!

...document containing the output. The details of the literature search can be found in the 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...

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 corresponding points on the images (at least 3). Pairs of dots will be marked with crosses of the same colour in the images, but distinct (random choice of colours) for each pair. After pressing a key a third image will be displayed containing the first image pasted to the second image on a black background. For this, the image registration algorithm will be implemented, which calculates the geometric affine transformatio...

Please develop a Python script to retrieve restaurant data from Google Maps using the Maps/Places API. T...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 (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 Minecraft expert to help me set up a survival mode Minecraft server. Key Project Details: - **Survival Mode Setup**: The primary focus of this project is to create a distinctive survival mode suitable for a smaller player base. - **Unique Items**: I will need engaging, custom, and unique items for players to discover and utilize in the game. - **Crate Rankups Integration**: I also want to include a crate rankups system to add a layer of progression and reward for players. Ideal Skills and Experience: - **Minecraft Server Administration**: Experience in setting up and maintaining Minecraft servers is a must. - **Plugin Development**: Proficiency in developing Minecraft plugins is highly desired, specifically for creating custo...

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

I'm in need of a skilled Z Brush expert to help with a specific intermediate-level sculpting project, which will be used for 3D printing. Key requirements include: - **Sculpting:** The task is primarily focused on sculpting, so a strong proficiency in Z Brush is essential. - **Complexity Level:** The project involves working on intermediate details and textures, so prior experience with intricate designs and textures is a significant advantage. - **Intended Use:** The sculpted model will be used for 3D printing. Understanding the specific requirements for this output is necessary. The ideal candidate should have a proven track record of similar Z Brush projects, particularly those involving intermediate-level sculpting for 3D printing. They should be able to tr...

We are in the middle of migrating Django to a new server. - Both servers run Ubuntu 20.04, postgres 12, python2.7 - The Django Project is already transferred over - Nginx has been configured - Postgresql has been setup Our struggle is to get the actual application up and running again. Your job will be to: - help to perform a clean export of the postgres database on old server - help to import the postgres database on the new server - ensure the Django application is coming back up smoothly The work will be done using shared tmate ssh sessions.

I need a VRBO scraper to extract property details, pricing, and availability. - The scraper should be built with Python and the output should be in CSV format. - The data points I need include property title, description, amenities, pricing, and availability. - The scraper should be able to handle multiple URLs at once. - The code should be well-structured and commented for easy maintenance. Ideal skills: - Proficiency in Python - Experience in web scraping - Understanding of VRBO website structure - Ability to handle and store data in CSV format

...issue with my IIS 8 server. Specifically, I'm unable to reflect image updates across the server. Key Requirements: - Troubleshoot IIS : You should be experienced with IIS and capable of identifying and resolving server-related issues. - Server Configuration: The problem may be related to server settings, so a deep understanding of IIS configuration and management is desirable. - File Management: The issue seems to be related to file update. You should have expertise in managing files on Windows servers and diagnosing related issues. - Image Handling: The problem specifically pertains to image updating. You should be well-versed in how servers handle image uploads and updates. Your task will involve: 1. Diagnosing the issue: Under...

...20.1 and have an issue with Jasper Reports not executing properly. This can be a server side issue in JasperServer because the reports and applications are working fine in our development environment but in UAT are failing. I need a skilled professional who can troubleshoot and fix this issue. Your main tasks will include: - Analyzing the current setup and identifying what's causing the problem with PDF output. - Implementing the necessary changes to ensure Jasper Reports are correctly executed from Oracle Apex The ideal freelancer for this project would have: - Proficiency in Oracle Apex. - Strong experience with Jasper Reports - Past experience in troubleshooting and fixing similar issues, including server side issues. - ...

...Required output: PDF document - Analysis: I need you to analyze the number patterns for this data, specifically looking at numbers used once versus those repeated over multiple years. This analysis should be done thoroughly and presented in a clear, easy-to-understand manner. Ideal freelancer skills and experience: - Proficient in data conversion and organization - Skilled in creating and working with PDF documents - Experience in data analysis, especially patterns and number analysis - Ability to create visual representations, such as charts and graphs - Strong attention to detail and accuracy. 1. Google takeout data conversion and organization. 2. Multiple years of cell records to analyze 3.I am attempting to make a clear timeline using payment re...

I need a desktop software designed to help me collate and manage Bible verses from the New King James Version (NKJV). Collation of 500 Most Popular Bible Verses We are developing a spreadsheet-based database of the 500 most popular New King James Version (NKJV) Bible verses and collation (into Excel or Google Sheets). The output must be in the NKJV and adhere to a strict protocol - The quotation - Source in a specified format (e.g. 2 Kings 3:2-5 - Maximum 55 words Extensive source material is available online, and we encourage the use of existing source material, with the primary emphasis on the collation/assembly into the required format. We are happy to answer relevant questions for clarification. Ideal Skills: - Native English - Familiarity with the Christian ...

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

As the main user of a system integrated with Google Sheets and Zapier, I'm currently grappling with some performance issues. Concretely, there's a challenge with incorrect data output from our automated data and workflow program. I'm seeking an expert to: • Conduct a thorough audit and maintenance of our data-entry automation and workflows • Identify the root cause of the inconsistent output, and provide tailored solutions • Enhance the reliability of the system overall to prevent any future issues. Presenting a solid proficiency in Google Sheets, Zapier, and workflow optimization, your skills will indeed come in handy for the successful troubleshooting, rectification and enhancement of the system. Efficiency and a keen eye to det...

I'm in need of a skilled Python developer to assist in creating a client-server application. This application will be responsible for handling data transfer and supporting information about bus and train routes. Key Requirements: - Expertise in Python and Socket Programming - Experience in creating client-server applications - Ability to work with and manipulate data Your responsibilities will mainly revolve around setting up a robust client-server architecture to support bus and train route data. I already possess the data, so the primary task will be focused on the actual programming and integration of the application. Experience in working with transport data or similar datasets would be advantageous. I'm looking for ...

I'm seeking a skilled professional translator to co...entertainment content and must be translated accurately, with attention to detail to maintain context and humor. Key Requirements: - Fluency in English and Spanish - Proven experience in video subtitling - Background in entertainment translation preferable - Ability to match subtitles with audio cues - Proficient in relevant software for both embedding and providing subtitles as separate SRT files The output should be provided as both embedded into the video and as a separate SRT file. It’s important that the video maintains its original tone and humor, so experience in translating entertainment content is highly desirable. If you have a background in this area and can deliv...

I'm looking for a skilled artist who can create a replica of an existing image in a cartoonish style. The replication should closely resemble the original but with altered proportions or details. This new image will be used for digital purposes, such as on websites and social media. Key Requirements: - Replicate an existing image in a cartoonish style - Maintain a close copy of the original with altered elements - Ensure the final output is suitable for digital use Ideal Skills and Experience: - Proficient in digital art and illustration - Strong understanding of proportions, details, and shapes - Experience in creating cartoonish art - Ability to replicate existing images while adding a unique touch - Understanding of digital use and design princi...

...information management processes and methodologies. Skills in database design, data security, and data lifecycle management (i.e., gathering, cleansing, publishing, archiving, back-up and recovery, and purging) for large enterprise systems. Familiarity with master data, metadata, reference data, data warehousing, database structure, business intelligence principles and processes, and technical architecture. Knowledge of database management systems, metadata management tools, cloud storage, and associated security considerations. . Combinations of experience and education will be considered on a case-by-case basis. Experience in data warehousing and governance. Practical experience in enabling data usability, availability, and efficiency. Experience in data ma...

I'm looking for an expert in Microsoft Power Apps to develop a canvas screen for me. The screen will enable the gathering and insertion of information into a database. Requirements: - Incorporate text inputs, dropdown menus, and date fields for gathering information. - The preferred database language is Microsoft SQL Server but SharePoint can be used as an alternative. Additional Information: - You don't need to worry about any additional features or functionalities. The main goal is to develop a basic, yet effective form for data collection. Ideal candidates should have experience in: - Microsoft Power Apps development. - Integrating Power Apps with databases, specifically Microsoft SQL Server. You should be comfortable working i...

I'm in immediate need of a talented professional who can help with the restoration of my server. I have experienced some issues with the server and after thorough review, I believe the best approach would be to restore the server data from a full backup. Key responsibilities: - Diagnose server issue(s): The tasks require the freelancer to identify the root cause of the server malfunction. - Conduct server restoration: The main task at hand is to effectively restore the server from a full backup. The ideal candidate should: - Have extensive experience in server restoration, with a specific focus on full backups. - Demonstrate a high level of proficiency in diagnosing and solving server problems. - Be...

I'm in need of a skilled professional to help me set up a high availability cluster for my web servers using Nginx. The primary goal for this cluster is to ensure load balancing, allowing for optimal performance across the servers. The ideal candidate will have experience in server clustering, particularly with Nginx, and will have a deep understanding of load balancing methodologies. You should also be familiar with high availability setups and be able to ensure a seamless failover process in the event of any server failure. The project will require a methodical approach and a strong attention to detail, ensuring that the cluster is set up correctly and is able to function effectively.

This is my website i want to increase sales on it using Facebook ads tried many times with many people every time just getting clicks and no output (sales) so if you can increase the sales then only take this project

I'm in need of an engineer with expertise in both electrical and mechanical engineering. Our aim is to design a high-power attachable biking dynamo/alternator for bicycles. The primary objective of this project is to create a device that can generate and store significant power for storage in high-capacity batteries. This dynamo/alternator should deliver a high power output, mainly focusing on efficiency, ease of use and weight. Key requirements: - Designing a high-power dynamo/alternator that can support extensive power needs. - The device should be attachable to a standard bicycle without impacting its performance or aesthetics. - Prioritizing power output over size or weight, meaning the final product can be robust as needed. Your role will be...

...the presentation. Maintain consistency in font styles, sizes, and spacing. Use high-quality images and graphics to enhance visual appeal. Steps to Achieve the Deliverables Initial Review and Analysis: Review the draft PowerPoint presentation. Identify areas needing visual improvement and enhancement. Analyze the provided color palette for application. Design Implementation: Redesign each slide, incorporating the color palette. Enhance the maps by refining colors, labels, and overall aesthetics. Ensure all elements (charts, graphs, images) are visually appealing and aligned with the presentation’s theme. Quality Assurance: Review each redesigned slide for consistency and professionalism. Make adjustments based on feedback to ensure high-quality output. Ensure that ...