Simple running total count sql view 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.
3D Project tweak and rendering, single view
...kaupan integroimista ulkoasuineen en hallitse. UPDATE: I have a website , I have built it with wordpress 5 and elementor pro. I have basic knowledge about installing and maintaining the website but need help integrating woocommerce and building simple product catalog. For example this website of my competitor has quite simple catalog for used (brokerage) and new boats: Also this one is something I have been looking for: They have also a simple configurator for new boats: Something in these lines :) Or we could make the website from the scratch if it is easier!...
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 ;)
2 usd simple job.2 usd simple job.2 usd simple job.2 usd simple job.2 usd simple job.
simple jobsimple jobsimple jobsimple jobsimple jobsimple jobsimple job
Simple VHDL taskSimple VHDL taskSimple VHDL taskSimple VHDL taskSimple VHDL taskSimple VHDL taskSimple VHDL taskSimple VHDL taskSimple VHDL taskSimple VHDL taskSimple VHDL taskSimple VHDL taskSimple VHDL task
I am preparing for an SQL interview and need guidance to sharpen my skills, particularly focusing on SQL queries and syntax. I consider myself proficient with complex queries, but I specifically need help with subqueries. Ideal freelancer should have: - Extensive experience with MySQL - Proficient understanding of SQL queries and syntax - Strong skills in teaching and interview preparation Please be ready for a 1-hour session focused on enhancing my capabilities in handling subqueries and overall SQL interview preparedness.
We have a current issue with our PBX and our Ubiquiti UDM Pro. When running the PBX on our internal network with the Ubiquiti, our desk phones on that server do not work properly. We can make outgoing calls, but incoming calls do not ring on the phones in the office. This issue only occurs on our internal network with our desk phones. Interestingly, the softphone app we use works fine. However, we have 2 Yealink phones and 1 Grandstream phone, and all 3 can make outgoing calls but do not ring for incoming calls. Additionally, on the Yealink phones, in the BLFs, we can see the other phones, but they are displayed as offline; perhaps this is a clue that can help resolve the issue.
I need an audio engineer to improve the clarity of a voice recording made in a home environment. The project requires an expert with experience in audio enhancement and who can deliver high-quality sound. The ideal candidat...recording made in a home environment. The project requires an expert with experience in audio enhancement and who can deliver high-quality sound. The ideal candidate will have strong skills in audio processing software and a keen ear for detail. I'd like background hum removed, spaces and hesitations edited out and a clearer, sharper vocal if possible. Sample is attached. It's about 3 hours in total, currently split into 6 files. Alternatively, if my budget is too small, I'd like the sample done with instructions on how I can reproduce what you...
...dynamic slider showcasing services (e.g., aircraft sales, charter bookings). Quick links to key services (fuel, sales, charters, FBO, financing, crew). Aviation Fuel Services: Real-time fuel pricing and availability. Simple form for fuel requests. Interactive map showing fuel suppliers. Aircraft Sales Listings: AI-driven marketplace with filters (e.g., price, aircraft type, location). Detailed listings with high-quality images, specs, and pricing. Predictive pricing insights. Charter Services: Easy booking interface with transparent pricing. AI-optimized route suggestions. Calendar view for availability. FBO Services: Streamlined booking for ground handling, hangars, and VIP terminals. Real-time status updates for services. Aircraft Financing: Clear presentation of financi...
...log in to personal accounts, view their reward points balance, and use these points to purchase physical items in an online store. Key Requirements: - Setting up a store on Wix where students can use their points to 'shop.' - Implementing a personal account system where each user has a unique profile and a reward points balance. - Developing an admin interface for me to add or deduct points from each user's account manually. - Integrating the points system with the store so users can redeem their balance for products. - Ensuring everything is functional, user-friendly, and secure. Important Note: The most critical aspect of this project is the seamless integration of the store with the reward points system. For user authentication, I only require a simpl...
I'm looking for an expert in Power BI and SQL Server who can assist with data integration and transformation. Key Responsibilities: - Integrate various data sources into SQL Server - Transform and prepare data for analysis Ideal Skills: - Proficiency in Power BI and SQL Server - Experience in data integration and transformation - Strong analytical skills Please note that specific data sources and transformation tasks may be discussed further. Your ability to handle and manipulate complex datasets will be crucial for success in this project.
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
I need an experienced professional to install openmaint along with its dependencies like GeoServer and BIMSERVER on my existing Ubuntu server. The server is already running nginx and php-fpm perfectly. Key Requirements: - Ensure there are no conflicts with the existing functional nginx system for other sites on the server. - Set up openmaint in a way that allows for on-the-go edits, without using Docker. - Use Tomcat for openmaint installation. - Work should be done via Anydesk, not SSH, for security and clarity reasons. The server currently has: - No version control system for the openmaint folder. - Java 11 as the installed Java Development Kit (JDK). GeoServer does not need any specific custom configurations, a default setup is fine. Ideal Skills: - Proficient in Ubuntu ser...
I'm looking for an expert in Power BI and SQL Server who can assist with data integration and transformation. Key Responsibilities: - Integrate various data sources into SQL Server - Transform and prepare data for analysis Ideal Skills: - Proficiency in Power BI and SQL Server - Experience in data integration and transformation - Strong analytical skills Please note that specific data sources and transformation tasks may be discussed further. Your ability to handle and manipulate complex datasets will be crucial for success in this project.
I'm looking for an expert in Power BI and SQL Server who can assist with data integration and transformation. Key Responsibilities: - Integrate various data sources into SQL Server - Transform and prepare data for analysis Ideal Skills: - Proficiency in Power BI and SQL Server - Experience in data integration and transformation - Strong analytical skills Please note that specific data sources and transformation tasks may be discussed further. Your ability to handle and manipulate complex datasets will be crucial for success in this project.
I'm looking for an experienced Power BI professional to create a dynamic user dashboard. Key features of the project: - Create a Power BI icon that can be used by ea...professional to create a dynamic user dashboard. Key features of the project: - Create a Power BI icon that can be used by each user based on their computer login (e.g., DoH). Each computer is assigned to one owner. - Bind each username to specific database parameters (like Personal ID and Job Title) - Incorporate SQL data visualizations into the report (including joins, left joins, and right joins) Ideal Skills: - Extensive experience with Power BI - Proficient in SQL Database - Strong data visualization skills Please note: - I will provide an example for discussion - You must have access to Power B...
I need someone to convert my IDB files into an SQL dump file. The source database is Mariadb and the task requires a direct conversion without any data transformation or cleaning.
Link to channel I'm looking for a seasoned YouTube marketer who can help me increase my subscriber base. My target audience primarily consists of professionals and industry experts. Link to channel http...and reach. - Strategize and run advertisements effectively to attract new subscribers. - Create engaging content that resonates with my target audience and encourages them to subscribe. Ideal Skills: - Proven experience in YouTube marketing. - Strong connections with influencers in the professional and industry expert space. - Excellent content creation skills. - Proficiency in strategizing and running advertisements on YouTube. If you're passionate about YouTube and have a track record of helping channels grow, I'd love to hear from you!
...driver availability & location. • Live trip modifications (e.g., change pickup times, cancel trips). ✅ Automated Route Optimization • Uses Google Directions API to generate optimized routes. • Real-time traffic adjustments to reduce delays. • Supports multi-passenger trips (patients traveling in the same direction). ✅ Driver Monitoring & Tracking • Live GPS tracking for active drivers. • View driver workload & trip acceptance rates. • Send manual trip reassignment notifications if needed. ✅ Medicaid Billing Integration • Generates Medicaid-compliant trip logs for reimbursement. • PDF/Excel reports for billing & claims submission. ✅ Driver Pay & Earnings Tracking • Implements the hybrid pay model. ...
Temporary assignment Social Media Page Monitor! ? I need to build like minded friends on face book. Please explain your approach and the quickest amount of time to achieve total 4000 Seeking a social media person to skyrocket my community to 4,000 friends! If you have a knack for creating engaging content and growing online communities. About Me: I operate cutting-edge digital marketing educational platform that empowers entrepreneurs through a multi-level marketing (MLM) structure. Our platform is designed to educate on effective digital strategies and provide the tools for massive growth in any online business. Ideal Candidate: You should be familiar with MLM giants like Beachbody, Primerica, and Herbalife Nutrition and possess a proven track record on facebook social me...
...your favorite food? Rana: My favorid food is Indonesian food. 9. Asking and Giving Opinion Asking and giving opinion adalah ungkapan yang dipakai untuk meminta pendapat atau memberi pendapat. Contoh ungkapan untuk meminta pendapat di antaranya, yaitu: What do you think about…? What do you think of…? Do you have any opinion on…? What is your point of view? Sedangkan contoh ungkapan memberi pendapat di antaranya yaitu: ●I think…. ●In my view.. ●In my opinion… ●I feel…. ●It seems … ●I don’t think ….. Agar lebih paham, simak percakapan berikut ini: Sara: What do you think about this skirt? Sofi: I think it’s too short for you. Sara: Do you think so? What about this one? Sofi: Yeah, I think that’s bett...
I have a custom JavaScript hash function which I need converted to Python. I will send $10 to the first person who messages me the required Python function. I will test out the results against a series of strings including "a?b/3" to ensure that the output. **Note: It must also work with unicode characters. I'm attaching a screenshot of a required string to test, as Freelancer's formatting removes the unicode character.** Below is the given JavaScript function: ===== function generateHash(str, hashLength) { let hash = 2166136261; for (let i = 0; i < ; i++) { hash ^= (i); // XOR with char code hash += (hash << 1) + (hash << 4) + (hash << 7) + (hash << 8) + (hash << 24); // Mix bits } const base36Value = (hash) % (36 *...
...procesamiento de grandes volúmenes de datos. Se requiere un enfoque técnico y detallado para garantizar que la información fluya de manera fluida, precisa y oportuna, utilizando las mejores prácticas de integración de datos. Requisitos Técnicos: Amplia experiencia en integración de bases de datos y soluciones de análisis de datos. Conocimientos sólidos en SQL, así como experiencia en la conexión y gestión de bases de datos relacionales (MySQL, PostgreSQL, SQL Server, etc.). Dominio en el uso de herramientas y tecnologías de integración de datos (ETL, APIs RESTful, Web Services, etc.). Experiencia en la configuración de entornos de acceso seguro a bases de datos, inclu...
We are looking for an experienced Asterisk/VoIP developer to build a self-hosted multi-agent power dialer with Telnyx integration on our Ubuntu server. The system should include call retry logic, voicemail drop, text drop, and agent-based call routing. Current Setup: • Telnyx account with multiple numbers. • Ubuntu server running Apache with Asterisk installed. • Need a full VoIP infrastructure setup and agent management system. Project Requirements: 1. Dialing System Features: ✅ Dialing Modes: Power Dialer, Multi-Line Dialer, Predictive Dialer. ✅ Call Retry Logic: • Call once → If no answer, call again. • If still no answer, drop voicemail and/or send text message (if enabled). ✅ Voicemail Drop: Custom per agent. ✅ SMS/Text Drop: Configurable per a...
I'm seeking an experienced Oracle DBA to install a database patch for timezone 43 instead of 32 on my Oracle 19c Database, which is running on Linux. The database currently has multiple patches installed. Key Requirements: - Proficient in Oracle 19c with extensive DBA experience - Familiar with Linux operating systems - Proven track record of installing database patches - Ability to work with databases with multiple existing patches Please provide your credentials and examples of similar projects you've completed.
Seeking an experienced Wordpress developer to convert an existing HTML site into a fully functional WordPress website. The ideal candidate should be proficient in WordPress development and familiar with various plugins, particularly for enabling PayPal integration. This project requires attention to detail and the ability to ensure that the new site retains the original functionalit... including addition of logo and colours. Plugins need to be enabled in the relevant part of the theme. Paypal testing and integration required. I have already installed the WP theme and the relevant plugins. Only apply if you have a strong background in WordPress and are comfortable with programatic HTML to Wordpress conversion and WP customisation. Skills required - HTML 5, CSS3, Wordpress, SQL, PH...
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 ...
Looking for a highly creative Social Media Content Creator & Manager (Facebook, Instagram, LinkedIn, Etc.) to increase our brand’s online presence, drive engagement (Followers, Likes, Views), and attract new leads/customers. Must have experience running SEO, SMO, and potentially Paid Social Ads to increase traffic more quickly. NOTICE PLEASE READ: I am setting this up first as a one time project to hire someone to create 5 new pieces of content to be posted across each platform to test out who I decide to hire first. If everything looks good & things progress well after this I will then hire you to work for me full time on an hourly basis. Company Overview: Quanturra is a financial and business consulting company specializing in business funding, credit repair,...
We are currently seeking a skilled professional for a virtual data entry role. Below are the job requirements and expectations: Primary Respons...setting. • Familiarity with remote access software such as AnyDesk or TeamViewer, as the work will be done on our computer. • Availability to work between 10:00–11:00 AM Vancouver time (Pacific Daylight Time). Additional Real Estate Skills (Preferred): • Ability to search for properties for clients. • Knowledge of CRM (Customer Relationship Management) software, including entering campaigns and running them effectively. If this opportunity aligns with your skills and availability, please respond to this email with your resume, a brief introduction, and confirmation of meeting the above requirements. We look fo...
I am looking for a skilled web developer to create a simple yet modern and clean website. The main feature of this site will be an interactive map of the United States. Key Features: - Selectable states: The map should allow each state to be selectable. Once a state is selected, it gets centered and enlarged. - Detailed city/county view: Once a state is focused on, all cities and counties within that state should be visible. - ISP Listings: Upon selecting a city, a list of all internet service providers (ISPs) should be displayed. The ISPs need to be categorized as local, regional, or nationwide. - Redirecting Links: Each ISP listed should be selectable and, when clicked, redirect to their respective website. - Ad Space: The site will have certain ISPs branded with their na...
...see red highlighted area. Deliverables, at least 5 pictures: A Exterior concept drawing that highlights the building on the water view from across the river, see pic of example "Water2" (with the new 14 story project). B Exterior concept drawing from a birds eye view featuring the building in the foreground with the downtown in the picture, see pic of example "overview4" with red circle of the proposed project area C Design concept of Activating the Riverfront, a pedestrian/bike/small vendor area along the road that will be closed: between the proposed apartment building and the water. See picture 'bike path below surface road3'. D Anticipated view of looking from the proposed project out towards the river, see example pict...
Looking for a creative restaurant QR code design we'll print onto stickers. Goal: Simple, yet effective to drive app orders. 2" w x 3" h Attached: Brand Guide, QR code, previous qr design, inspo Copy: VIEW MENU & ORDER [QR] FOOD & DRINKS For Delivery or Pickup
...public page Subscription Plans We offer three subscription tiers with both monthly and yearly plans. There is no free plan, ensuring that all features are accessible only to paying members. Includes up to 20 links User Dashboard Features The user dashboard is accessible only after subscription payment is confirmed via Stripe. Key features include: Subscription Status Display: Users can view their subscription type (monthly or yearly) and current billing status directly from Stripe integration. Link Management: Links are numbered for easy organization. Users can add links (up to their plan limit) with a maximum click limit per link. A delete button allows users to remove links as needed. Only the top link will be clickable; the rest will remain grayed out. ...
Quotation for 1. Creating posters for instagram 1080x1080 size. Creating and posting 15 posters per month including description and tags on alternative days. Cost per poster 300/-. So the total amount per month for poster uploads 4500/- 2. Running ads on instagram on alternative days. Estimated reach 3k-6k Followers depends on the content More Traffic to website / instagram page is targeting. It will automatically increase sales and bookings. Running ads for 15 alternative days Cost per day 300/- So the cost for 15 days will be 4500/- Client should provide us the idea or content for creating the posters like like captions, informations, offers, discounts etc... Once the design is ready, only minimal changes by the client accepted. Need payment for the first 1...
I need a flyer designed to attract new customers. The flyer should be 5" X 8.5" and it needs to follow the brand colors. You can find the information that needs to be on the flyer at the link below: Key Requirements: - Design a simple, yet effective flyer - Adhere to brand colors - Include all relevant information from the provided link - Incorporate company contact details I will pay $20 CAD for this project. Please do not ask for more. This is a straightforward task and I need it completed as soon as possible. Thank you.
I'm in need of expert photo editing services for my electronics e-commerce product photos 7 in total). THIS NOT A LOGO CREATION PROJECT. This is for the editing of realistic images. The editing will include: - Background removal: Making the images clean and focused solely on the product - Color correction: Ensuring the colors are accurate and appealing - Shadow enhancement: Giving depth and realism to the images - Product placement: Strategically positioning products for optimal presentation - Object removals and additions: Modifying the image to enhance the visual appeal The final product photos should reflect a 'Natural and realistic' style. Ideal candidates should have a keen eye for detail, experience in e-commerce photo editing, and the ability to create high-q...
The goal of this project is to significantly speed up an already existing data import script (see ). The steps needed to import the data consist of: - Setup t...provide you with the postgres init script, see ) - Downloading/fetching the large ±24GB .JSONL data dump - Importing and converting this single .JSONL-dump into two postgres tables running in a docker container Requirements: - The resulting tables should be exactly the same as when you run the original import script. - The import time should be significantly reduced compared to the import time of the original import script using the same hardware requirements. - It should be easy to run everything: clearly document how to run it How you achieve this is completely up to you (Bash + SQL, pure SQL, Pytho...