Sql statements calculate age date service työt

Usealla isolla yrityksellä on käytössään Suomessa eräänlainen heidän alansa ERP-paketti, joka on koodattu Visual Basicillä. Tarvitsisimme VB-osaajaa ylläpitämään ohjelmistossa mahdollisesti tehtäviä muutostöitä. Tekniikka lyhyesti: • Visual Basic -koodia noin 280-290 000 riviä • Integraatio taloushallintoon ja palkan maksuun • raporttipuolella n. 50 000 riviä • Crystal Reports • Microsoftin SQL Server -kanta Työmäärät vaihtelee, mutta keskimäärin 1-2 päivää/viikko. Välillä hiljaista.

Meillä on kaksi yritystä järjestelmässä, joilla on omat varastokirjanpidot ja osto-&myyntitilauksensa. Lokaalina serverinä toimii Windows 7 ympäristössä, visma Nova pro 9 (Windows sql server). Mikäli työn suoritus vaatii jonkin tietyn ympäristön niin kysele. Haluaisimme ajoitettuina tehtävinä ajaa allamainitut skriptit jotka muodostavat CSV tiedostot jotka on tarkoitus lähettää sähköpostina eteenpäin. Skriptin asetusten muokkaus skriptin alussa. Muuttujat ja funktiot kommentoituna. Lisätyönä voi tarjota näiden tiedostojen automaattista lähettämistä (Tiedosto liitteenä + leipätekstissä luettavasti muotoltuna). --------------...

JIRA + JIRA SERVICE DESK teknistä konfigurointi ja opastusapua etsitään pieneen projektiin.

I need someone to create a Woocommerce payment gateway to service checkout.fi. From them I can get technical material. Also I need delivery gateways for Finnish Posti and Matkahuolto. For these two I will also provide info about technical details and interface wht I can get from them. I would be great I these plugins/gateways could have Licensing system that I would be able to sell the plugin for my clients but they won´t be able to give it forward. Suggestion are welcome how to do this. The one that I shall pick is going to get more jobs for Woocommerce in future similar like this.

Webservicen luominen sql tietokannalle. Perus toiminnot webservicelle ja kehitys ympäristön pystytys. Tarkempi speksi on saatavilla NDA:n kirjoituksen jälkeen. Kehitys mielellään Eclipse ympäristössä.

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.

Excel Add-In joka hakee ja tallentaa taulukkomuodossa olevaa dataa Azure SQL-kannasta/-taan. Lisäksi ohjelmallista Excel muokkausta ja hallintaa C#-koodilla. Osaan Excel muokkauksista valmis VBA-script, joka muutettava C#-kielelle. Visual Studio 2015 alkukoodi, SQL Azure tietokanta ja kyselyt valmiina.

Java, J2EE, JDBC, SQL, java Threading,GWT,Html,CSS

MEETHI ESCORT SERVICE 3000-say SHORT 6000say-NIGHT 24X7 HRS NCR DELHI,,9811-040-651 MEETHI ESCORT SERVICE 3000-say SHORT 6000say-NIGHT 24X7 HRS NCR DELHI,,9811-040-651MEETHI ESCORT SERVICE 3000-say SHORT 6000say-NIGHT 24X7 HRS NCR DELHI,,9811-040-651MEETHI ESCORT SERVICE 3000-say SHORT 6000say-NIGHT 24X7 HRS NCR DELHI,,9811-040-651MEETHI ESCORT SERVICE 3000-say SHORT 6000say-NIGHT 24X7 HRS NCR DELHI,,9811-040-651MEETHI ESCORT SERVICE 3000-say SHORT 6000say-NIGHT 24X7 HRS NCR DELHI,,9811-040-651MEETHI ESCORT SERVICE 3000-say SHORT 6000say-NIGHT 24X7 HRS NCR DELHI,,9811-040-651MEETHI ESCORT SERVICE 3000-say SHORT 6000say-NIGHT 24X7 HRS NCR DELHI,,9811-040-651MEETHI ESCORT SERVICE 3000-say SHORT 6000say-NIGHT 24X7 HRS NCR DELHI...

Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)

