Convrt data date format sql 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). --------------...

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

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 ;)

In need of an experienced freelance photographer with a keen eye for candid photography to capture one of the most precious moments of my life - when I propose to my girlfriend in Florence. Key Details: • Date of occasion: 22/05/2024 or 23/05/24You will need to be available in the afternoon for the shoot. • Setting: The session will take place amidst Florence's . Required Photographer Experience: • Background in candid photography • Local or familiar with the city of Florence and its enchanting streets would be a plus. • Reliability to be present at the right time • Ability to work discreetly to maintain the surprise element Your role will not only be just to document, but to capture the moment through your shots. If you're up for thi...

...expertise to meticulously organize data, create advanced formulas, and design visually captivating presentations, this contest is tailored for you! Join us in revolutionizing property portfolio management with a document that sets the standard for clarity, accuracy, and usability. I would like to be able to edit if required in the future therefore 2 copies will be required. 1 being password and field protected and the other with full access for any required changes. **Requirements:** **Tab 1: Welcome & Data Collection** *Design and User Interface:* - Create an inviting and user-friendly interface that reflects our professional standards, incorporating the company logo colours (blue, white, grey). - Ensure intuitive navigation and seamless data entry for clie...

...and calculate completion percentages. - Data sorting and filtering functionalities are a must. I want to be able to sort my tasks by due date, priority or completion status. - Conditional formatting is also needed. I'd like the cells to change color based on task status (e.g., incomplete, complete, overdue). Platform and Updating: - I prefer the use of Google Sheets for this project. - I plan to update the spreadsheet manually. This means that the sheet should be user-friendly and easy to navigate, with clear headings and sections that I can easily edit and add to. Ideal Skills: - Proficiency in Google Sheets and advanced knowledge of its functionalities. - Experience in creating automated spreadsheets with features like automatic calculations, data sorting/f...

I'm looking for an experienced content writer to create informative blog posts specifically on technology topics. Key Responsibilities: - Crafting engaging and informative blog posts on a variety of technology-related subjects. - Ensuring content is written in an accessible and easy-to-understand manner, catering to a non-technical audience. - Researching and staying up-to-date on the latest trends in technology to produce relevant and timely content. - Adhering to guidelines regarding SEO and content optimization. Ideal Qualifications: - Proven experience in content writing, particularly in the technology niche. - Ability to write in an informative and engaging style, tailored to a general audience. - Strong research skills to delve into various tech topics and distill compl...

I'm in need of an individual with skills in web research, specifically revolving around YouTube. My objective is to verify the owner of a single YouTube account by uncovering the following account owner details: - Name - Email Address - Location - Proof of post timestamps The ideal person for this project will possess a knack for investigative research and have familiar...following account owner details: - Name - Email Address - Location - Proof of post timestamps The ideal person for this project will possess a knack for investigative research and have familiarity with YouTube's platform. Previous relevant experience is an added advantage. Your responsibility will entail confirming the above information and providing evidence where needed, particularly the time and date...

...need to provide the following functionalities: - Data storage and retrieval: The application must be able to store and retrieve data efficiently, ensuring the integrity and security of the data at all times. - Data analysis and reporting: It should have built-in analytics features to generate and visualize reports based on the stored data. Understanding of statistics and data analysis tools is preferred. - User authentication and access control: The application must include a secure log-in mechanism for users, and feature robust access control settings to manage their privileges within the application. As for the type of data this database application will manage, this remains to be finalized. However, skills in handling different typ...

Your tasks will include: - Conducting research to ensure accuracy and up-to-date information - Breaking down complex medical concepts into understandable language for novice medical students - Ensuring the content is engaging and holds the attention of the target audience Ideal candidates should have: - Previous experience in medical writing, especially creating educational materials - A good understanding of medical terminology and the ability to simplify complex information - The capability to conduct research and accurately cite sources - Excellent writing skills with a focus on clarity and engaging storytelling. Please include samples of your previous medical writing work when applying.

