Find number of quarters between two dates sql serverงาน

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

dice detection use c++ opencv count point for each dice object same this project https://www.freelancer.com/projects/opencv/Dice-Image-Number-detector-OpenCV/details

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

...This company is being setup in Bangkok because of a huge market in Thailand. My client will provide manpower services for all clients with a very low and competitive pricing. They are in the process of setting up a very big corporation in Bangkok. We are currently seeking freshers or low experienced people or freelancers either male or female with a good knowledge of the local areas within Pattaya and are willing to support our clients with their security requests on time and in an economical way. This will be the launch of the testing phase of the firm. WE WANT TO RECRUIT EMPLOYEES TO HELP US GROW OUR BUSINESS. THIS WILL BE OUR PILOT BATCH. IN CASE YOU ARE INTERESTED IN SHOWING THE WORLD THAI CULTURE AND CITY THEN PLEASE MAKE THE BEST USE OF TH...

โปรแกรมสามารถแสกนลายนิ้วมือได้ โดยเชื่อต่อกับ 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.

Need an accountant who can use Xero accounting program and can help reconcile and tax. Monthly pay between 600-900USD for the right person. ใช้ xero program ได้เปนอย่างดี กระทบยอดบัญชีได้ทุกหมวด ปิดงบการเงิน ต้นทุน

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

[NO AUTO GENERATED APPLICATIONS… WILL BE DELETED] I need someone familiar with affiliate marketing programs and sites. Someone that can find me some good affiliate products for me to ask. Tell me some good affiliate products into Instagram. You will search programs like Clickbank, Amazon, etc. In your application tell me about some products that you have found for clients. Have you ever sold affiliate products through Instagram?

the workbook consists of the below sections: - Section 1 - Vocational Education & Training - Section 2 - Core & Employability Skills - Section 3 - Learning Design - Section 4 - Learning Delivery - Section 5 - Assessment - Section 6 - Administration - Section 7 - Work Health & Safety each section contains between 15 to 26 questions, i will provide martial to help with finding the answers. the workbook is a training and assessment work book

I'm searching for an experienced Wikipedia editor to transform a draft into a full-fledged live profile of our school on Wikipedia. Please be aware that the profile should not get deleted post-creation. Key details to be included in the profile: - The history of the school - Academic programs currently offered The successful freelancer must have a proven track record of creating and maintaining successful Wikipedia pages - please submit past work as evidence of your expertise. The style required for this project demands a balance between informal and professional - I want the school's personality to shine through without compromising the authority and respect required of a learning institution. Ideal Skills: - Wikipedia Formatting and...

I'm in need of a skilled content creator to help me generate engaging and informative articles. The articles I need will typically be between 500-1000 words each. These pieces should be concise and well-written, catering to a general audience. I'm looking for someone who can maintain a high standard of writing, ensuring the content is not only informative, but also engaging and easy to read. Previous experience in article writing or content creation is a significant advantage. It would be great if the writer has a background in SEO as the articles will be used to boost my website's visibility. Please provide samples of your previous work, especially if you have experience in article writing or SEO optimization. Your bid should also include t...

I'm in search of an experienced video editor to work on a cinematic style music video. The video is less than 3 minutes in duration and requires a range of editing tasks. The key tasks include: - Color grading: Enhancing and adjusting the colors in the video to create a coherent look and feel, as well as to enhance the visual appeal. - Visual effects: Adding or enhancing visual effects to make the video more engaging for the audience. - Transitions: Creating smooth and effective transitions between different scenes in the video. An ideal candidate for this project would have: - Proven experience in editing music videos, especially performance style videos. - Proficiency in color grading, visual effects, and transitions. - Attention to detail and a keen eye for ...

I am in need of a professional writer to create a series of 11-15 articles focusing on election analysis and policy debates. Each article should be between 800-1200 words. Key Requirements: - Experience in writing political articles. - A deep understanding of election analysis and policy debates. - Ability to craft engaging and informative content. Ideal Candidate: - A political science or journalism background would be beneficial. - Proven experience in similar writing projects. - Strong research skills to analyze political events and policies. Please provide samples of your previous work in the proposal.