Moi! Osaatko kuinka hyvin sql:n perusasiat? Onnistuuko asentaa tietokannan hallintajärjestelmä, luoda ja hallinnoida tietokantoja sekä käyttäjätilejä ŠŠ ,seurata ja optimoida tietokannan toimintaa. Jos perusasiat hoidossa niin ota yhteyttä :)

Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)

As a business user, I need assistance with the configuration of SSRS Reporting Service on a staging environment. I have configured the WebPortal using Report Server Configuration manager and I am able to run SSRS reports from the Web UI. The project requires the following: 1. Automatically Scheduling of SSRS reports with default parameters. 2. Exporting the outcome of SSRS reports in a given folder every time a scheduled report runs I am experiencing the following issue while scheduling: Error: The SQL Agent service is not running. This operation requires the SQL Agent Service. You will need to help get rid of this error and set up scheduling and exporting of reports as mentioned. You will be required to get on a video call and help me set up the a...

...and most diversified economies, renowned for its museums and music, and voted best large city in the U.S. for four years in a row by Condé Nast Traveler. Mission The mission of North Park University is to prepare students for lives of significance and service through education in the liberal arts, professional studies, and theology. Vision Building on our core institutional identity—Christian, city-centered, intercultural—our vision is to create a university of uncommon character and enduring excellence, where faith, learning, and service meet....

Someone to deliver me a phone to my physically meeting face to face

I'm looking for a professional who can help me create a 2-minute long AI video. The primary purpose of this video is to promote my service. The video will use a very sweet and engaging voice to narrate a story. Key Requirements: - Create a 2-minute AI video to promote a service - Use a very sweet and engaging voice for the narration - Develop a narrative story to explain a workflow or procedure The specific workflow or procedure that I'd like to be explained in the video will be provided. The ideal candidate should have experience in creating engaging AI videos that are both informative and entertaining. A background in marketing or promotional video production would be a plus. A strong portfolio of past work in this field is highly desired.

Capture attention and convey your message effectively with our "Flyer Design/Leaflet Design/Pamphlet Design" service. Our expert designers craft visually appealing and impactful materials to help your promotions stand out.

...patient who has a temperature over 40, regardless of age, should be receiving Dexamethasone  the toString method in the Covid19Patient class to return a String similar to the sample below: Id: 23 Full name: Shukri Abotteen Age: 80 Temperature: 38 PCR test result: Positive Treatment: Paxlovid  RegularPatient Use the uml diagram above to create the class  The treat method will return Amoxicillin for patients with upper respiratory tract infections (symptoms include coughing, runny nose, or stuffy nose). Patients who have hypertension will be taking ACE inhibitors. All other patients will be on IV fluids.  the toString method in the RegularPatient class will return a String similar to the sample below: Id: 23 Full name: Shukri Abotteen Age: 70 Main Symptom: Vomiti...

I'm in need of a Cloud-based HPC system for a statistical analysis project. Key Requirements: If you have access to a HPC i need that service for a python code. lets talk about price

...of CRM and the lead us to the CRM number CRMxxx We have many Tasks by numbers: T1 …….. To T35 For each task we can set up date, hour and the way to be done, in main page and by email we will receive alert for task that need to be done with number of task, number of CRM (client number) and the way that need to be done (W, Emai, SMS, Tel, Phone call, …). When we set up the task we can see it as the task is SET UP Some of the task must be done by email by SMS by WhatsApp by telegram by Viber and the phone call, when we do it for example by email with tick it, and it's recorded with a date and hour, when we receive receipt of email, we tick it and it's recorded with the date and hour that we receive receipt of email, the same way by What...