...feature into my Crystal Report PDFs within my web application. This will serve the purpose of authenticating the reports. The signed reports should be saved into a SQL Server database. Key Requirements: - Implement a digital signature feature on Crystal Report PDF files. The purpose of this is to ensure the authenticity of the reports. - The digital signing process should be automated after an approval process. - Save the signed reports into a SQL Server database. Ideal Skills and Experience: - Proficiency with ASP.NET Web Forms and C# is a must. - Experience working with Crystal Reports would be a plus. - Familiarity with SQL Server database management. - Understanding of digital signature implementation and security in web applications. I'm looking for a ...

I'm a business partner in a Bulgarian company and need to obtain a Certificate of Fiscal Residence. I'm not an onwer of the company. The freelancer I'm looking for needs to: - Have access to up-to-date information on the process of obtaining a Certificate of Fiscal Residence for a Bulgarian company. - Be able to find out if it's possible for a non-owner to obtain this certificate. - Determine if the process can be completed online and provide an estimate of the time it would take. Ideal qualifications: - Proficiency in Bulgarian and English. - Experience in legal research, particularly in the domain of fiscal or corporate law. - Familiarity with the specifics of Bulgarian corporate law and its procedures. Please note that I will need to be able to trust th...

I need an experienced coder proficient in MATLAB to assist with a mid-level complexity project related to physical modeling. Ideal Skills: - Proficiency in MATLAB - Experience in data management - Ideally experienced in physical science data Specifically looking to have script written to read multiple ASCII data text files and create matlab Structure format for oceanographic instrument data (an ADCP). Such as: There are multiple ascii text files that all have to be read. Some data lines have NaNs that have to have the whole row of data removed.

I'm in need of a skilled individual who can scrape data from various websites for the purpose of lead generation. The data should be delivered in Excel or CSV format. Key Requirements: - Proficient in web scraping - Experience with lead generation - Ability to deliver data in Excel/CSV Ideal Skills: - Proficiency in Python/R for web scraping - Previous experience in similar projects - Strong understanding of lead generation techniques If you have experience in web scraping and lead generation, I'd love to hear from you.

Project Start Date: 3rd June 2024 Project End date : 30th June 2024 Task: ONLY DEVELOPMENT ( UI UX is being developed by a different team ) Portal Details: We are seeking a highly skilled developer to build a new, modular, and API-driven Case Management System (CMS) from scratch. The new system should adhere to modern software architecture principles, particularly the Model-View-Controller (MVC) pattern, to ensure maintainability, scalability, and efficiency. While our previous system was developed using Drupal, we are open to using a new tech stack that aligns with the latest industry standards. Responsibilities: Design: Architect a modular CMS following MVC principles to ensure a clear separation of concerns.

I am searching for an experienced 3D designer to create medium-detail 3D models of various objects for 3D printing. Key Responsibilities: • Develop ...objects with a focus on medium detail • Ensure the designed models are ideal for 3D printing Skills & Experience: • Solid understanding of 3D modeling utilizing various tools • Previous experience in creating 3D models specifically for printing • Proven ability to deliver designs aiming at medium detail level • Strong knowledge of different 3D file formats. Since I am not sure which specific file format I require, your advice on this matter will be highly valuable If you have solid experience in 3D modeling for 3D printing, then this project could be for you. Please share your portfolio with re...

I'm in search of a gaming enthusiast who can meticulously review my Twitch VODs, separating the moments that trigger laughter and fun. The selected moments should ideally be edited down into snappy, engaging shorts of less than a minute each, suitable for uploading on YouTube and TikTok. These moments should provide the viewer with a quick burst of laughter and fun setting the tone for my chann...edited down into snappy, engaging shorts of less than a minute each, suitable for uploading on YouTube and TikTok. These moments should provide the viewer with a quick burst of laughter and fun setting the tone for my channel's content. Ideal Candidate: - Familiar with Twitch gaming VODs - Understands humor in gaming - Experience in video editing - Knowledge of YouTube Shorts and TikTok...

