Sql server rollup multiple rows 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). -------...

Updates on multiple websites.

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

Multiple Writing jobs.

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 require a freelancer to type text data into an Excel sheet from printed documents. Scope of work: - Convert printed text documents into digital format via Excel - Ensure data is accurately entered The project does require specific formatting: - Data should be arranged in rows Ideal candidate: - Must have proficient Excel skills - Experience with data entry - Attention to detail, to ensure accuracy in work - Able to follow specific instructions for data organization

...transfer this data into tables, with the primary goal of organizing the information for better clarity and ease of understanding. Key Tasks: - Type the data into tables: This needs to be done with meticulous attention to detail to ensure accuracy and integrity of the data. - Apply borders and shading: To enhance the visibility of the tables and make them aesthetically pleasing. - Utilize headers: Rows and columns should have appropriate headers to aid in quick data navigation. Ideal Freelancer: - Proficient in Excel: Ability to work with intermediate level of data such as formulas and charts. - Strong attention to detail: Critical for ensuring that data is entered accurately. - Experience with design: To create visually appealing tables using borders and shading. - Organization...

Job Summary: We are seeking a skilled Full Stack Developer to build a webstore using our custom-made NopCommerce template. As part of our development team, you will be responsible for executing the provided designs into a fully functional ecommerce platform. This role is crucial as we are currently managing multiple projects and require additional expertise to meet our delivery timelines. Key Responsibilities: - Develop and deploy a webstore using our custom NopCommerce template, adhering closely to the provided mockups. - Implement the front-end and back-end aspects of the webstore to ensure a seamless user experience and efficient backend processing. - Test and troubleshoot any issues that arise during the development phase to ensure a smooth launch. - Collaborate with the proj...

As a freelance content creator, my specialty lies in the health and wellness industry. With my expertise, I can create compelling and informative content suitable for multiple platforms. - SKILLS & EXPERIENCE: I am ideally looking for opportunities that require comprehensive understanding of health and wellness topics. Proficiency in research and knowledge in SEO would be advantageous. Understanding industry trends, ability to create engaging health-related content, and meeting deadline are paramount for this role. - SPECIALIZATION: My sole focus is on the health and wellness domain. As such, I'm on the lookout for tasks where my specialty can make a significant impact. If you need a seasoned content creator for your wellness blog or health-focused website, it's an ...

I'm seeking a skilled videographer to create high-quality 1080p street food preparation videos. This is a long-term project opportunity, and the selected professional will be considered for future collaborations. I don't need edited videos. Videos should be original not from youtube or any other platform. I'll pay 10$ per video. You can make as much videos as you can. you can make multiple videos of same vendor/shop/restaurant but not more than 5. Key Requirements: - Create engaging and visually appealing street food preparation videos in 1080p resolution - No specific geographic location required - you can shoot from anywhere - Experience in shooting food-related content is a big plus The ideal candidate will have: - A passion for street food and food culture is w...

I am in need of a well-versed Python expert to assist in managing a Linux server. This project is task oriented and requires specific skills including: • Working with server data analysis • Implementing web scraping techniques • Establishing automation processes The role also demands a comprehensive understanding of Linux operations and the ability to print headers. A background in server security, setting up database servers and performance optimization would be ideal, but the focus is primarily on Linux server management via Python. Proficiency in Python, Linux, server data analysis and web scraping are must-haves. Experience in automation and server management will highly be appreciated. Looking forward to your knowledgeable a...

I am in search of a proficient virtual assistant who is adept at listing products on Wix and Shopify. Your primary task will be to assist with the listing of an array of clothing items on these platforms. Ideally, the candidate should possess: - In-depth understanding of Wix and Shopify platforms - Proficiency in product listing across multiple categories, preferably clothing - Excellent attention to detail to ensure accurate descriptions and optimal keyword use - Experience with product photography or digital photo editing is an advantage - download product images and editing to the theme and layout of our website - Come up with product names, product description that is SEO optimized - Work closely with founder to fix price and work on website Required: - A desktop, Laptop tha...

