Sas sql server conversione date 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). -------...

Tarvisin apua nopeasti SAS-ohjelmiston käyttöön liittyen Vaasassa.

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

server optimisation

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

I am seeking a skilled data scraper for a specific platform-oriented task. Your task includes: - Extracting product information such as Reference, Type, Value, Bedrooms, Suite, Garage, Area, Neighborhood, City, Address, Captor, Registration Date, Website, Owner's Name, Owner's Email, Owner's Phone, Owner Category, and Owner Captor. - Downloading all images related to each product and saving them in a separate folder named according to the product code reference. Ideal candidates should have proven experience in web scraping, data mining, and handling a substantial volume of data extraction for digital products. A proficiency in automated image scraping and sorting is a must, along with familiarization in accessing various platforms to retrieve the needed data. Your...

My current server setup is causing slow response times for my web application and database system. This project involves optimizing the server settings to enhance the performance of both the web and database applications. Ideal Skills and Experience: - Proven experience in server performance optimization - Expertise in managing servers running web applications and database systems - Familiarity with Laravel, as the web application is built using this technology - Excellent understanding of server-side technologies and configurations Key responsibilities: - Diagnose the current server setup to identify performance bottlenecks - Implement necessary changes to optimize the server settings - Regularly monitor and fine-tune the server to maint...

I'm in need of a reliable, experienced technical support professional for my basic retail website, built on WordPress. The primary tasks will be regular bug fixing and security updates. Key Responsibilities: - Regularly check and fix bugs that may arise in the website. - One time migration from one hosting service to another - Ensure that the website is secure and up-to-date by performing security updates as needed. The frequency for these tasks will be quarterly. I expect the chosen freelancer to be prompt and efficient in addressing any issues that may crop up. Knowledge of WordPress and experience in maintaining retail websites will be highly regarded.

I'm in need of a reliable, experienced technical support professional for my basic retail website, built on WordPress. The primary tasks will be regular bug fixing and security updates. Key Responsibilities: - Regularly check and fix bugs that may arise in the website. - One time migration from one hosting service to another - Ensure that the website is secure and up-to-date by performing security updates as needed. The frequency for these tasks will be quarterly. I expect the chosen freelancer to be prompt and efficient in addressing any issues that may crop up. Knowledge of WordPress and experience in maintaining retail websites will be highly regarded.

I'm in need of a freelance Node.JS expert to help me with my Node.JS server setup. - Ideal candidate should have extensive experience in setting up and configuring Node.JS servers. - Knowledge of web and mobile application architecture is a plus. - Preference will be given to those with previous experience in API backend development.

Hi, we require an SQL macro that we need to be able to delete EAN codes that have less than 8 numbers from the import. So EAN codes that have between 1 and 7 digits must be removed from the import. We use a software called StoreManager that uses SQL. The formulas entered in the software look like this IF([CSV_COL(16)]=0 OR[CSV_COL(16)]=‘’ OR[CSV_COL(16)]<0,‘’,[CSV_COL(16)]) Payment and/or Milestone after the problem has been solved.

...functionality. Key Responsibilities: - Enhancing the existing dashboard by adding new features and functionalities. - Ensuring that the dashboard has real-time data update and interactive capabilities. Data Sources: - The data sources for this project include databases (SQL, NoSQL) and local files (CSV, Excel). Ideal Candidate: - Proficient in Tableau with a proven track record of developing and enhancing dashboards. - Experience working with real-time data sources and interactive dashboard elements. - Understanding of SQL and/or NoSQL databases. - Familiarity with data visualization best practices. I am looking for a professional who is not only skilled in Tableau but also understands the importance of user experience in data visualization. Please provide some exam...

I'm seeking a skilled developer to create a website where users can generate customized Excel tables. Below are the key project requirements: Key Functions: - The website should allow users to generate customized Excel tables based on specified criteria such as user input, date range, and data filters. - Implement a user registration and login system to secure user data and table generation history. - Incorporate export options to enable users to download the Excel tables they generate. AI-driven Automation System: - It's important that the system integrates an AI-driven automation system. This will streamline the table generation process while providing accurate and efficient results. Subscription Offering: - The system should offer a subscription model where users can...