I am in need of a 3D modeler who can create a basic product model for me. This model is ...model for me. This model is intended for 3D printing, so it doesn't require intricate detail and high texture or lighting. Ideal Skills and Experience: - Proficiency in 3D modeling software - Experience in product modeling - Understanding of 3D printing requirements - Ability to create clean, accurate models - Knowledge of file formats, specifically STL The final deliverable should be in STL format to be directly usable for 3D printing purposes. I'm seeking a freelancer who can deliver a quality model efficiently. The dimensions for the blue part are the diameter of the circle is 80mm. Note this is the start of a project, a good quality designer will be used for the remaining 8 p...

Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.

I need a detailed spreadsheet of information taken from public meetings. The content I'm seeking to compile involves: - Date of the meeting - Detailed descriptions of action items that were voted on, including the specific amounts. In this assignment, precision, attention to detail, and understanding of meeting notes is crucial. Mastery of Excel and experience handling similar tasks is required. Familiarity with action items and the voting process in public meetings will be a plus.

...experienced SEO and structured data expert to enhance our search engine visibility and optimize our Google search results. The goal is to ensure our search results are as informative and visually appealing as top competitors in the market. Conduct a comprehensive SEO audit of our website. Optimize meta titles, descriptions, and headers for key pages. Implement keyword-rich content strategies for higher search rankings. Structured Data Implementation: Add JSON-LD schema markup (e.g., Product, FAQ, Review) to improve search result appearance. Ensure structured data aligns with Google’s guidelines for enhanced snippets. Google My Business Optimization: Create and optimize a Google My Business profile. Ensure all business information is accurate and up-to-da...

I need a tool that can scrape text content and tables from LinkedIn quickly and efficiently into an Excel format. The tool needs to be able to: - Extract text content and tables from LinkedIn - Export the scraped information into Excel format - Operate quickly and efficiently to meet a tight deadline The ideal candidate should have: - Experience in web scraping, particularly with LinkedIn - Proficiency in Excel - Ability to develop a tool that can operate quickly and effectively Given the urgency of this project, I need someone who can start ASAP and deliver the tool in a timely manner. Experience with rapid tool development would be a huge plus.

Currently using .Net Framework 4.5 and looking to upgrade project. The main goal for this upgrade is to ensure compatibility with modern systems. I don't require any specific performance improvements, just upgrading the framework is the main focus. The code base is for a Web API that integrates with SQL Server. There is a separate UI front end that is not included. The current version is .Net Framework 4.5 with the following target techical Stack • ASP.NET Core 8.0 (with .NET 8.0) • ASP.NET WebApi Core • ASP.NET Identity Core • Entity Framework Core • FluentValidation • Swagger UI • GIT Key requirements: - Expertise in C# - Strong understanding of .Net architecture - Previous experience in upgrading .Net projects to ensure compatibility with...

...consolidated short lists of campaign imagery Request file building from SEA Content Studio for new images to be created Request photo retouching for all lifestyle photos to be featured Route loose cross-functional imagery for approval Fulfil image requests from various functional teams Communicate with other team members on requests, project information and transferring of assets Keep trackers up to date along with managing asset database Work with usage rights team on 3rd party assets relevant to the SEA markets Work with digital asset managers to transfer launch assets to long-term Digital Asset system Assist Content PM(s) in understanding the nuances of different languages and be able to identify what content requires localisation and to convert it to a brief for the ...

I have a set of old drawings in IMG format that I need converted to PDF format that is acceptable to a building dept for upgrade permits. We want to add a deck in front of the garage which will be the width of the garage appx 19' x 15'. If you have experience in architectural drawing, drafting and design, and proficiency in working with PDF formats, then you're the freelancer I'm looking for. Unfortunately, I do not have specific features or elements that I want to incorporate in my deck plan. It'll be great if you can provide some suggestions on possible seating. I'm only looking for help with the drawing and end result would be something I can submit to city of San Diego building dept for a deck that I'm going to build myself.

I'm looking for a skilled content creator to take my existing exercise videos from my 90k YouTube and 300k Instagram accounts and repurpose them for TikTok. Key Requirements: - Repurposing: You should be able to creatively adapt the content from YouTube and Instagram into engaging, TikTok-friendly videos. This includes understanding the nuances of TikTok's format and audience. - Understanding of Fitness: As the content is exercise-based, a solid understanding of fitness routines is essential. - Platform Familiarity: Prior experience with TikTok and a keen interest in the platform is preferred. The goal is to maximize the reach of the existing content by adapting it to an audience on TikTok, while maintaining its essence and quality. Sample videos can be created from my ...