...creating high-quality visual representations? We're seeking a skilled individual to produce stunning renders of our innovative caffeinated gum product. If you have an eye for detail, a knack for realism, and the ability to bring digital products to life, we want to hear from you! Responsibilities: Utilize our provided 3D GLB file of the caffeinated gum product to create photorealistic renders from multiple angles. Apply textures, lighting, and effects to achieve a lifelike appearance that showcases the product's features and benefits. Ensure consistency in branding and visual style across all renders. Collaborate closely with our team to understand project requirements and deliver results that exceed expectations. Iterate on render revisions based on feedback to achie...

As an individual seeking to enhance the visibility of my informational and educational website for adults, I am seeking a professional off-page SEO professional. Your tasks: - Implement effective link-building strategies - Promote the website's content - Use social bookmarking for a wider reach - List the business on multiple platforms - Backlinks are on unique and c-class IP not the same -100 business listings on unique data The ideal candidate should possess a strong understanding of the latest off-page optimization techniques. They should be capable of meeting project goals while working independently. Demonstrated experience in content promotion, link building and social bookmarking is a must. Understanding the adult learning sector would be advantageous.

I need messages I receive in a specific server channel to be forwarded to my own servers channel, I do not have admin role for the server channel I will need messages forwarded from, so I need a script or anything you can come up with, I am allowed to invite accounts to the server channel

I require a proficient freelancer to assist in data entry from printed documents into an excel sheet. You'll also need to arrange this content meticulously within columns and rows. Your responsibilities will include: - Accurate transcription of data from printed material - Effective organization of the data by columns and rows in Excel The perfect candidate for this job is someone with outstanding data entry skills and a keen eye for detail to ensure accuracy. Experience working with Excel and translating printed documents is a necessity. Accuracy, speed and confidentiality are vital.

I'm in need of an experienced document translator who can handle multilingual translation. Key Project Requirements: - Multi...experienced document translator who can handle multilingual translation. Key Project Requirements: - Multilingual Translation: Proficiency in translating documents into multiple languages is fundamental for this project. Please let me know what languages you're comfortable working with. - Experience: I'm particularly interested in your translation experience, so please provide your translation portfolio, highlighting any multilingual works. - Quality: I'm looking for a high-quality translation that's accurate, clear, and culturally appropriate. Please apply if you have solid experience in document translation and can handle mu...

I'm in need of a skilled developer experienced in Google Cloud Vision API and ASPRunner to implement real-time multilingual text translation feature within my current project. Requirements: - Integration of Google Cloud Vision API into my ASPRunner project - Implementing text recognition specifically for real-time translation - Ensuring support for multiple languages is available

I am in need of a skilled social media expert who can help me post a donation link across multiple platforms. The task is urgent and I need it done ASAP. - I'm looking for someone who's proficient with Facebook, Twitter, Instagram, TikTok, and Snapchat. The project requires posting the donation link ( gofundme ) for family live in Gaza across all these platforms. - The ideal candidate should have a thorough understanding of these platforms and how different users interact with each, as well as how to engage a diverse audience. - Previous experience with donation campaigns is a big plus. - I am looking for someone who can work quickly and efficiently, as the project needs to be completed as soon as possible. If you think you have the skills and availability to help me w...

I’m looking for an experienced Facebook specialist who can manage and create engaging content for multiple Facebook groups which I own. Can create campaign reports and email to clients. This includes but is not limited to: - Taking control of managing group posts, - Working with group admins, moderating and monitoring comments and interactions, - Creating appealing, engaging content daily, - Building relationships with other relevant pages and becoming involved in other groups, - Monetising ads within our groups in a way that contributes positively to user experience. - Commenting on threads in our facebook pages to build community and connections, leading to pre sales good will. - Produce a weekly report of key traffic targets and revenue This task is intensive, as it in...

...specifically for multiple countries (US, Australia, NZ and UK). Understanding of localized SEO strategies and practices tailored for various global markets is required. - Project Timeline: I am looking for someone who can start immediately. Please provide an expected project timeline in your proposal. Looking forward to receiving proposals from professionals who truly understand and respect these requirements and objectives. Please include the phrase "Multi-Country SEO" in your proposal to confirm your thorough understanding of this project's needs. Thank you. We have both an Australian website with a DA 62 and just launched an American website 53 similar name similar content but blogs are different to keep content google and new to google algorithms. We have h...