I'm in need of a customer service representative for a part-time role, guaranteed weekly earnings of $800. No previous work experiences are required. Key Responsibilities: - Respond to customer's online inquiries - Carry extensive product knowledge Ideal Candidate: - Has excellent live chat etiquette - Can provide assistance to customer's product selection All communication and handling of customer inquiries will be primarily via live chat support.

I'm urgently in need of a qualified developer to create a pipeline utilizing DBT and SQLLITE. T...appropriate error logging and handling mechanisms Ideal Skills and Experience: - Strong proficiency in DBT and SQLLITE - Experience with data pipelines, specifically involving text file processing - Familiarity with data transformation techniques - Quality assurance and bug fixing capabilities Deliverables: ● A DBT project containing models for company_analytics and skills_analytics tables. ● SQL scripts or DBT models to process JSON files and populate the analytics tables. ● Instructions for running the DBT command to process the data and execute data quality checks. ● Documentation on adapting the pipeline for continuous file deliveries and suggested additional data quality me...

...a picture book targeting children aged 4-8 years. The children portrayed in the book are twins and want to have some ethnicity Key Details: - Illustration Style: The illustrations are for children and should be age appropriate, with vibrant colors and lively characters to captivate young readers. - Number of Illustrations: The picture book will feature around 20 illustrations in total. Preferred Skills: - Proven experience with children's book illustrations, particularly in a cartoonish style. - Ability to create captivating and expressive characters that appeal to the target age group. - Strong understanding of color theory and composition to ensure the illustrations are engaging and visually appealing. - Excellent communication skills and a collaborative approach...

Real Estate Video Editing Service

I'm looking for a skilled social media manager with a special focus on Youtube & Google Ads. The primary goal of this ...strategies. - Create and curate engaging, interactive content for Youtube. - Monitor and respond promptly to user comments and feedback. - Analyze and report on social media performance metrics. Desired Skills: - Proven experience in social media management, especially Youtube . - Solid understanding of Google Ads and its role in boosting subscriptions and views. - Excellent communication and customer service skills. - Strong analytical abilities to interpret social media metrics and adjust strategies accordingly. At the same time, I want him to find a way to manage all my posts through TIKTOK + INSTA + FB + YOUTUBE. Find ideas, develop the concept and...

I am looking for an experienced developer or team who can create a social networking app for both iOS and Android platforms. This app is specifically targeted towards idol chasers - fans who enjoy interacting an... - Direct Messaging: Instant communication between users will keep the community alive, whether users want to plan events or simply chat. You should be proficient in developing secure messaging systems. - Blog: Allowing fans to blog about their idols can help to spark active discussions and attract new users. Ideal candidates should have proven experience in creating similar apps, and be up-to-date with the features that create an engaging and safe space in social media. A sense of enthusiasm and understanding for the community of 'fan or idol chasers' is desire...

I'm looking for a skilled Python developer to create an Ant Colony Optimization (ACO) algorithm that can read numbers in a matrix to calculate the shortest distance and its respective cost. Key Features: - The algorithm should respect origin and destination points, which will be indicated by specific row and column numbers. - Ideally, the code should be able to parse a .xlsx file format. Desired Skills: - Proficiency in Python programming language - Experience with optimization algorithms, particularly the Ant Colony Optimization algorithm. - Familiarity with .xlsx file parsing. I already have a basic code and can provide it to you as reference material; however, I need someone to improve and expand on this code to meet the requirements. It is essential for the proposed so...

Hi, I am in need of a skilled professional who is proficient in developing a Customer Service CRM with a key focus on the functionality of issue tracking and resolution. As the priority of the project, I require the CRM to systematically record and track customer issues, from initial identification through to final resolution. The ideal candidate for this project will have: - Strong experience in creating web-based CRM platforms - Expertise in developing customer service focused CRM systems - Proven track record in integrating issue tracking and resolution functionality - Proficiency in customer database management and optimization The deliverable is a Web-based CRM application that is easy to navigate and meets all the desired functionality aspects. It would be added adva...

