Sql server transpose rows to columns without pivotงาน

แอพสำหรับเชื่อมต่อ Proxy ให้ความสะดวกกับลูกค้า ใช้งานได้ทั้ง Login และ ไม่ต้อง Login *ถ้า Login โปรแกรมจะแสดงรายการ Proxy ที่เช่า แล้วสามารถกดเชื่อมต่อ ได้เลย *ถ้าไม่ Login ก็สามารถตั้งค่าต่างๆ เองได้ Proxy connection app provides convenience to customers. It can be used for both login and without login. * If login, the program will display the list of Proxy that is rented and can click to connect immediately. * If not Login, you can set various settings by yourself.

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

พัฒนาระบบอัตโนมัติสำหรับรวบรวมข้อมูลที่มีคุณภาพจาก Social Media เพื่อแยกประเภทตามโครงสร้างหมวดหมู่ต่าง ๆ ตามที่ต้องการในเว็บไซต์ได้ โดยไม่ต้องใช้คนทำงาน Can develop an automated system for collecting quality information from Social Media in order to classify according to various types of structure as needed on the website. Without using workers

ติดตั้ง 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.

hacking on a whatsapp account without access to the target's phone

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 และ อื่นๆ เรามีความเป็นมืออาชีพ ทำงานเร็ว คุณภาพเยี่ยม คุ้มค่า คุ้มราคาแน่นอน ติดต่อเรา

...individual with experience and necessary equipment to help me move some couches. The job involves moving the furniture from my current apartment, situated on the 2nd floor, to another location. Here are some additional details: - The couches will need to be taken down a set of stairs at the pickup location and then up a set of stairs at the delivery location. - I will have someone available at both locations to assist with the move. - No specific requirements in terms of material or size restrictions, just your standard, bulky couches. I need someone who can ensure the couches are moved safely and securely without any damage. Experience in moving heavy furniture is a must. Please come with the necessary equipment, such as dollies or straps, to...

We require a professional logo that will serve as the identity of our brand to include our business name: Tan Your Way Wellness Spa. Key requirements: - The logo should reflect a professional tone, considering it's for a brand identity. It needs to communicate reliability, credibility and expertise. - Please note that we do not have specific colours in mind for the logo. Feel free to suggest a color scheme that aligns with a professional image. - The design should be versatile and adaptable for use across different mediums, such as print, digital, and social media. Ideal Skills and Experience: - Experience in designing logos for brand identity. - Understanding of colour psychology and its application in creating professional and trustworthy visuals. - Profic...

I am currently having issues updating my pages with Elementor, and I'm not receiving any error messages. Additionally, I've noticed that my website's performance is slow and could benefit from more memory. Key Requirements: - Troubleshoot and resolve the issue of Elementor not updating pages without error messages. - Optimize the website's performance to improve its speed. Ideal Skills and Experience: - Proficient in WordPress and Elementor. - Experience in troubleshooting and resolving plugin compatibility issues. - Demonstrable experience in website optimization for speed and performance enhancement. Your bid should address these points specifically. Please provide examples of similar work you've completed in the past.

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

...creator to assist me in crafting a 3-4 minute video that encapsulates the journey of a young bride and groom. I need a FAST turnaround time and need the project completed by 5/24. Please do not bid if this deadline cannot be met. Key Requirements: - The video will take viewers on journewy of trwo young people with focus on recent relationship - Must be energetic and upbeat, reflecting the joy of a wedding celebration. - Captions should be simple and minimalistic, enhancing the storyline without overwhelming it. Skills and Experience: - Extensive experience in video editing, particularly emotional or celebratory content. - Proficiency in selecting and incorporating music to evoke desired emotions. - Prior experience with creating captions in a manner that complemen...

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.

...and analysis purposes. Key Details: - The meetings are expected to continue for three days each. - All meetings will be conducted in-person. - Clarity and audio quality are of utmost importance. - Quick turnaround time is crucial. Required Skills & Experience: - Proven experience in professional audio recording, particularly in meeting and conference settings. - Strong attention to detail and professionalism. - Fast and efficient, without compromising the quality. - Excellent time management skills. - Ability to handle unforeseen recording challenges that may arise. - Familiar with different audio formats and compression settings, to deliver the final product in the desired format. - Understanding of audio editing, to remove unwa...

German Recording project We have a project, that needs Native German speakers, we will give you the text, and you need to record 89 short sentences. you just need to download our software, to read our text and record it, it's a very easy job. 1. You will need to record in a quiet place without loud background noise. and without an echo. 2. Each person Price is 8$ for 89 short sentences record. 4. The project will take about 10-15 mins only. If you are interested please let me know sure. I will contact u. A Good Opportunity For New Freelancers For taking 5 Star Review after their completion of the project. Thanks :