...Integration with pricing databases. 6. Employee Time Tracking: Track employee hours and integrate with payroll systems with monthly reminder of salary 7. Multi-location Support: Support for multiple locations. 8. Purchase Entry: Include fields for item details, purchase amount, payment method, loan provider, loan amount, cash amount, and purchase date. 9. Sale Entry: Include fields for item details, sale amount, customer details, payment method, and sale date. 10. Feature for Tracking Purchases: Differentiate between cash and loan payments. Specify loan provider and amount. Calculate split payments. Reporting and analysis for payment methods and loan balances. Option to record and automatically deduct loan payments by manually adding the loan payed Additionally, I want dai...

...you passionate about programming languages and eager to make your mark in the IT industry? Look no further! We’re hiring talented individuals to join our dynamic team. Position: Software Engineer Domain: Finacle (Banking) Location: Major cities in India and international locations Why Choose Us? Comprehensive end-to-end training in Unix/Linux, JSP, HTML, Core Java, Node JS, Node red, Oracle SQL, and PLSQL. Exciting projects in the banking domain Opportunities for growth and career advancement Terms and Conditions: Commitment: Minimum 3 years with us Training: First month (free accommodation), followed by competitive salary Performance-based increments from the second year onward Global travel opportunities Qualifications: - While we do not have any specific certificat...

Seeking a seasoned developer to incorporate an automatic date picking system into a business-oriented website. As no information on the current tech-stack for the site was provided, the programmer should be proficient in handling a diverse range of website technologies. The automated date picker tool is designed to facilitate early booking appointments for our clients. The ideal applicant should possess the following competencies: - Strong knowledge and understanding of significant website development platforms like WordPress, Django, Laravel, etc. - Proven experience in implementing date picker functions on web-based applications. - Perfect coding skills with an emphasis on producing clean, efficient, and adaptable code. - A strong understanding of UI/UX principles...

...with our MCA compliance. This is a project-based role, but it may potentially evolve into a long-term relationship if the right freelancer is found. Key Responsibilities: - Filing of Annual Returns: You must be adept at the timely filing of our company's annual returns with the Ministry of Corporate Affairs. - Maintenance of Statutory Registers: Keeping our statutory records and registers up-to-date is crucial to ensure compliance. Your role would involve meticulous record-keeping and regular updates. - Preparation of Board Resolutions: I require a professional who is knowledgeable on the legal framework for board decisions and capable of drafting these resolutions as needed. Ideal Candidate: - Company Secretary Certification: A CS certification is a must-have for this ro...

...Collaborate with cross-functional teams to define, design, and ship new features. Implement user interfaces and experiences using HTML, CSS, and JavaScript. Write clean, maintainable, and efficient code. Optimize applications for maximum speed and scalability. Participate in code reviews to ensure code quality and adherence to coding standards. Troubleshoot and debug issues as they arise. Stay up-to-date with emerging technologies and industry trends. Work closely with designers and product managers to translate requirements into technical solutions. Contribute to the continuous improvement of development processes and practices. Requirements: Bachelor's degree in Computer Science, Engineering, or a related field. Proven experience developing web applications using Angular ...

I'm seeking a seasoned resume writer, with a knack for crafting resumes focused on the IT industry and a comprehensive understanding of executive-level priorities. - Your target audience will be, primarily, senior decision-makers in IT recruitment. - Also, the resume must highlight my skills as an Architect. Ideal Candidate: - Proficient in resume building for executives. ...Your target audience will be, primarily, senior decision-makers in IT recruitment. - Also, the resume must highlight my skills as an Architect. Ideal Candidate: - Proficient in resume building for executives. - Knowledge of the IT industry (java Full Stack development) and architect roles. - Excellent communicator with collaborative editing skills. - MongoD...

I'm in search of an experienced Radius Server Developer who can take on a comprehensive project. create a radius server that can communicate with OLT, ROUTERS AND VM on HUAWEI, CISCO, FIBERHOME, VSOLUTION, MIKROTIK, UBIQUIT and others through PPPOE, VLAN, IPOE, HOTSPOT ETC