I need a power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: -Retrieve product ID, Quantity and Location -Gather specific production data includin...production number. Ideal skills: -Proficient in DAX query language -Comprehensive experience with Power Bi -Excellent attention to detail -Previous experience in inventory data management will be a plus. What to do: I need to get a query in DAX (Power Bi) that gives me the same result as what I show in the excel file ( table ( column in yellow)). The excel file was obtained from the attached SQL query () The two screenshots show the power bi tables. I need to get a new column in power bi that shows me the results like in the yellow column in Excel.

I am in need of a results-driven digital marketer for my food service website. Its main objective is to generate leads for catering services. While the target audience has not been explicitly defined, an experienced individual will know which audience to target to yield the best results. The primary task would be to creatively place ads in free ad websites. If you can show me that you are effectively driving business, there's potential for increased budget allocation and ongoing work. While there is no strict timeline, it would be ideal to start seeing some progress as soon as possible. Key Skills/Experience Needed: - Proven experience in digital marketing, particularly lead generation - Excellent communication and creativity - Understanding of the catering services indust...

I need a social media expert with profound knowledge in stock market who could distribute information daily on Reddit, Facebook, and Twitter. Key tasks: - Distribute stock news, analysis, and recommendations on a daily basis on aforementioned platforms - Must be up-to-date with what’s happening in stock market and accordingly distribute relevant information - Promptly answer any comments or queries to maintain engagement Ideal freelancer: - Experience with social media management - Basic understanding of stock market terms - Excellent communication skills - Proactive, punctual, and reliable

...in communicating complex business ideas in a concise manner. Key Requirements: - The deck should include a high-level market analysis. While I don't need an extensive deep dive into the market, it must still provide an overview that conveys the potential and viability of my business to potential investors. - I would like the deck to cover several key sections: - Company Overview - Product/Service Description - Business Model - Competitors - Strategic partners - Achievements - Next steps - Objectives/needs - Investment requirements - Team Ideal Skills and Experience: - Proven track record in creating successful investor pitch decks, ideally in the tech or startup sector. - Strong understanding of market analysis and the ability to present data in a clea...

I am looking for a skilled developer to create a Windows-based application that can interact with a remote database. The application should primarily focus on retrieving and generating website sitemaps based on different criteria. The ideal candidate should have: - Proficiency in Windows application development - Strong experience in working with databases, particula...in working with databases, particularly remote databases - Knowledge in data retrieval and data update functionalities - Ability to understand and incorporate additional requirements as the project progresses Please note that the selected freelancer may need to provide examples of past work and project proposals. Note: Application should be able to connect different type of databases such as MS SQL Server, MySQL, O...

As a business utilizing Salesforce, I am seeking admins and developers with deep understanding of the platform to craft insightful blogs focusing on: - Salesforce Administration - Salesforce Development This is not general content writing project instead need content creators who have base understanding of platform. The key requirement...desire to improve their Salesforce skills. Prior experience in blogging about Salesforce or similar CRM systems would be highly beneficial. Please include samples of prior work in your proposal if available. When responding, please give your estimate on per blog charge. As we are starting fresh, we are looking for blogs on all areas of Salesforce ecosystem targeting admins and developers on Sales, Service and Experience Cloud to begin with.

I am in need of a math teacher who specializes in teaching children. The ideal candidate would have a strong background in mathematics and teaching methodologies specific to this age group. Key Requirements: - Experience in teaching mathematics, particularly to children aged 5-12 years. - Deep understanding of elementary math concepts. - Ability to create engaging lesson plans and teaching materials. - Patient and enthusiastic demeanor, suitable for working with young learners. This is a great opportunity for someone who loves teaching math and has a passion for cultivating young minds. Please include relevant experience and any teaching techniques you specialize in when applying.