Russian Recording Project Note : We need Freelancers for long term project. We have a project, that needs Native Russian speakers, we will give you the text, and you need to record 626 Short sentences. you just need to download our software, to read our text and record it, it's a very easy job. 1. You will need to record in a quiet place without loud background noise. and without echo. 2. Each person is $13 dollar for 626 sentences record. If you are interested please let me know sure.I will contact u. A Good Opportunity For New Freelancers For taking 5 Star Review after their completion of the project. Thanks :

...who is proficient in Autodesk Revit. My project requires: The Conversion of 3D laser scans with BLK360 into high quality, detailed Revit models. The objects is the survey of information of a structure of 335m2 in plan made up of two levels, the first level consists of a structure of 6 columns that are part of a system of frames resistant to moments, on an articulated base. On the second level there are two structures to support the air coolers, in each one there are 4 fans and they are made up of 15 columns working in a system of gantries with concentric braces. The information that the survey must contain is: Geometry, profiles, connections, gas pipes, equipment or elements that may present interference in case of reinforcement. The information must be pr...

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

I'm the owner of a WordPress website and have administrative access. I'm looking for a skilled developer to help me change the admin email without altering the username, password, or other settings. The primary reason for this change is to ensure that the contact information displayed is up-to-date. Key requirements include: - Updating the admin email: The new email address will be provided to the selected freelancer. - Maintaining username and password: It's crucial that these details remain unchanged. - Preserving other settings: The current configurations, including security measures and other account settings, should not be affected. Ideal skills and experience for this job: - Proficiency in WordPress: The ideal candidate should have...

I am currently using R, specifically the ppcor package, to conduct partial correlations on a sizable dataset. Unfortunately, the process is slow and fails to address all columns efficiently. I'm seeking assistance to: - Improve the computation speed - Enhance the handling of columns within my dataset The ideal freelancer for this task should be proficient in R programming, with specific experience in working with the ppcor package or similar tools for statistical analysis. A background in optimizing code for large datasets would be highly beneficial.

I'm seeking a talented saxophonist proficient in playing Smooth Jazz for a solo performance in New Orleans. The saxophone player must: * Be familiar with and able to play various smooth jazz tunes * Have excellent solo performance skills Ideal candidates should have prior experience in similar performances and be able to adapt smoothly to changes that may occur during the live performance. The project requires a dedicated, enthusiastic and professional saxophonist comfortable with performing solo, without any band or other musicians. Experience in live performance and a passion for smooth jazz are essential for this role.

I have...fine editing. I have a (hopefully) temporary condition called Bell’s Palsy. This unfortunately came up right before graduation and has made my graduation photos something I am not excited to share. I need editing to make my face resemble its former state, of which I will attach a picture. Specifically, I need an expert with: - Proficiency in color correction and retouching. - Skills in facial structure manipulation, particularly in modifying eye shape, mouth shape, and ensuring symmetry on both sides of the face. This is a delicate and artistic task requiring precision in the reshaping of features without compromising the natural feel. Therefore, prior experience with such projects would be ideal. There is potential for additional pictures needing ...

I'm in need of a skilled 3D designer who's proficient in Blender to assist with some adjustments to three related sculptures. It's crucial to note that these are not new designs, but rather modifications on existing STL files. Key Details: - The task involves resizing and tweaking small details on all three models. - One of the key requirements is to increase the size of the sculptures. - Specific dimensions for the increase will be provided. Essential Skills: - Proficient in Blender program. - Experience with modifying existing 3D models. - Attention to detail for small adjustments. Timeframe: The adjusted models are needed by Monday, hence I'd appreciate someone who can complete the task promptly without compromising...

I'm experiencing an issue 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 swiftly will be a key...

Russian Recording Project Note : We need Native Russian speakers for long term project. We have a project, that needs Native Russian speakers, we will give you the text, and you need to record 626 Short sentences. you just need to download our software, to read our text and record it, it's a very easy job. 1. You will need to record in a quiet place without loud background noise. and without echo. 2. Each person is $14 dollar for 626 sentences record. If you are interested please let me know sure.I will contact u. A Good Opportunity For New Freelancers For taking 5 Star Review after their completion of the project. Thanks :

...troubleshooting issues related to printing PDFs. Additionally, I'd like to streamline my paystub downloading process to avoid the need for printing, looking to have them saved directly as PDFs. Key Responsibilities: - Troubleshoot QuickBooks Snappt: I need assistance to ensure that the PDFs generated are correctly formatted and able to print efficiently. - Automation of Paystub Downloads: I'm looking for a solution that will download paystubs directly as PDFs, without the need for printing. This should enhance efficiency and save time in the long run. Ideal Skills and Experience: - Proficiency in QuickBooks: Experience with QuickBooks, especially Snappt, is fundamental for this project. - Troubleshooting Abilities: A proven tr...

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