...analyst with expertise in SQL and R to conduct a thorough review and testing of a recently completed data analysis project. The successful candidate will be responsible for evaluating the accuracy and completeness of the work, ensuring all requirements are met, and identifying any potential issues or opportunities for improvement. Responsibilities: Review the SQL queries and R scripts used in the project for accuracy and efficiency. Test the data outputs to ensure they align with the project requirements. Verify that all analysis reports are complete and adhere to the specified guidelines. Provide a detailed report outlining any issues found, confirming requirement fulfillment, and suggesting any potential upgrades or improvements. Requirements: Proven expertise in ...

...looking for a skilled developer to create an online interface which can upload a Word document and extract key pieces of information to populate a database. Key Requirements: - Extract multiple fields: The tool should be able to efficiently parse and extract a range of fields from the Word document, such as Title, Author, Date, Description, and Quantity. - Metadata Extraction: The primary focus of this project is to extract specific metadata from the document, specifically Date, Description, and Quantity. - Populate Database: The extracted data should then be used to populate a database. Ideal Skills and Experience: - Proficiency in programming languages and tools for working with Word documents. - Experience in developing data extraction and parsing tools. - Familiar...

My business requires a digital marketing expert to create our logo ...accounts (primarily Instagram and Facebook) ensuring they are updated with relevant content regularly. - Review and improve our current SEO practices to enhance our visibility on search engines. We're looking for someone who: - Has a proven track record in both logo design and digital marketing, with at least 3 years of experience in each. - Is proficient in using design tools and software. - Is up to date with the latest trends and best practices in digital marketing and logo design. - Can provide us with a portfolio of previous work that demonstrates their skills and achievements. This project's completion timeline is flexible. Please provide an estimated time frame for your work to be finished when...

I'm seeking a seasoned Digital Marketer, Shopify Expert, and Social Media Expert to drive new clients towards my startup. Our current marketing channels include LinkedIn Posts,...optimize customer testimonial-based social media content - Get new clients from freelancing sites Ideal skill set: - Proven experience in lead generation through digital marketing - Shopify expertise for optimizing website conversions - Strong social media marketing capabilities, with a focus on customer testimonials - Excellent analytical skills to track and optimize campaign performance - Up-to-date knowledge of the latest marketing trends and tools If you have a successful track record in lead generation, a creative approach to social media content, and a passion for startups, I look forward to he...