I'm in need of an SEO expert who can assist me in building a high-sales generating website for my carpet cleaning business. Please note that I'm looking for a business partner rather than just a service provider, with the expectation that we will share the profits. Watch this before you send me a quote. Key Goals: - Increase Website Traffic: The site should attract and engage a significant number of visitors. - Improve Website Conversion Rate: Conversion optimization is crucial - we need visitors to turn into paying customers. - Rank High on Search Engine Results: The site should be SEO-optimized to reach a top position in search engine rankings. Key Information for Applicants: - Please share your past

Description: The objective of this project is to develop a PHP application that enables sending messages to customers via the WhatsApp platform using the official WhatsApp Business API. This application will be useful for effective communication with customers, sending notifications, order confirmations, appointment reminders, among other relevant messages for the business. Ke...application. User manual to guide administrators in using the application. Considerations: It is important to consider WhatsApp Business API policies, especially regarding the type of messages allowed, use of templates, message frequency, among other aspects. Mechanisms should be implemented to manage and monitor API usage, such as message sending limits per time period to prevent abuse and ensure service c...

...and no app should be required. Site should display correctly on all mobile devices. • Use PH7 Builder, free opensource dating-site software. I will not be using all available features, but you can see the capabilities and features here: • Implement my custom Algorithm to calculate matches based on selected filters • Require Chat messaging • Modify software to allow user to record audio and send as message or leave as bio • Profile pic can only come from user camera, not gallery or pasting • Require Match alert notifications • User should be able to exclude matches based on any particular filter/option • PH7 BUILDER Software can create hundereds of fake profiles for testing

MATLAB USERS Vi...USERS Visual Processing and Object Detection: The first task will be to detect and segment objects in images using traditional computer vision methods. It will be necessary to automatically separate the balls from the background and evaluate the accuracy of the segmentation. Feature Calculation: The second task will be to extract texture and shape features. By using appropriate algorithms to calculate the shape attributes of the balls, it will then obtain textural attributes with gray level collaborative matrices. Object Tracking: The third and final task will be to track the movement of a ball by applying a Kalman filter. Working with real and noisy coordinates, it will create a tracking algorithm and compare the tracked path with the real one. summarize this in...

I'm seeking a versatile call agent capable of juggling several tasks. Your daily responsibilities will span from answering inquiries to making outbound calls and taking sales orders. You’ll be primarily dealing with both business and individual customers - hence, excellent communicatio...responsibilities will span from answering inquiries to making outbound calls and taking sales orders. You’ll be primarily dealing with both business and individual customers - hence, excellent communication skills are a must. All-rounders who can handle product details, order status, and customer complaints proficiently will be an ideal fit. This job requires a keen eye for detail, sales and customer service expertise; multitasking proficiency is a must. Previous call center experie...

...to add new content, such as articles, images, and possibly videos. Required Skills: - Web design expertise, particularly in creating user-friendly and visually appealing information sharing websites. - Familiarity with design and implementation of content management systems (CMS). - Ability to understand the needs of a general audience and design accordingly. a. Website Pages 25 to 30 > Home, Service(5no), Works(10no), about > Contact, Career, Refer, Quote, FAQ, Process, Customer Support > Terms, Policy, Offers & Coupon (Admin Panel), Pricing > Blog setup, Configure-Google Mgr., Social Media Pixel & other, Chat, Google Analytics b. English Website c. Email & SMS reg validation code d. Responsive website with 25 to 30 pages max Need experienced developer...

I'm experiencing some problems with my current Shopify 3.0 setup. The functionality of the custom app in question centers around the deprecated API feature. In particular, the issues have been cropping up around the 'Analytics' API endpoint which has been deprecated. I am in need of a developer skilled in Shopify app development who understands the importance of staying up-to-date with API changes, and can resolve this issue swiftly. Ideal Skills and Experience: - Proficiency in Shopify API - Familiarity with Shopify 3.0 - Strong understanding of deprecated API challenges - Experience in custom app development - Knowledge in 'Analytics' API endpoint