...registration and login system - Detailed search functionality for finding specific dormatories - Comparisons between dormitories, based on user-specific parameters like price, location, user reviews and extras like Wi-Fi availability, breakfast and other services - Information display in a grid view format - Dormitory Profiles: Information provided in these profiles should cover Location, Pricing, Availability, Facilities, Reviews, and Ratings. - Search Mechanism: Users should be able to search for dormitories by Location, Price Range, and Amenities. Ideal skills for this job include: The ideal candidate should have relevant experience with frontend and backend development, a solid understanding of React.js, Java, PostgreSQL and an eye for UI/UX designing. - Proficiency i...

...website on clients local machine is generating errors thus preventing development. SOLUTION: Create a replica of RDS production server (to be called "dev") on AWS, that can be used for development on local environment and for staging testing later on. CONTRACTORS ANTICIPATED TASKS (high level) 1. Take backup of production database on AWS 2. Create new RDS instance (server) using the backup and restore the backup. 3. Configure and verify the network settings to make connections over internet. 4. Test connection of new dev database with web application on local environment. DELIVERABLES 1. Demo showing the website on local environment working with new "dev" database. 2. Document of how to integrate database with web applica...

Note: Budget Fix 2000INR and time line 5 Day's I have a project currently in Codeigniter 3, and I'd like it converted to Laravel 10. This process will require thorough understanding of both frameworks, and it's crucial that all existing features and functionalities are precisely replicated in the new version. While I don't have specific features to prioritize, I will identify specific elements as the project progresses. Skills and experience required: - Profound knowledge in Codeigniter 3 and Laravel 10 - Expertise in PHP development and SQL databases - Proven experience in similar conversion projects Note: The finalized budget for this project is 2000INR. Please only bid if you can work within this budget. The timeline for project completion can be di...

I'm in need of an expert in VB.Net webforms to create an HR job portal for me. The portal should incorporate the following features: - I also want learn this - A job search and filtering module, allowing job seekers to find suitable positions. - An option for resume submission, where job seekers can upload their CVs for potential employers to view. - A company profile section to provide a brief about various potential employers. Within the platform, we'll have two distinct roles: job seekers and an admin role. The admin should have extended access and capabilities to manage all activities on the portal. The layout and design should resonate with a professional and corporate feel reflecting our business nature. We favor a design that is neat, clean, and in...

I'm currently seeking a talented Dutch voiceover artist for a series of radio narratives. Here's what I'm looking for: - Both male and female voices: The voiceover should be able to switch between both seamlessly. Both should have a natural, neutral Dutch accent, with clear enunciation and good pacing. - Narrative purpose: The voiceover will be engaging in a storytelling style, so it is crucial that the artist is able to convey emotions and maintain listener interest. - Middle-aged representation: The voice should sound like it belongs to an individual between 26 and 59 years of age. It should resonate with this demographic, being both relatable and authoritative. Ideal candidates for this project should have a background in radio voiceover, p...

I'm in need of someone who can help me with lead generation. I'm looking to target specific industries in the process and would like to focus on the following segments: - Manufacturing & Machine Industry - Energy Providers - Insurances - Webshops ALL COMPANIES MUST BE BASED IN THE COUNTRY OF SWITZERLAND. COMPANIES SHOULD BE OF SMALLER TO MEDIUM SIZE, IDEALLY BETWEEN 10-99 EMPLOYEES. The leads I'm interested in should be responsible for digital transformation, digitisation, or be a product manager/owner. In small companies, this might be the company owner/CEO. In a bit larger companies (e.g.> 50 employees), this could be a separate position, which could either have the title of "Digital...something" or the "Product o...

I'm in need of a skilled web developer to create an e-commerce website for my business. The site will be used for selling a moderate range of products, between 50 and 200. Key project requirements: - Website Purpose: The primary goal of the website is to facilitate online sales, so the developer should have a good understanding of e-commerce fundamentals. - Payment Gateway: Integration of a secure payment gateway is crucial for processing transactions. - User Reviews and Ratings: Implementing a feature that allows users to review and rate products is a key requirement. Ideally, this should be user-friendly and intuitive. The ideal candidate will have: - Proficiency in e-commerce web development. - Experience with integrating payment gatewa...