...TCP/IP protocol, sometimes combined with technologies such as HTTP/WebSocket. o Push Notifications: Notify users of new messages when the application is not running in the foreground. o Encryption & Security: Ensure the security of message transmission, common encryption technologies include TLS/SSL, end-to-end encryption, etc. o Synchronization: Synchronize messages and user data between multiple devices. o File Transfer: Allow users to send and receive files. o Client Development: Develop client applications for cloud interaction with servers. • One-on-One Chat Functionality o Message Sending and Receiving: Users can send text messages, emoticons, images, audio, and video files. Support real-time transmission of messages and storage and synchronizatio...

I'm in urgent need of an expert in malware removal to assist me with cleaning up more than 5 of my websites. The affected websites are a mix of e-commerce and blog sites. The malware has cau...malware has caused significant issues on these sites, including: - Phishing attacks - All sites showing a white page and appearing to be disabled Your primary task will be to conduct a thorough clean-up of these sites, ensuring all malware is removed and that the sites are restored to their original state. Ideal Skills and Experience: - Proven experience with malware removal, particularly for multiple websites - Familiarity with e-commerce and blog sites - Ability to conduct a thorough clean-up without causing any additional damage - Knowledge of security best practices to prevent f...

I'm looking for a talented freelancer to help me with guest posting multiple projects. The primary goal of this project is to increase website traffic, keywords ranking and improve brand visibility. We're specifically focusing on creating high quality guest posts with a DA of 40+ or 51+. Note: Our maximum budget is for per guest post do-follow link is Rupees 500 to 700. You don't need to write content, we will provide fresh human written blogs for that. For starting we will buy 5 to 10 links. if everything will be good so we will go for more projects. Remember: Links should be live for long period at least 2 to 3 years, and should be dofollow link on given achor text. Kindly excuse those freelancer or companies whose bid is higher than our maximum budget (we will n...

I'm looking for a proficient developer who can assist me in building a lead generation website. The primary purpose of the website is to accumulate contact information from individual consumers. Importantly, the contact form needs to be highly customized and advanced, containing multiple pages with different fields. Ideal Skills and Experience: - Web development expertise. - Knowledge in designing sophisticated, user-friendly contact forms. - An understanding of optimization tactics for lead generation. - Experience in targeting individual consumers. Only those having proficiency and prior experience working with similar projects should apply. Your role will be instrumental in shaping my project.

I'm looking for a marketing professional who can help me achieve several key objectives for my project, including increasing brand awareness, generating leads, and driving website traffic. The ideal candidate should have: - A proven trac...professionals aged 30-55 and retirees aged 55+. - Proficiency in utilizing various channels and techniques to achieve the desired marketing goals. - A creative and data-driven approach to ensure the best possible outcomes within a limited budget. The budget for this project is less than $500. Please provide a proposal outlining your strategy, approach, and expected outcomes within this budget. Multiple blog posts related to cleaning will be required, will need to have expert knowledge to work on website (Wix), and marketing, content creati...

I'm currently seeking a skilled backend developer who has proven expertise in Python, Java, and Ruby. I need someone who can guide me through whether to use the current source code or start from scratch, a decision that we can make together as the project evolves. As our project's main responsibility is to handle authentication and server configuration, the perfect candidate should be experienced in: - Setting up, managing, and sustaining server configurations - Handling various authentication tasks - Expertise in Python, Java, and Ruby - Decision-making skills concerning source code development This project will be rewarding for someone who enjoys tackling unique challenges and has a flair for problem-solving. If you're up to the task, please don’t ...

I need an expert in digital marketing who can effectively increase visibility for my application across Facebook, Instagram, and Google Ads. Goals: • Augment brand awareness • Drive app downloads • Enhance user engagement Target Audience: • Young adults between ages 18-24 • Working professionals • Parents Ideal skills for this project include significant experience with digital advertising across the listed platforms, a deep understanding of advertising strategies tailored to the nuanced sensibilities of each demographic we aim to reach, and a proven track record of delivering increased user activity and app downloads through effective advertising campaigns.