I'm looking for a model (male or female) for a 1-2min product demonstration video (Air purifier). Age- 32+ Fluent in English location- Delhi NCR Doesn't need to be a professional model just need someone who can deliver script fluently. Do not bid for any other services if you are not a model.

I'm seeking a versatile call agent capable of juggling several tasks. Your daily responsibilities will span from answering inquiries to making outbound calls and taking sales orders. You’ll be primarily dealing with both business and individual customers - hence, excellent communicatio...responsibilities will span from answering inquiries to making outbound calls and taking sales orders. You’ll be primarily dealing with both business and individual customers - hence, excellent communication skills are a must. All-rounders who can handle product details, order status, and customer complaints proficiently will be an ideal fit. This job requires a keen eye for detail, sales and customer service expertise; multitasking proficiency is a must. Previous call center experie...

...letter to a company based in Japan. The chief grievance being poor customer service enlightened during an over-the-phone interaction, where the representative lacked essential knowledge about the product/service. Crucial expertise and skills required: - Professional level letter drafting and editing. - Knowledge and understanding of customer service standards in Japan. - Proficiency in conveying dissatisfaction professionally and constructively in written communication. - Previous experience in handling complaints or customer service related issues. The ultimate goal of this project is to achieve a satisfactory answer or some improvement in the customer service area.l from the company for their substandard service. Communication must r...

...with the sitelogo on it in the middle. - On a desktop view we want the left side of the screen to have a tree trunk run along on the left till the footer And leaves on the right. - Footer content should include: Column 1: Small kalataru logo and under it social media links Column 2: About us Contact us Careers Kalataru Magazine Column 3: FAQs Returns and exchanges Shipping and Handling Terms of Service Privacy Policy Column 4: Sign up to our email Newsletter (Email ID text box with validation) (Subscribe button) - Integration with payment gateway (phonepe) - Cart and login mechanism should be OTP based and very direct and easy - Collect user data in a proper format (ip, usage, email_id, phonenumber, name, etc) - Integrate with google analytics - The background needs to have flor...

I'm seeking a professional in Python with experience in computer vision, specifically with DVS 346 cameras. The goal of the project is to: - Detect human movements: Standing, walking, sitting, waving, jumping, running - Calculate the speed of detected movements The project will take place in an indoor environment. Ideal candidates should have: - Proficiency in Python - Expertise in computer vision - Experience with DVS 346 cameras would be a plus This is a unique project that requires attention to detail and an understanding of both human movement and computer vision principles. The ideal freelancer will be able to deliver accurate movement detection and speed calculations. I already have the DVS 346 camera for this project.

I'm looking for a professional website designer to create a fully responsive portfolio site for my event company. Ke...professional website designer to create a fully responsive portfolio site for my event company. Key Features: - The design must be specifically tailored for an event company, focusing on showcasing our services and previous events. - The website should include sections for 'About us', 'Services', 'Gallery'. Ideal Skills & Experience: - Proven experience in designing portfolio websites, especially for service-oriented companies. - Proficiency in creating fully responsive websites that are optimized for mobile devices. - Familiarity with best practices for incorporating 'About us', 'Services', 'Galle...

I'm in need of a dedicated and skilled customer service expert with at least 5 years of experience to help me manage my e-commerce store's customer service operations. Key Responsibilities: - Handling order tracking and fulfillment - Managing returns and exchanges - Answering customer inquiries - Responding to live chat - Making phone calls when necessary - Reaching out to customers for reviews - Reviewing and auditing invoices from the optometry lab and fulfillment center - Responding to social media messages and comments - Assisting in signing up new affiliates - Conducting influencer outreach Skills and Experience Required: - At least 5 years of experience in customer service, preferably in an e-commerce setting - Proficiency in using Live chat softwar...