...experienced software developer who can design a robust and user-friendly Tatkal ticket booking system specifically for Windows. Key features should include: - Ticket Booking: The software primarily needs to focus on facilitating ticket booking. It should be linchpin of the operation, thus needs to function seamlessly, quickly, and without glitches. - Booking Confirmation: Once a ticket is booked, an immediate confirmation should be sent to the user. This will require integration with email or other notification systems. - Seat Availability Check: Crucially, the software should allow users to check seat availability in real-time. This feature is crucial for making instant decisions on bookings. Ideal skills and experience for the project include pro...

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 (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

...Maps API to create an interactive map feature for my website. This map should allow users to enter their street address. Once done, it should show an aerial image of their house and give an estimate of the square footage of the landscape without structures. Key requirements: - Users should be able to directly input their street address on the website to obtain the aerial image and square footage estimate. - The map should be interactive, but only for viewing purposes. No advanced interactions like drawing or area selection are needed. Ideal skills and experience: - Proficient in Google Maps API and integrating it into websites. - Experience in developing interactive elements on websites. - Strong understanding of front-end development to ensur...

...Lambda functionalities, specifically in setting up and running code in response to events. Ideal Candidate: - In-depth understanding of AWS Lambda functions and AWS Lex - Strong experience with running code in response to events - Should be able to guide me through the process effectively I want to be able to learn how to integrate my Lex bot with the Lamda function that I have created. I need someone to advise on the configuration of aliases and permissions and how to invoke the function in Lex. I have the pieces setup so don't think it will take too long for someone experienced to show me what I am missing. Initially all I want is the Lambda function to invoke my bot and play a Welcome without needing...

create 10 spreads (20 pages), an A5 book or magazine for Porsche Develop full research about the topic and writing the content to design an interactive digital artwork. Tasks to be covered: Task 1: Research your selection and analyze all needed aspects. Also, Mood Board (your visual research) + Layout plan (Dividers and interactive buttons) as we discussed in the class. Task 2: Design a suitable layout for your selected topic. Use Table, margins, columns, master pages, and paragraph/character style. Task 3: Submit InDesign file (Packaged) and export an interactive digital file (PDF). Task 4: A Presentation on screen, that discusses the project’s concept and process.

I need assistance with m...assistance with migrating my large WordPress website from GoDaddy to Hostinger. The site is over 100MB in size and includes both custom themes and plugins. Key Requirements: - Migrate large WordPress website (over 100MB) from GoDaddy to Hostinger - Ensure smooth transition of custom themes and plugins I do not require the migration of any email accounts associated with the website. It's crucial that the migration is done swiftly and accurately to avoid disruption to the live site. Ideal Skills and Experience: - Proven experience in large WordPress migrations - Expertise in handling custom themes and plugins - Strong understanding of GoDaddy and Hostinger hosting environments - Excellent communication to ensure a smooth t...

create 10 spreads (20 pages), an A5 book or magazine for Porsche Develop full research about the topic and writing the content to design an interactive digital artwork. Tasks to be covered: Task 1: Research your selection and analyze all needed aspects. Also, Mood Board (your visual research) + Layout plan (Dividers and interactive buttons) as we discussed in the class. Task 2: Design a suitable layout for your selected topic. Use Table, margins, columns, master pages, and paragraph/character style. Task 3: Submit InDesign file (Packaged) and export an interactive digital file (PDF). Task 4: A Presentation on screen, that discusses the project’s concept and process.

I have an hour-long Spanish audio that needs to be dubbed into English. The content is entertainment-based and requires precise timing and emotional match with the original. Key Requirements: - Dub the Spanish audio into English - Ensure the timing of the dubbed audio matches the original - Maintain the emotional nuances of the original - Experience with audio dubbing is a plus - Ability to handle an hour-long audio without quality loss

When you bid on this project start your bid with "I CAN DO THIS" There is so much automated bids that it just wastes time. Also bid responsibly and don't ask " What's your budget" Bid what you think it's worth to you. I want a clean new Quasar Application that you load "@anthropic-ai/sdk": "^0.21.0", and makes a call using Setting up a demo Quasar app takes less than 5 min. my sample code: async sendMessageToClaudeChatbot(message) { this.Claude_question = "Claude Question"; const anthropic = new Anthropic({ apiKey: process.env.CLAUDE_COLAB, }); (anthropic); const anthropic_message = await ({ // mode: "no-cors", max_tokens: 1024, messages: [...

...helps our agents to send an order. This page should be intuitive and user-friendly while ensuring all necessary information is captured. The platform should be interactive and user-friendly, ensuring a smooth order submission process for our agents. Ideal Skills: - Proficient in PHP - Strong experience in web development - Knowledge in creating secure web forms - Experience in agent-based systems would be a plus Please bid for this project if you believe you have the skills and experience needed to deliver a high-quality, efficient, and secure PHP page for our agents. Our customer sells products (not online, but in shop). He wants to receive orders from agents. I have an excel file containing the products that he wants to sell. The excel file has 5 ...

...terface for data entry We want to have 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 M...