I am currently ...currently working on a project that requires the integration of Excel with a PostgreSQL database. As such, I am in need of a freelancer who is proficient in both Excel and PostgreSQL. The primary tasks to accomplish include: 1. Exporting data from Excel to SQL 2. Updating PostgreSQL data using Excel You will be working with various kinds of data as we aim to streamline our operations in a more efficient manner. Ideal skills and experience include: - Solid understanding of PostgreSQL - Expert skills in Excel - Previous experience with SQL data exporting and updating The success of this project highly relies on a flawless data transfer between Excel and PostgreSQL. Your expertise will be extremely valuable to our project's completion. I need this...

I'm in need of a skilled graphic designer to take a draft image I have and produce the final artwork in multiple sizes suitable for Facebook and Instagram. Key Requirements: - Transform a draft image into high-quality, final artwork suitable for social media use - Resize the final artwork into designated sizes for optimal display on Facebook and Instagram - Provide the artwork in specific sizes: Instagram (1080px x 1080px), 1080 x 1920, and 1640 x 924 Ideal Freelancer: - Proven experience in graphic design and social media artwork - Strong understanding of Facebook and Instagram image requirements - Ability to effectively resize and reformat images without compromising quality. Details on draft image are incorrect and will need to be updated

...Responsibilities: - Debunk complexities of setting up an online store from scratch. - Infuse the platform with user account registration and advanced search functionalities. - Build an easy-to-navigate size chart for each clothing product. - Develop multiple website sections for different product categories. Ideal Skills and Experience: - Extensive experience in e-commerce website development and the GCC market. - Proficiency in user interface design, user experience (UX) techniques and strategies. - Experience in creating efficient size charts and multiple sections per website. - Results-oriented and keen on establishing user-friendly platforms. The expert I seek should be skilled in leveraging the various features of an e-commerce website to create a platform targeti...

The attached PDF lists every musician who played for the St. Louis Symphony between 1907-1908 and 1978-1979. I would like the data copied into a spreadsheet. To illustrate the desired format, I have entered the first 11 rows into the attached spreadsheet. The PDF is 34 pages long and I estimate it lists 1500 musicians. I would estimate the job will take 15 person-hours to complete. Thanks for your consideration!

I'm seeking ...expert to assist with setting up a GRE tunnel on our MikroTik router. The primary goal of this project is to seamlessly connect our multiple remote offices. Key Requirements: - Implementation of a MikroTik GRE tunnel configuration emphasizing on traffic routing - Ensuring optimal connectivity and data transmission between all connected offices Ideal Candidate: - Proficiency in MikroTik router configuration, particularly with GRE tunnels - Solid understanding and experience with network traffic routing - Prior experience with setting up connectivity for remote offices - Ability to ensure uninterrupted data transmission and network availability across multiple locations This is an urgent project, so I'm looking for someone who can start promptly and...

I need a creative, playful logo designed for my dessert company company name is SWEET SENSATIONS DESSERTS. We primarily specialize in cupcakes, pies, and pudding. The preferred color scheme for our logo is a tasteful blend of pink, gray, and white. Ideal Skills and Experience: - Prove...experience in crafting distinct and memorable branding elements - Prior work on food or bakery industry is beneficial - Proficiency in design software - Ability to translate business needs into creative visuals Job Expectations: - The design should reflect a playful, friendly and enticing vibe - Consider including visuals related to our specialities (cupcakes, pies, and pudding) - Must provide multiple iterations - Final files in vector format I look forward to seeing the unique designs you com...

We are looking for a freelancer with strong web scraping experience for an exciting and challenging project. We need to gather specific data from multiple online sources and transform it into useful, structured information for analysis. Responsibilities: Utilize web scraping techniques to extract data from selected websites. Automate the extraction process to ensure accuracy and efficiency. Clean and structure the collected data into readable and usable formats. Integrate the extracted data into a database or spreadsheet as needed. Collaborate with our team to understand specific requirements and ensure the quality of the obtained data. Requirements: Demonstrable experience in web scraping using tools like Python (Beautiful Soup, Scrapy), Selenium, etc. Solid knowledge of HTML, C...

...for a proficient professional who can create a report in Microsoft Access from a MySQL database. The report should contain data from the MySQL database, calculations or summaries of data, visualizations or charts, and be structured as a paginated report, using SQL language. The report should be designed to be accessed as a printable PDF document. It is not required to be interactive, as a static report is sufficient for my needs. Key Requirements: - Proficiency in Microsoft Access, MySQL, VBA, PDF, Python, and Excel - Competency in SQL language for data manipulation - Experience in designing paginated reports The ideal candidate should have a proven track record of creating similar reports, with the skills and knowledge necessary to work with the specified technologies...