...sentiment analysis process. This includes an in-depth explanation, supported by examples, to provide clear and comprehensive insights. For the second part of this project, I require a thorough analysis of a review. This analysis should be presented in a combined format of text and visualizations. The analysis must be detailed and insightful, showcasing the different levels of sentiment analysis. Ideal candidates for this project should have: - Strong academic writing skills, particularly in the area of sentiment analysis - Proficiency in data analysis and visualization techniques - Previous experience in writing or analyzing reviews - Ability to combine textual and visual methods effectively Please provide examples of similar research papers or analyses you have conduct...

I'm in search of an experienced CISSP certified instructor with an advanced level of knowledge. The ideal candidate should be able to deliver these classes in an in-person format. Key Training Areas: - Security and Risk Management - Asset Security - Security Architecture and Engineering I need someone who can provide thorough explanations and practical examples of these topics. Your role will be to break down complex concepts into understandable parts for the students. This means ensuring the content is clear, concise, and engaging. Ideal Skills and Experience: - Advanced CISSP certification - Experience in in-person training - Strong communication and presentation skills - Ability to simplify complex ideas - Understanding of adult learning principles Please only apply if ...

Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.

I aim to gather insights from financial advisors on how they manage their personal finances. Understanding their investment philosophies and retirement planning strategies is key. This project focuses on growing wealth, and you'll be tasked with providing these insights in written format.

I have a few guitar tabs that I'd like converted into the Rocksmith format. - The tabs can be a mix of genres. - I need these tabs to be converted to Rocksmith format, so that they can be easily playable within the Rocksmith software. - The guitar tabs may not be in standard tuning, so a knowledge of different tunings and how to adapt them for Rocksmith is preferred. Ideal skills and experience for this project include: - Proficiency in guitar. - Experience with Rocksmith and how to convert tabs to its format. - Knowledge of different guitar tunings and how they can be adapted for Rocksmith.

I'm looking for a professional and corporate style. I need someone to format my plan document. I'm looking to transform a standard word document into a visually appealing, professional and corporate format. Ideal Skills and Experience: - Proficiency in Microsoft Word - Experience in document formatting - Understanding of professional and corporate design aesthetics - Attention to detail and ability to follow specific guidelines

Looking for an expert in data visualization who can show off their skills by creating some stunning and insightful graphs based on my company's stock data. Here's what I need: - Create a scatter plot of the highest stock price (in the column labeled "High") against time. Write several sentences explaining the process/steps. -Create a scatter plot of the lowest stock price (in the column labeled "Low") against time. Write several sentences explaining the process/steps. -Create a histogram of the adjusted daily closing stock price (in the column labeled "Adj Close"). Make sure the histogram is meaningful by adjusting the bin size so you can see the shape of the histogram. Write several sentences explaining the process/steps by which you ...

We need an experienced 3d game artist to work alongside us. You will be working alongside 1 very experienced unity game developer who owns and is leading the project. I...artist to work alongside us. You will be working alongside 1 very experienced unity game developer who owns and is leading the project. If you want to apply please: 1) Send us a 1 minute video of you introducing yourself in english 2) Send us a link to your game art portfolio 3) If you do not follow these steps you will not be considered for this job Hours: anywhere from 10-40 hours a week. Start date probably 1 week to 1 month from now. We will task you with numerous tasks for a week and you will need to scale your hours to complete those tasks based on the week. We will continue conversation here before moving ...

I'm seeking an exam invigilator with at least a Bachelor's degree to administer an on-site exam in Salmiya, Kuwait. This is a one-time gig with the potential for future opportunities. We provide test administration and accommodation solutions to test-takers nationwide. For...computer exam coming up where a test taker has been approved for communication assistance. The candidate is deaf or hard of hearing but is able to read lips. For this assignment, you would be required to be on site and repeat communication from staff and content from the exam in a way that the candidate may read your lips. The exam is taking place at a professional testing center in Salmiya, Kuwait. Date: Thursday, 30 May, 2024 Time: 9:30 AM to 1:00 PM We provide full training, and this assignment...