Need a ad done that will be posted to Facebook Instagram and TikTok. It’s to advertise Vehicle Inspections being done at our automotive garage It must include Phrase- Is your vehicles inspection up to date? Phrase- R&R is now an authorized Vehicle Testing Station! (VTS #80) Phrase- Come In and Get Your Inspection Done Today! Artwork: someone conducting inspections Logo Contact Number - 374-6528/636-1313/681-1447 Address: #41 Southern Main Road McBean Couva

...recurring problem with my Linux web hosting server. The issue essentially revolves around the Apache service, which keeps turning itself off and on sporadically. This continuous fluctuation is causing disruptions in the operation of my hosted websites. The primary goal of my project is to address and resolve this persistent Apache service problem. I need a skilled server administrator or a Linux system expert to investigate the root cause of the Apache's erratic behavior and implement a permanent fix for the issue. Key Requirements: - Proficient in Linux server administration - Expertise in Apache server configuration and troubleshooting - Experience with identifying and resolving service disruption problems - Ability to work remotely and access ser...

...-Customer -Invoice Number -Date -Product Details -Quantity -Unit Price -Purchase Amount I have this data for last two years in monthly files. We want to observe the trends in sales, most selling product, most profitable product, least profitable product etc. We want to see the customers trends and see which customers are buying less and vice versa. Please recommend technology we are open to feedback. Along with this i will like another separate file for another user who will look after the Customer Service and sales side of the business. I would like this second file to extract selective data from the master file and propmt the user to make phone calls to existing customer and note down the call notes and mark that a certain customer has been contacted on this date and...

I'm on the lookout for a skilled website manager who can handle multiple facets of my E-commerce website. In addition to managing the website, you will also be responsible for marketing through various channels. Key Responsibilities: - **Website Maintenance:** You'll be responsible for ensuring the website is running smoothly, keeping the design up-to-date, and overseeing its overall functionality. - **Content Creation:** As my website manager, you'll be tasked with creating engaging and SEO-optimized content for the site. - **SEO Optimization:** You'll need to possess a strong understanding of SEO practices to ensure the website ranks well in search engine results. Marketing Channels: - **Social Media:** Your role will include managing the social media profile...

...existing capacitorjs plugin to version 5 and introduce Android compatibility. I am looking for a Geofence plugin. I have a good starting point with a public plugin, but it needs updating. Here is the source repository: Please reference it, and add updates to it for capacitor version 5, update any of the swift or Objective C code that may be out of date, add corresponding support for Android. Key Requirements: - The main focus of this project is to enhance the plugin's compatibility with various platforms, particularly iOS and Android. - The plugin should be updated to Capacitorjs v5 to ensure it's leveraging the latest features and security patches.. Ideal Skills and Experience: - Proficient in Capacitorjs, IOS and Android development. - Experience

I'm looking for an expert to help with uninstalling Windows Server 2016 (evaluation mode) and installing Windows 10 Pro on my laptop. Here are the specifics: - I'm seeking this migration for personal use, as I find Windows 10 Pro more suitable for my needs. - I've confirmed that there's no necessity to back up any data before the migration. Ideal Freelancer: - Proficient in Windows Server and Windows 10 Pro migrations - Can ensure a smooth transition without data loss - Able to advise on or assist in obtaining a Windows 10 Pro license, as needed.

I am in need of a react-native whizz who can figure out and solve the error messages plaguing my project post SDK upgrade. Detail-oriented and aggressive troubleshooting skills are a must for this job. Since upgrading my SDK from version 50 to 51, my project has been inundated with errors. My dependencies are up-to-date and compatible with the new SDK version, but a solution remains elusive. The errors appearing are related to syntax issues and styles import (hermes) Ideal Skills: - Extensive experience in react-native - Comprehensive understanding of SDKs and upgrading processes - Excellent debugging capabilities Nobody likes bugs, so let's squish this one fast. Looking forward to working with an enthusiastic problem solver.

As a fitness brand targeting individuals over 30 who are eagerly seeking a transformation, I require a versatile marketing team to manage every aspect of our promotion and content creation,...Campaigns: Crafting powerful emails to keep our customers engaged and selling our fitness products. Ideal skills and experiences for this job include expertise in social media management, proficiency in content creation (both written and visual), and a knack for launching effective advertising campaigns. A background in fitness or health marketing is a plus. Crucially, you should be creative, up-to-date with marketing trends, and able to use data-driven insights to improve strategy. Your goal will be to boost brand awareness and increase sales by effectively reaching and influencing our target...

...com/file/LJsytcax2WmStFrLOWBgM6/FitApp?type=design&node-id=3-65&mode=design How it works: - The entire user journey is gamification. - The user chooses a project that has x days (screen 1). Then you must mark the completed days (screen 2) in the app to earn coins. - The coins are on the top bar (Fixed) and starts with 0 coins. - The number of user coins and complete days must be saved in a local sql-lite database. Summary: - Create app with Expo 50 and TypeScript; - The data must be saved in a local database. This project is offline, but there must be online synchronization support with the offline-first approach. Save user coins, projects and days complete; - Number of days on screen 2 must be dynamic, according to what is selected by the user; - Create a service wh...

I'm seeking a developer with relevant experience in PHP scripting, Google Ads API and Windows OS to provide me with a script that will help with my Google Ads functions. This functionality entails both Keyword Planner integration and a Server-to-Server flow setup. Your tasks will be: • to integrate the Google Keyword Planner into the script, • to set up a server-to-server flow on a Windows operating system, • to ensure compatibility with PHP 8.0. Your understanding of Google Ads API for keyword planning and server interaction flow will be pivotal to this project. Prior experience with these tools will set you apart. Efficiency, accuracy, and an application that runs smoothly are key to the success of this project. Please be prepar...

I need an experienced specialist to configure my ESXi server, specifically focusing on storage settings and virtual machine settings. Skills and Experience Required: - Solid experience with ESXi server setup - Storage configuration skills - Familiarity with Virtual Machine settings Tasks Include: - Configure local storage on ESXi server - Set up virtual machine settings for 1-5 machines Having previously worked on similar server configuration tasks would be an added advantage.

Thrilled to seek an e-commerce assistant with 3+ years experience for our thriving online retail business focused on clothing and accessories. The ideal candidate will have sharp skills in: - Product listing - Inventory management You will be entrusted with the responsibility of order processing and ful...business focused on clothing and accessories. The ideal candidate will have sharp skills in: - Product listing - Inventory management You will be entrusted with the responsibility of order processing and fulfillment, ensuring a seamless customer experience. Excellent customer service and support are fundamental to this role. Our goal is to ensure our product listings are accurate and up-to-date, and our inventory well managed. Your journey in online retail await...

Seeking a developer with experience in C# and SQL for a predictive artificial intelligence project. Your role will involve developing a model to predict user behavior on a vending machine, utilizing data stored in SQL Server. Proficiency in artificial intelligence is required. Please don't send a bid to later try to increase it. Will be declined.

I'm seeking a professional who can take on the role of a webmaster and also manage our dedicated server. Key Responsibilities: - Ensure the website is running smoothly by performing regular maintenance. - Updating website content as needed. - Undertake back-end development tasks to keep the site functional and efficient. - Handle the server management, particularly in terms of maintenance and updates on a weekly basis. Ideal Candidate: - Proven experience as a webmaster - Proficiency in back-end development - Prior experience with server management, especially dedicated servers - Able to commit to weekly server maintenance Your bid should reflect your experience in both webmaster tasks and server management.

Stepping Back Through Data I have a table of orders, lets say. I'm trying to find all the "Completed" orders, and then step back through other "Cancelled" orders for the same Customer, that were created within 72 hours. The trick is, I want to keep stepping back until I don't find anymore orders (the 72 hour window will now be based on the last order found). Also, the logic should stop if it finds another "Completed" order for the same customer. I've included a test table and data, as well as an expected output. CREATE TABLE #Order ( OrderID int, CustomerID int, OrderDate datetime, OrderStatus varchar(25) ) INSERT INTO #Order VALUES (1, 1, '02/15/2024 07:00 AM', 'Cancelled') INSERT...

I need a talented SQL developer to create a stored procedure that will automate the process of marking certain items as 'picked up' in our Microsoft SQL Server database. This script should essentially replicate the functionality of our existing Windows application, performing the necessary changes in the database to reflect this status. Key Requirements: - Strong command of SQL and experience in Microsoft SQL Server is essential. - Familiarity with Windows application development is a plus, as this script should mirror the behavior of our existing front-end tool. - Previous experience in creating SQL stored procedures for automating database actions is highly preferred. - Attention to detail and the ability to trace SQL com...

...balancing both functionality and aesthetics The final product should be a clean, sleek, and easy-to-navigate website, reflecting the minimalistic style while providing exceptional user experience. My expectation is for a thorough, detailed-oriented professional who can capture my vision and translate it into a fully functional portfolio site. Things to be done Load an API data into on premise SQL server database Client will do some data calcution The new data will be available in the database and needs to be show in website with some base UI. Project involves show some other API data on the website as well Need not have a lot of experience in UI design but need experience showing data into a page. Website would look like this --- Odds data should be

...authentication and authorization systems. - Knowledge of implementing role-based access control. 1 Registration Screen for Admin & User UserID Password Confirm Password FirstName MiddleName LastName Email Phone Sex Company Date Created Date Updated 2 Forgot Password Email 3 Change Password Old Pass New Pass Confirm Pass 4 Admin Dashboard Screen to manage Users and User Roles a. Admin User have permission to create an another user. Page #1 can be used. b. View of Users and Assign Roles, Permission. Status, Last Login, Date Created/Updated/Deleted. 5 Logs - Admin to view the logs of all the users - like when they logged in , what actions they did for audit purpose. Just a view and search screen 1. Registration &a...

I am in need of a qualified Product Manager who can effectively manage my software product, which is a web-based service. I am not disclosing the primary functionality of the web-based service at this point but it could involve either data management, customer interaction, ...transactions. Skills and Experience required: - Proven track record with managing web-based service software - Proficient understanding of data management, customer interaction, and eCommerce transactions - Capability to strategize and plan product goals and execution The ideal candidate would have insightful understanding of the intricacies of managing a web-based service software product and be up-to-date with the latest industry trends and technologies. A solid background in software product management is ...