Sql running total 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 ;)

...developed will be a mix of both attended and unattended types. The primary focus will be on providing bot support and bug fixes while also conducting Control Room adminstrator tasks. Key Responsibilities: - Bot production support and RCA - Develop Bug Fixes - Control Room Admin Tasks ***Need someone who is communicative and able to take on tasks without direction. Need to ensure automations are running in prod and also proactively identify and document enhancments and better way of doing things. This a new client and we have authority in making changes that other support folks can follow. Ideal Skills: - Proficient in Automation Anywhere AA360 - Experienced in both Control Room Administration and Bot Development - Capable of developing both attended and unattended bots - Str...

...While our focus will be on a variety of electronic items, your expertise in identifying and sourcing profitable products will be key. • Sales Strategy: We need you to leverage your marketing and advertising acumen to boost sales and drive our growth. • Brand Development: Collaborating closely with me, your goal will be to create and nurture a strong, recognizable brand. Budget: I have allocated a total budget between $3,000 and $5,000 for this project, encompassing all costs. The ideal candidate will possess a proven track record in e-commerce, particularly in dropshipping, and can provide hands-on guidance to ensure our success. If this opportunity interests you, please share your relevant experience, past achievements, and your proposed strategy to help us reach our...

Build transcoding panel features - dashboard show, cpu utilzation by grapihc using widgets, show total connections, show total streams online/offline/ show per row each gpu statics with utilzation graphics , show total in and outgoing network metrics/ usage of traffic (from uptime second til now realtime) if reboot server then start from 0 traffic data - page live streams , show stream details (kbps/audio/codec/videocodec/total connections/uptime stream/restart stop buttons, mini popup jwplayer or hls player to show live stream - add stream, support multi source setup, select gpu , select profile for transcode, select output http stream/rtmp stream output *( rtmp,rtsp,rtp,rtmpe, udp,http,mpegts,ts,hls,dash all protocols) - profiles for transcoding (attach to gp...

...transform it into two slow-motion shots of the TV for a music video. The first shot: The TV levitating off the table and beginning to explode. This shot requires compositing. The second shot: The TV in the air, exploding into a fireball. This is a 100% VFX shot. Key Requirements: - Create a photorealistic slow-motion explosion - Animate both shots, composite one. - Render about ten seconds of runtime total, 5s per shot. - Include high-detail debris in the explosion. Skills and Experience: - Proficiency in 3D modeling, animation, and compositing - Experience in creating photorealistic VFX - Ability to interpret and enhance a provided model Files are here: Please feel free to reach out if you need additional materials

...mobile and web development lifecycle. Proven experience as a Senior Web Developer / Front End Developer or similar role, with a strong portfolio of web development projects Expertise in modern web development technologies and frameworks such as JavaScript and React. Aware of best practices in implementing functionality into UI/UX design Desirable experience, an understanding of C#, ASP.NET, SQL and .NET Core for back-end integration. No agencies please....

...mobile and web development lifecycle. Proven experience as a Senior Web Developer / Front End Developer or similar role, with a strong portfolio of web development projects Expertise in modern web development technologies and frameworks such as JavaScript and React. Aware of best practices in implementing functionality into UI/UX design Desirable experience, an understanding of C#, ASP.NET, SQL and .NET Core for back-end integration. No agencies please....

I need a skilled designer to change the color of clothing on product pictures for my women's fashion brand. The project involves altering 30 images in total. Tasks: - Change clothing color to 3 new shades across 5 different styles, with 2 images for each style - Match garment colors to provided references - Edit shading and lighting for natural appearance - Slight cropping and resizing to fit website specifications Important: - Final images required in JPEG format - Color references will be provided with Pantone images, RGB and Hex Codes - Detailed cropping and resizing instructions will be supplied - Required to allow multiple rounds of edits if needed to get the color/shading right Ideal skills and experience: - Proficiency in image editing software (e.g. Adobe Photoshop) ...

I'm seeking a reliable and professional driver for daily pick up and drop off to the office. Urgently hiring a personal driver in ABU DHABI who will drop off me to the office (pick up from home in Raha Beach at 9.15am) and pick up me from the office (Mussaf...from home in Raha Beach at 9.15am) and pick up me from the office (Mussafah ICAD) at 6pm every day 5 days a week. The rest of the day he can be absolutely free. Requirements: - Vehicle: The driver must use a Sedan. - Passengers: The driver will only need to accommodate 1-2 passengers. - Duties: The driver’s only responsibility is driving, with no need for assistance in loading/unloading items or running errands. Ideal Skills: - Experience driving a Sedan. - Excellent driving record. - Punctual and reliable. - Pro...

We're seeking a talented designer to create a visually engaging website and mobile app. The ideal candidate should have a proven experience in Figma and a strong portfolio showcasing their ability to design user-friendly interfaces and focus on optimizing the user experience. We are running a design agency and need some extra resources.

...be populated on the calendar. Calendar Subaccounts: We’ll have one umbrella account that the corporate team has access to. Each generated calendar will be created as a subaccount. Subaccounts should not be able to view other subaccounts. Google Apps Script is a potential tool to help accomplish this. Calculated Spend: The “Total Budget” cells in the Master Sheet tab will sum the spend of each area of marketing. The minimum spend for a Grand Open is $5,000, the total budget should require the minimum or at least notify the user if the spend is too low. Post-Mortem Meeting Notification: Each store will meet with the marketing team after their opening to conduct a post-mortem analysis. The marketing team should be Here is a sample document

I'm looking for a skilled developer who can integrate the Square API with a Google Sheets dashboard to display real-time sales data. Key deliverables: - Pull sales data from the Square API - Update the Google Sheets dashboard in real-time - Track specific metrics: Total sales amount and Number of transactions Ideal candidates should have: - Experience with API integrations - Proficiency in Google Sheets - Understanding of sales metrics - Ability to ensure real-time data updating.

...previous work with steel and metal enclosures in your proposal. 1. Steel Posts Description: Structural steel posts for the enclosure frame. Specifications: 4"x4" square steel tubing. Wall thickness: 3/16" or 1/4". Length: 8 feet each (to include 1.5 feet embedment in concrete). Quantity: Corner posts: 4. Mid-support posts: 4 (2 on each long side for additional support). Hinged gate posts: 2. Total: 10 posts. 2. Steel Base Plates Description: For securing posts to the frame (except hinged posts). Specifications: Material: 1/4" thick galvanized steel. Size: 6"x6" or 8"x8". Pre-drilled holes: For 1/2" anchor bolts. Quantity: 8 (for non-hinged posts). 3. Hinged Post Anchors Description: Embedded steel sleeves for hinged gate posts. ...

We’re running into a problem with provider blocks in our business. What we’d like to do is identify the countries of users’ IPs when they log in to our site. If their IP is from a country on our blacklist, we want to automatically redirect their traffic through a proxy or a similar solution that changes their IP to one from whitelisted regions like South Africa, Colombia, Finland, or others. Basically, we need a way to make sure all traffic from blacklisted countries goes through trusted IPs. We’re open to your suggestions on how to best handle this. I'm looking for a professional who can assist me in setting up a proxy solution to redirect traffic. The main purpose of this project is to bypass certain restrictions. We previously hired a developer wh...

...Expectations The website should have a modern and intuitive design, ensuring it’s easy for users to navigate. The AI model should be able to generate highly personalized and accurate itineraries. Please ensure the website is mobile-friendly and scalable for future features. If this project aligns with your expertise, please provide a detailed proposal with your timeline, required resources, and total cost. Looking forward to hearing from you....

I'm seeking a content creator with a knack for SEO and an understanding of the young adult demographic. The goal of the website is to build brand awareness, so the content needs to be creative, engaging and convey our brand message effectively. Key Requirements: - Create SEO-optimized, engaging content for 6 website pages. - Deliver a total of 500-600 words across all pages. - Adhere to a budget of 2500Rs. - Content should be readiblity passed, Human written no AI generated, and plagiarism free The ideal freelancer for this project will be able to understand and write for a youthful audience, using a creative and engaging tone as opposed to a formal and professional one. Please only bid if you can deliver quality work within the budget.

After upgrading from JSF 1.1.0 to JSF 2.2.0, my JSP screen is displaying twice upon initial load. This issue is isolated to a specific JSP page, and no recent changes have been made to the JSP or its associated Java code. We are currently running on java11 and tomee8.0.6 server. Ideal Skills: - Extensive knowledge of JSF and JSP - Proficient in Java and familiar with Java 11 - Experience with debugging in tomee server - Strong problem-solving skills and attention to detail

Looking for a Consultant to Launch Amazon FB...items. The scope of this project includes: • Store Setup: Launching stores on Amazon FBA, Etsy, and eBay from scratch. • Product Sourcing: Identifying and sourcing the right products to sell. • Sales Strategy: Boosting sales through effective research, marketing, and advertising strategies. • Brand Development: Working closely with me to establish and grow a recognizable brand. Budget: The total budget for this project is between $3,000 and $5,000, including all costs. I am looking for someone with a proven track record in e-commerce and dropshipping, who can guide me through the process and work hands-on to ensure success. If you’re interested, please share your expertise, past successes, and how you can...

...Windows-compatible Power BI optimization plugin. Key Features: - The plugin should detect all open Power BI files and identify all tables and measures within those files. - It should generate an optimized M query that includes only the used columns in the selected table. - The plugin must create optimized DAX code for the selected measure. - If the data source is an SQL database, the plugin should generate an optimized SQL query with only the utilized columns. Optimization Goals: - The primary optimization criteria for M queries is to minimize data load time and reduce memory usage. Platform: - This plugin is exclusively for Power BI Desktop. Ideal Skills & Experience: - Proficiency in C# and experience with Power BI. - Understanding of M query and DAX code optimi...

I'm looking for an AutoHotKey, PowerAutomate or Macro Express professional to create a script for simulating mouse and keyboard events. Key Requirements: The script should capture events from a foreground window and replicate them in a background window with a 10-second delay maximum. e,g - we have two ms paints running, we draw something on a ms paint in foreground, the same is automatically drawn on mspaint in background. - this can happen with 10second lag or less - both background and foreground windows are maximized. Ideal candidates should have significant experience with AutoHotKey, and ideally have previously developed similar scripts. Good understanding of Windows applications and ability to implement variable time delays is a must.

I'm looking for a skilled web developer to help me convert my old website entirely into Oxygen Builder. Currently, the site is running WP Bakery on top of Oxygen Builder, which is functional but not ideal. I have both a live site and a development site available for this task. Key project goals: - Complete conversion to Oxygen Builder to simplify site maintenance. - Update the site’s design, particularly the layout structure. Ideal skills for this project: - Proficiency in Oxygen Builder and WordPress. - Strong web design skills, particularly with layout structures. - Experience with site maintenance simplification. Please note, while I want to update the layout structure, the project's primary goal is to maintain the current design overall. We are going for mo...

I'm seeking an expert who can help me understand the RWKV-LM repository on GitHub as well as get it running on my Linux machine. Requirements: - An in-depth explanation of the code. I need to understand the technical details thoroughly. - Setup of the model on my machine, including the training and testing components. - Focus on language generation during the training and testing phase. Ideal Skills: - Proficient in Linux with experience in setting up machine learning models. - Deep understanding of the RWKV-LM codebase. - Excellent teaching skills with the ability to explain complex technical details in an understandable way.

I'm in need of a seasoned C#/.NET Full Stack Developer. Although specifics weren't mentioned, I'm open to discussing web application, desktop application, or API development. The ideal candidate would be proficient in: - C# and .NET Framework - Full stack development - API integration and development Experience with SQL Server, MySQL, or NoSQL databases would be beneficial. Please feel free to propose suitable frontend technologies, but proficiency in React, Angular, or Vue would be a plus.

...and embedding it in the XML file. • Adding tests (Unit Tests or Integration Tests) to ensure system readiness before launch. 2. Documentation: • A brief explanation of how to run and approve the modifications. • Any additional requirements for setting up keys. 3. Ensuring no errors: • Verifying there are no integration errors (API) or formatting errors (Schema) in the invoice files. • Running all the ZATCA requirements completely. • High performance speed. • The code will be checked after delivery to verify performance and security. Deliverables • A fully integrated E-Invoicing system: capable of creating simplified or standard invoices that include all required elements from ZATCA. • Error-free XML files (verified using o...

...Excellent Restaurants in Bangkok in different categories: - 2 traditional Thai - 1 seafood - 1 vegan - 1 meat-based 2. 3 Reliable Luxury Transportation Services from Bangkok airport. 3. 3 Luxury Hotels and 2 Villas suitable for a family of 5 guests, including a family assistant. This comprehensive list is ready for your review, and I’d be happy to assist further with any additional details. Total Cost: $30 USD Looking forward to hearing from you! Regards, Beverly Galit...

I'm in need of a highly organized and proactive personal assistant to help me manage various tasks. The role involves: - Scheduling and Calendar Management: Keeping track of appointments, meetings and important dates. - Errand Running and Shopping: Picking up groceries, gifts, and running other errands as required. - Administrative Support and Paperwork: Assisting with paperwork and other administrative duties. This position requires the assistant to work at various locations, not just at home or an office. Therefore, a willingness to travel and a valid driver's license are essential. The frequency of assistance needed is 'as required'. This could fluctuate depending on my schedule, so some flexibility is appreciated. Ideal candidates for this role s...

I need a proficient web scraper to extract 30,000 datasets from a single German fashion website. This includes product names, descriptions, prices, and product images (approximately 4 images per product, around 30 kB each). Key requirements: - Meticulous attention to detail to ensure accurate data capture - Experi...single German fashion website. This includes product names, descriptions, prices, and product images (approximately 4 images per product, around 30 kB each). Key requirements: - Meticulous attention to detail to ensure accurate data capture - Experience with handling images during data scraping - Ability to deliver clean, well-organized data The final dataset should be delivered in either CSV or SQL format. Please be prepared to demonstrate your previous work in web...

Anurag is being hired to design and build with , Node, and Mongodb—additional tools such as Tailwind CSS, Typescript, etc. We'll use Github, Vercel, and AWS for hosting purposes. The project total is $1200 with milestone deposits of $250 every two weeks until completion. If the project is not completed by Anurag for any reason, he will provide a full refund of the entire project.

Netflow project milestone first for the following project completed (1) Add dynamic and adaptive modes (2) Add covert communication channel through flow warden between covert sender ,covert receiver. (3) Repeat point 2 for packet warden and NEL phase env covert sender and receiver. (4) Take sample measurements to validate your modifications (5) Create a detailed documentati...communication channel through flow warden between covert sender ,covert receiver. (3) Repeat point 2 for packet warden and NEL phase env covert sender and receiver. (4) Take sample measurements to validate your modifications (5) Create a detailed documentation of work done so far relating to flow warden until now. First milestone payment is 650€ and second milestone payment is 600€ making a grand tota...

...a Bitcoin payment gateway to allow customers to pay directly with Bitcoin. Ensure transaction and user data security. Ensure a smooth user experience (UX) for both customers and site administrators. Implement a product and order management system for running the e-commerce platform. Expected Features: 1. E-Commerce Platform: Development of a fully functional e-commerce website with the following features: Product catalog: Display products with images, descriptions, prices, and filters. Shopping cart: Add products to the cart and calculate total costs. User registration: Allow customers to create accounts (optional but desirable). Admin panel: A backend for managing products, orders, customers, and transactions. Search functionality: An advanced search system for easy produ...

Running and manging ads on meta and googIe

I need assistance editing my AutoCAD files. This project involves modifying plumbing, electrical, and building plans based on my hand-drawn sketches. The total area of the plans is approximately 150 square meters. You will receive: - AutoCAD files that need to be edited - Hand-drawn sketches in DWG format Ideal skills and experience for the job: - Proficient in AutoCAD - Experience with interpreting and editing architectural plans - Familiarity with plumbing and electrical schematics - Able to work with DWG files

...Experience in SFDC APIs, SOSL, SOQL, SOAP or REST based web services, SQL, XML, and JavaScript. Experience working with Salesforce communities, Apex, SOQL, Visual Force, Lightning, JavaScript, Eclipse IDE, Workbench, Data Loader, Ant tool, Reports and Dashboards. Hands on experience with Apex programming and Visualforce pages coding. Strong knowledge of Salesforce Platform and is hands-on. Good understanding of integration and database. Certifications – Platform Developer 1, Platform Developer 2 (preferred). Skills & Requirements Salesforce, Service Cloud, Apex, Visualforce, SOQL, SOSL, SFDC APIs, SOAP, REST, JavaScript, Lightning, Salesforce Communities, Eclipse IDE, Workbench, Data Loader, Ant tool, XML, SQL, Reports, Dashboards, database integration...

Create a .Netcore Razor Pages solution connected to SQL. It is for handling work orders in a workshop. An order will be assigned to a mechanic. The equipment or machinery is registered. The items to be used to control the inventory and materials are added. It must be able to record comments. And it must have a reporting session. The equipment and machinery must be registered and the maintenance dates stored. --- Crear solucion en .Netcore Razor pages conectado a SQL. Es para manejar ordenes de trabajo en un taller. Se asignará una orden a un mecanico. Se registra el equipo o maquinaria. Se le agregan los items a utilizar para controlar el inventario y materiales. Debe ser capaz de registrar comentarios. Y debe tener una sesion de reportes. Los equipos y la maquin...

I'm working on a school project and I need someone proficient in Trunit to help with data validation. The primary task will be validating database records. Ideal skills and experience for the job include: - Proficiency in Trunit - Experience with data validation - Familiarity with SQL and NoSQL databases - Ability to work on a school timetable

Necesito que alguien me realice un conversor BC3 a JSON y me pase el código para integrarlo a mi software. Adjunto archivo con extensión BC3 y los datos que necesitaría obtener son: Capítulo, subcapítulo, título partida, descripción partida, mediciones (total, título, unidad, ancho, largo, alto, total parcial) y anotaciones o descripciones que pueda llegar a tener el archivo. Desde ya muchas gracias

This project involves the design, modeling, and simulation of three doors to withstand air speeds while ensuring structural integrity. Our team will utilize advanced eng...and Bill of Materials (BOM), to facilitate accurate fabrication and installation. Deliverables 1. Detailed 3D models of the three doors 2. FEA simulation reports ensuring structural integrity 3. Optimized design parameters for the doors 4. Construction plan and dimensioned drawings Project Timeline - 3D Modeling: 2 days - FEA Analysis: 2 days - Optimization: 1 day - Construction Plan: 2 days Total Project Duration: 7 days Acceptance Criteria The project will be considered complete when the designed doors meet the required structural integrity and air speed resistance criteria, as demonstrated through FEA si...

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

I'm looking for a talented full stack developer to create a running website. The site should be optimized for all platforms - Desktop, Mobile, and Tablet. Key Features: - User Authentication: The website must have a robust user authentication system. - Profile Management: Each user should have their own profile where they can track their running stats, connect with friends, and share their progress. Ideal Skills: - Full Stack Development: Proven experience in full stack development is crucial. - Responsive Design: The ability to create a fully responsive website is a must. - User Authentication Systems: Prior experience with implementing user authentication and profile management systems is highly preferred.

I need an experienced professional to help with my Proxmox box, which is running a Debian OS and hosting my iRedMail server. The current issue involves replacing the expired Let's Encrypt certificate and ensuring it's set up for automatic renewals. Key Requirements: - Troubleshoot server's inability to communicate outbound. - Fix connection issues to certain websites. - Review and adjust custom rules on my Firewalla Gold firewall if necessary. As the management method for my Let's Encrypt certificates hasn't been set up yet, I would appreciate your expertise in selecting and implementing an appropriate client for this task. Ideal Skills: - Proxmox experience. - Debian OS proficiency. - iRedMail server knowledge. - Firewall configuration and troubleshootin...

...email). Subscription type (simple, referral, gift). Payment source (web or mobile). Expiry date. Grant Free Subscription Allow admins to grant free subscriptions to any user for a specified duration. Subscription Stats Display the following statistics in the admin panel: Number of Active Subscriptions: Total number of subscriptions currently active. Total Subscriptions: All subscriptions purchased (active + expired). Recurring Clients: Number of users who renew subscriptions. Total Revenue: Total earnings from subscriptions. Split Payments: Breakdown of payments split between the vendor and referees. Generate Referral Code Generate a referral code with discount in % and assign a user to it. Backend Requirements RESTful APIs Create Subscription Record API Tr...