Hello, Our newly established company, Troyia, is seeking corporate identity and branding services that reflect both the information technology (IT) and defense industry consulting sectors. Like Adidas, which uses multiple active logos, we desire separate and iconic logo designs for each sector. Desired Designs: Logo Designs: Minimalist, iconic logos that represent each department. For example, for the defense industry, a minimalist logo design featuring a Trojan horse head with armor details. Both logos should resemble each other by about 90%. Business Card Designs: Professional business cards for both sectors, incorporating company information and the logo designs. Social Media Graphics: Suitable profile and cover images for Facebook, Instagram, Twitter, Reddit, and LinkedIn i...

ACDP is an enterprise and on the lookout for a skilled IT professional to help bring a variety of projects to life. The scope is broad, encompassing possible website development, software creation, or app building initia...and Expertise:** - Proficiency in relevant programming languages (Must have: Codeigniter, WordPress, Microsoft technologies like Azure, Power Apps) - Strong understanding of the full development cycle - Experience with both front-end and back-end development (specific skills depend on the project type) - Problem-solving abilities and a keen eye for detail This collaboration could span multiple projects, so I'm keen to establish a reliable, long-term relationship. If you're passionate about IT and ready to tackle diverse challenges, I'd love...

I'm looking to set up a Minecraft 1.16 server focused on mini-games. Initially, I'd need 4-6 mini-games to be developed. Key Responsibilities: - Configure and set up a Minecraft 1.16 server - Design and implement 4-6 engaging mini-games - Ensure the server's smooth running and performance Ideal Skills: - Proficiency in Minecraft server setup - Proven experience in mini-games development - Strong understanding of Minecraft 1.16 mechanics - Ability to manage and maintain server performance - Creative problem-solving skills to enhance player experience Looking for a dedicated and experienced Minecraft developer who can not only set up the server but also create fun and unique mini-games within it. The goal is to attract and retain a strong ...

...maximum and agencies should not apply. Key Responsibilities: Design and develop a user-friendly mobile application for iOS and Android platforms. Implement AI and NLP (Natural Language Processing) features for online interaction with users with future development for offline interactions. Integrate selective caching for offline access to critical conversation threads. Work with RESTful APIs for server-side features and NMEA (National Marine Electronics Association) data integration. Develop and manage a comprehensive database to handle user profiles, chat histories, and app analytics. Collaborate with UI/UX designers to ensure the app is intuitive and engaging. Ensure the application is compliant with all relevant maritime safety and communication standards. Optimize performa...

As a business, I'm looking for a skilled freelancer to help me create an extractor for past paper content from multiple different exam boards/papers from different subjects. This will be from PDF files and organize it into a JSON format. This will help in creating a structured database for our educational materials. Key Requirements: - Extract data from PDF files: The freelancer should have experience in data extraction from PDFs. The goal is to extract content like questions, answers, and any other relevant details. This extractor should be able to be used for different exam boards - Organize data by year, subject, and difficulty level: The extracted data should be categorized based on these parameters. This is crucial for our business as it will help us create a user-friendl...

Need an Excel combinations generator that can generate combinations into a list from multiple numbers. Need an input, numbers will have commas between them, for example (9,12,21,22,29,40). Input numbers 6* and need output of 3 numbers. the result should look like this list. Have the option for output, how many numbers of combinations to choose from. input can be up to 20 numbers and output can be from 1-19. 9,12,21 9,12,22 9,12,29 9,12,40 9,21,22 9,21,29 9,21,40 9,22,29 9,22,40 9,29,40 12,21,22 12,21,29 12,21,40 12,22,29 12,22,40 12,29,40 21,22,29 21,22,40 21,29,40 22,29,40 When multiple inputs are present, they should look like this. Input* 9,12,21,22,29,40 5,18,30,41,46,52 11,14,19,33,44,54 output* 9,12,21 9,12,22 9,12,29 9,12,40 9,21,22 9,21,29 9,21,40 9,22,29...