I'm in need of a digital artist to copy an existing simple design, with minor changes to text only. We have a tote bag that is old and tired now but I would like to remake it. I have included a scan of the current bag, three close up photos and one photo of the overall bag. I would just like a black and white recopy of the original artwork with clean lines which I will print between A4/A3. The final box (lower right side) is currently an advert for the original coffee house (something like "Haasbrock..." but it's faded.. I would like it to say "a yawn is a silent scream for coffee" in the same font as the other boxes but I don't know if it is too long. Fyi - the bag was a from a shop in South Africa which has now...

Server Admin for and Node.js

I have a medium-sized data entry project which requires entering between 100 to 1000 entries. The data to be entered is primarily textual in nature. This project involves: - Entering textual data into a specific format Ideal Freelancer: - Attention to detail - Proficiency in data entry - Fast and Reliable - Experience with medium-sized data entry projects

...and web traffic of the website. Website URL: Key requirements: - The focus of this project is on increasing website traffic and ultimately improving its revenue. - Experience with guest posting and utilizing news aggregators such as Alltop and others is highly beneficial. - An understanding of SEO, both in the context of guest posting and news aggregators, would be an added advantage. - A proven track record of driving revenue through web traffic is a major plus. - Weekly and monthly work report is mandatory. It's important that the freelancer applying for this project has a strategic approach towards driving traffic and understands the connection between increased traffic and revenue. They should also be able to demonstrate a clear un...

I'm in need of a freelancer who can help me find new clients for my web development services. Key Tasks: - Generate leads and bring in new clients - Identify and engage with potential customers interested in web development - Maintain and grow our client network Ideal Skills: - Proven track record in client acquisition - Strong understanding of the web development industry - Good communication and relationship-building skills Experience in sales, marketing or a related field is a plus. The ability to leverage existing networks and create new ones will be highly regarded. Please apply if you're confident in your ability to attract clients and help grow my business.

I'm in need of a skilled animator who can create engaging 2D, 3D animations, and motion graphics. The animations are aimed at entertaining a target audience and should be between 1-3 minutes long. Key Expectations: - Develop high-quality 2D animations - Create attention-grabbing 3D animations - Produce captivating motion graphics Ideally, the candidate should have: - Proven experience in 2D and 3D animation - A strong portfolio showcasing previous work in entertainment animations - Proficiency in relevant software (e.g., Adobe After Effects, Blender) - Ability to deliver within the stipulated duration Looking forward to seeing your portfolio and discussing how we can move forward with this project.

...research for a retail audit. The ideal candidate should have good communication skills. You will have to own and android mobile device to be eligible for this project. You must be available immediately. For this project, you will have to go to 15 stores and assess products for defects. The number of stores will decrease to 10, if the products' availability is more than 90% after the first 10 stores. The payment for this project is €220. In each store you will have to assess the product, take photos of the defects, and assess the production code. You do not have to purchase any products. Specific requirements for the project include: - Conducting a retail audits in Hue, Vietnam - Collecting data on an app - Must have an android device Skills and experi...

...which measures between 3,000 square feet. It's a split-system design. Ideal skills and experience: - HVAC certification and hands-on experience, especially with split HVAC systems - Previous work in casual dining restaurants or similar settings - Knowledge of best practices and current equipment for restaurant HVAC systems - Easy and clear communication, professionalism, punctuality and attention to detail. The chosen professional will be responsible for providing all necessary equipment and tools for the project. Please include in your proposal details of your professional experience, your availability, and a brief description of your approach to this type of work. If possible, I would appreciate references or examples of prior work with...

...professional, with a full and polished appearance. I expect the following from the freelancer: - Conversion of research paper content into slides: The freelancer should be able to transform the key points, data, and findings from the research paper into a visual presentation that is engaging and easy to understand. - Inclusion of Relevant Visuals: The freelancer should have an eye for choosing relevant pictures that will complement the presentation and enhance the audience's understanding of the content. - Professional Transitions: The presentation must feature professional transitions between slides, ensuring the flow and coherence of the content. - Very Professional Design: The design of the presentation should be very professional, with...