...answer this questions: 1. how many years of experience do u have? 2. Are you an independent freelancer? 3 do you know how to fix sql injections? - Give 2 example of how to fix sql injections in forms 4. what are the ways you can secure a payment api to protect it from spamming charges- considering that the api information is secured and spamming is not happening by any registered users but through external users 5. what are the ways you can protect smtp apis to protect from email spamming?- considering that the api information is secured and spamming is not happening by any registered users but through external users 6. What are the ways you can show thousands of data on a page? how will you implement it so that it doesn't have load on server and page doesn...

I'm looking for a talented professional who can assist me with formatting a presentation document. Key Requirements: - Ensuring a consistent font throughout - Numbering and bullet points to be consistent and visually appealing - Transforming the document into a Microsoft Word format The goal of this project is to make my document both presentable and professional. Visual elements such as images, tables, or charts may be required. If you have design skills and can help with this, please state your experience in your proposal.

I'm seeking a top-notch photo editor with a keen eye for detail and a knack for making products pop. I have a large batch of 850 product shots that need to be edited. The tasks required are: - We are taking image shapes of designer perfumes and making them into a shadow. We are adding a short 3 word product description. We have attached some samples of some of the work to be done. The final format for these images should be JPEG. If you have experience and proficiency in product photo editing, I'd love to hear from you.

I have a PDF document that needs to be translated from English to Spanish. The document primarily contains marketing materials, and I'm looking for a skilled translator who can accurately convey the original message in Spanish. Key Requirements: - Translate the content from English to Spanish, maintaining the core marketing message. - Preserve the same format and layout as the original PDF. An exact match is not necessary, but a similar layout is expected. - Prior experience with marketing translation is preferred. Please note: - The document is relatively short, with about 3-4 pages of text. - The translation should be delivered in a timely manner.

...project cost. Overview of changes. Details of each change are numbered, and listed below. 1. Collection date availability displayed and selected via popup (This happens on loading a WooCommerce page if date not previously selected) 2. Bar added to top of store pages displaying selected Collection 3. Product page alterations 3a. Additional product image carousel on product page 3b. Products to have “PLACE ORDER” button, instead of “add to cart”. This will redirect to a one-page checkout for that product. 4. Disable shopping cart 5. Create one-page/multi-step ordering 6. Collection time slot selectable at ordering 7. Back end Visual calendar displaying orders by collection date 8. Calendar must sync with google calendar 9. Abili...

I require a custom QR code generator that outputs in SVG format. These QR codes will encode vCard data for contact information. Additionally, I would like the following features: - The QR code should be in the shape of Porsche Crest logo. - The ability to customize the colors of the QR codes. - Support for integrating custom logos or images within the QR code design. Ideal skills and experience for this project include: - Proficiency in SVG format for QR code generation. - Experience with encoding vCard data. - Strong understanding of image manipulation for custom colors and logo integration in QR codes.

I'm in need of a skilled...for a general audience. The primary goal of the content is to educate the readers, so a strong ability to simplify complex information is key. Key requirements: - Expertise in content writing, with a knack for simplifying complex topics - Understanding of audience engagement and ability to create compelling content that keeps readers interested - Strong research skills to ensure accurate, up-to-date information - SEO knowledge to optimize content for search engines while maintaining a natural flow Ideal candidates will have prior experience in writing for general audiences, and can provide samples that demonstrate their ability to simplify complex concepts. A background in journalism or educational writing may also be beneficial. Looking forward to ...

I'm looking for a Selenium expert with strong experience in Python/Java to develop comprehensive and effective Selenium tests for our web application. Key Requirements: - Proficient in Python/Java: Ideal candidate should ha...Attention to Detail: Ability to meticulously craft test cases and identify and report bugs is crucial. Your responsibilities will include: - Collaborating closely with our development team to understand the application structure. - Developing a suite of selenium tests to validate the application's functionality and performance. - Executing and maintaining these tests, ensuring they remain up-to-date as the application evolves. If you're a detail-oriented Selenium expert who excels at Python programming and has a passion for ensuring quality, I...