...bottles. The idea came about, but I'm uncertain if it's feasible. I have conducted some market research, but I'll benefit from a professional's eye. I am targeting pet owners with an active lifestyle who would find these bottles useful for their companions. I am looking for someone with: - Prior experience in marketing dropship products - Knowledge about the pet supplies market - Excellent market analysis capabilities - Innovative marketing strategies to target pet owners and individuals leading active lifestyles Your main responsibilities would include: - Evaluating the feasibility of my product idea - Robust market analysis - Creating and implementing marketing strategies Your expertise will help me make an informed decision about proceeding with...

I need a creative mind to draft a fun, engaging, and informative voicemail greeting. The target audience will primarily be my clients and customers. Requirements: - Ability to write in a fun, engaging tone whilst maintaining professionalism. - Skills in copywriting and familiarity with creating voicemail greetings preferred. - Should understand the balance between entertainment and informative. - Must deliver a detailed and comprehensive message, ensuring all necessary information is included. The perfect freelancer for this project will be one with experience in a similar task and demonstrates exceptional creativity. Your writing style should resonate with both existing and potential clients. Show me how you can transform a simple task into an exciting experience.

...charts with multiple timeframes Integration of specific indicators provided through the web socket Option to switch between different currency pairs Customizable interface: users can select which indicators to display Push notifications for significant market events Sample Menu: Home News Market Accounts The app should be both functional and visually appealing, with an intuitive user interface that accommodates traders of all levels. The design should prioritize ease of navigation and effective use of the app's features. You will receive a specific set of indicators to include, but I welcome suggestions for improving functionality and user experience. Experience with Forex apps or financial tools is highly desirable. Please provide exampl...

I'm seeking detailed market research and feasibility analy...and areas where I can gain a competitive edge. - Distribution Channels: Review the current distribution channels to understand how basmati rice reaches its final consumer. Specifically, explore primary relationships between producers, wholesalers, retailers, and consumers. - Market Selling Price: Analysis of the current selling price for basmati rice, understanding the different price points between wholesale and retail, as well as variances between online and in-store. The ideal candidate for this job would have a background in market research, demonstrated understanding of the Canadian grocery market, and an excellent ability to collate and interpret data. Previous experience with feas...

I'm in need of a seasoned IT professional who can set up a Windows-based VPN server for my company. The primary purpose of this server is to allow our employees to access the company's resources securely from remote locations, which is currently a pressing need for us. Key Requirements: - Configuration of a VPN server on Windows OS - Setting up a secure connection for remote employees - Allowing simultaneous connection for a small user base (1-10 users) Ideal Skills and Experience: - Proficiency in Windows OS - Hands-on experience with VPN server configuration - Knowledge of network security best practices - Prior experience with remote access solutions Your expertise will play a crucial role in enhancing the security an...

I require a skilled translator to convert a Settlement Agreements from English to Arabic. The written agreements are between 10-20 pages long. Ideal Skills: - Mastery of English and Arabic languages, both written and spoken - Prior experience in translating legal documents Experience Required: - Understanding of legal terminology is essential, as the document includes specialized legal jargon. A precise and accurate translation is of utmost importance for this task. I look forward to working with a professional translator who can fulfill these requirements.

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

I am in need of a technophile with expertise in Microsoft Access databases. Your task will involve: - Populating my database with customer data which includes names, addresses, phone numbers, organisation affiliations, and details of last interactions. - Inputting sales transactions data which include dates, product names, and prices. The ideal freelancer should demonstrate an adept understanding of database management, particularly Microsoft Access, and be able to accurately input data with keen attention to details. Efficiency, accuracy and attention to detail will be paramount for this project.

...high-complexity T-SQL stored procedure used for data analysis that I need translated into PySpark code. The procedure involves advanced SQL operations, temporary tables, and dynamic SQL. It currently handles over 10GB of data. - Skills Required: - Strong understanding and experience in PySpark and T-SQL languages - Proficiency in transforming high complexity SQL scripts to PySpark - Experience with large volume data processing - Job Scope: - Understand the functionality of the existing T-SQL stored procedure - Rewrite the procedure to return the same results using PySpark - Test the new script with the provided data set The successful freelancer will assure that the new PySpark script can handle a large volume of...