How to get row count of multiple tables in sql server 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ä.
JAVA J2EE Advance java core java hibernate struks rest soap
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
I want SEO done on page for google.se. Key words: segla i Kroatien, båtcharter Kroatien, segelbåt Kroatien, hyra en segelbåt i Kroatien.
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 ;)
Minulla on jatkuvaa työtä, joka liittyy aikaisempaan projektiimme 'HTML- AND SEOEXPERT GET´S THE JOB!'
I'm encountering an issue when forwarding emails to a PHP script on my cPanel email server. I need a professional to debug and resolve this problem. Key Responsibilities: - Identify and troubleshoot the error in the email forwarding process - Implement a working solution to ensure emails are successfully forwarded to the PHP script that starts with #!/usr/local/bin/php Requirements: - Experience in working with cPanel email servers - Proficiency in PHP and scripting languages - Strong debugging and troubleshooting skills Communication: - Please message me through Freelancer.com's platform Looking forward to working with an experienced professional who can swiftly resolve this issue.
I'm in need of a proficient digital advertising and e-commerce specialist to build, implement, and supervise digital advertising campaigns across multiple platforms. The core focus will be on Facebook Ads, Google Ads, and Instagram Ads. Here's a brief of what I require: - **Campaign Management:** The specialist is expected to develop and manage advertising campaigns on the aforementioned platforms. - **Target Audience:** The campaigns are specifically aimed at business professionals. The specialist must be able to tailor strategies and content to engage this audience effectively. - **E-commerce Optimization:** The candidate is also expected to optimize our e-commerce channels with the goal of enhancing convers...
...skilled Python developer to create an Ant Colony Optimization (ACO) algorithm that can read numbers in a matrix to calculate the shortest distance and its respective cost. Key Features: - The algorithm should respect origin and destination points, which will be indicated by specific row and column numbers. - Ideally, the code should be able to parse a .xlsx file format. Desired Skills: - Proficiency in Python programming language - Experience with optimization algorithms, particularly the Ant Colony Optimization algorithm. - Familiarity with .xlsx file parsing. I already have a basic code and can provide it to you as reference material; however, I need someone to improve and expand on this code to meet the requirements....
As a growing brand, we're seeking a skilled video editor to help us create captivating video content for our various social media platforms (Instagram, Facebook, TikTok) as well as our website. Job Description: Freelance Video Editor for Social Media and Web Overview: We are looking for an experienced and creative freelance video editor to enhance our video content for Instagram, Facebook, TikTok, and our website. This long-term collaboration involves transforming short video clips, approximately 30 seconds each, into polished and engaging content. The successful candidate will regularly handle 2-7 video projects per week and is expected to add significant value by improving video and sound quality, integrating texts, and employing impactful visual effects. Res...
...seeking a proficient expert with skills in APA 7th edition format for configuring research tables. Even though proficiency in APA 7th edition standards is paramount in this project, having an insightful understanding of data organization and presentation will be appreciated. In this project, efforts will be channeled towards changing 7 existing SPSS tables to match APA 7th edition requirements, including double-spacing, 12 point-font, Times New Roman font style, and, if needed, notes under the table or necessary italicization or bolding of headers/keywords. Manual entry of descriptive text and data values to form each independent table is needed. In other words, raw data cannot be provided to ma...
I'm in urgent need of a payment page for my WordPress website. I'd like the payment gateway to be integrated with Worldpay, Opayo, and Barclays. Key Requirements: - Create a payment page for WordPress - Integrate with Worldpay, Opayo, and Barclays - Ensure a seamless user experience - Support multiple currencies (if possible) I would need this project completed ASAP. Ideal Skills: - Proficiency in WordPress development - Extensive experience in integrating payment gateways, particularly Worldpay, Opayo, and Barclays - Strong UI/UX design skills to ensure a seamless user experience - Ability to work under tight deadlines and deliver high-quality work.
I need a pow...expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: -Retrieve product ID, Quantity and Location -Gather specific production data including the production number. Ideal skills: -Proficient in DAX query language -Comprehensive experience with Power Bi -Excellent attention to detail -Previous experience in inventory data management will be a plus. What to do: I need to get a query in DAX (Power Bi) that gives me the same result as what I show in the excel file ( table ( column in yellow)). The excel file was obtained from the attached SQL query () The two screenshots show the power bi tables. I need to get...
I am in need of a skilled Wordpress developer who can create a custom business website for me using Elementor Pro. This project includes: - **Design and Layout:** You will need to design a visually appealing business website that conveys professionalism and trustworthiness. It should have a responsive design that adapts well to different screen sizes. - **Color Scheme and Branding:** I have a preferred color scheme and branding elements. You will need to incorporate these into the design of the website. Ideal candidates for this project should have: - Proven experience in designing and creating functional business websites using Elementor Pro. - Strong skills in UX/UI design and understanding of best practices. - Good commun...
I require a skilled Flutter developer to resolve multiple issues prevalent within my application. These involve: Bugs and fixes 1. Remove the two onboarding screens designs 2. The "Support" page is a widget, not a Webview 3. Add "Events" icon on menu bar 3. Remove header area on "Activity" page 4. Change "Place Bets" text to "Banter" 5. Remove the image behind on the Swipe page 7. Remove the circled areas in "Wallet page" 8. Change app icon and app name. 9. Work on the amount filter on the Swipe page.
I'm searching for an individual who can help disseminate analysis and forecasts about a specific stock on Reddit, prima...information should be legal and compliant, with an emphasis on increasing public interest. Ideal candidates possess: - A firm grasp of Reddit's investor community culture. - Ability to construct competent and engaging market analysis. - Familiarity with individual investors' main concerns and interests. - A deep understanding of legal requirements pertaining to the sharing of stock information online. - Discretion to navigate multiple platforms if Reddit has maximized its engagement. Please note that our focus is solely on analysis and forecasts; company news and stock performance are secondary. Your in...
I am looking for a skilled developer to create a Windows-based application that can interact with a remote database. The application should primarily focus on retrieving and generating website sitemaps based on different criteria. The ideal candidate should have: - Proficiency in Windows application development - Strong experience in working with databases, particularly remote databases - Knowledge in data retrieval and data update functionalities - Ability to understand and incorporate additional requirements as the project progresses Please note that the selected freelancer may need to provide examples of past work and project proposals. Note: Application should be able to connect different type of databases such as MS ...
As a developer versed with JavaScript, your mission is to break down my comprehensive project code into distinct components and push them into multiple repositories on Git. Key Tasks: • Deconstruct the overarching JavaScript codebase into its constitutive components • Create separate repositories for each of these components on Git • Implement the Gitflow workflow throughout this undertaking Ideal Skills: • Strong competence in JavaScript programming • Familiarity with code decomposition and the Gitflow workflow • Experience with creating and managing multiple repositories on Git. Your expertise in JavaScript and meticulous Git management will be instrumental to the success of this project.
We are part of a worldwide network providing drug testing services. We have a presence in multiple countries. Our client wants us to conduct drug testing around Dungarvan, Ireland X35 T628. We will cover your travel expense. Training and materials will be provided. You will have to either go to the client's residence or office to collect the provided urine sample or rent a meeting room to host the session. Meeting room rental costs will be borne by us. Thereafter I will guide you on how to perform the testing hygienically and you will send us the result. We will compensate you for every test done.
I'm seeking an experienced...a much-needed refresh. The ideal candidate should be proficient in: - Layout and Design: Improving the existing layout and navigation is a key aspect of this project. We need to fix the dropdown menu and remove any empty spaces detrimental to the overall aesthetic. Your designs should be in line with a stylish yet professional corporate feel. - Mobile Optimization: The new design should be fully optimized for mobile use, ensuring seamless navigation for users across multiple devices. - Navigation: Clear and efficient navigation is crucial for our users. Emphasis should be on making ‘Services/Products’ effortlessly accessible. I’m looking for someone offering live support to remotely w...
I'm seeking a skilled IT Project Manager to assist with various tasks throughout the project lifecycle, on multiple concurrent projects. Key Responsibilities: - Project Planning and Scheduling: Your role will involve creating a project plan and timeline, ensuring all tasks are scheduled effectively. - Team Coordination and Communication: Overseeing a small team on each project, you will be responsible for coordinating efforts, facilitating clear communication, and fostering a collaborative environment. - Methodology Implementation: Implementing and adapting project management methodologies as needed to ensure project success. Ideal candidates should have: - Proven experience in IT project management - Strong skills in project planning, scheduling...
...will not be using all available features, but you can see the capabilities and features here: • Implement my custom Algorithm to calculate matches based on selected filters • Require Chat messaging • Modify software to allow user to record audio and send as message or leave as bio • Profile pic can only come from user camera, not gallery or pasting • Require Match alert notifications • User should be able to exclude matches based on any particular filter/option • PH7 BUILDER Software can create hundereds of fake profiles for testing purposes • Users with specific interests can also be discovered via a keyword/phrase search • Require Likes • Require Block/Report feature.
We are seeking a highly motivated and skilled Content Creator to join our team. The successful candidate will be responsible for creating 30 blog posts daily using ChatGPT technology. Each post should be meticulously crafted from scratch in Brazilian Portuguese and must include two images. The role also requires performing internal linking and formatting the posts using bold text, tables, and other elements to enhance readability and engagement.
I'm looking for a dynamic and capable programmer who is able to work with multiple programming languages. While I haven't specified a language of choice, versatile coding abilities are crucial for this project's success. Key Experience: - A breadth of experience across multiple programming languages is critical. - Preferably, candidates will have years of overall programming experience. Application Requirements: - When applying, please include a comprehensive rundown of your experience in coding and programming, particularly highlighting your range across multiple languages. The perfect candidate for this job will have broad experience and an adaptable skillset. We have a project that needa additional fun...
I require a Social Media Manager to oversee and boost my presence on Facebook, Instagram, YouTube, and LinkedIn. Primary responsibilities will be: • Formulating and implementing strategies to generate leads. • Developing and executing engaging product promotion content. The candidate must be proficient in managing multiple social media platforms, with a track record of lead generation and promoting products. Background in branding and a deep understanding of tailoring content to various platforms will be highly preferred. Knowledge of LinkedIn and YouTube management is a must.
...frontend developer to integrate ag-Grid into an existing application. The grid should be able to handle the following functionalities: - **Sorting**: The grid should allow users to sort the data in ascending or descending order based on specific columns. - **Filtering**: Users should be able to filter the data based on specific criteria to find the information they need efficiently. - **Pagination**: The grid should support pagination, allowing users to navigate through the data in chunks. The data for the grid will be provided through an existing API, so the successful candidate will need to have a solid understanding of API integration. User interaction is another key aspect of this project. I expect the ...
I am in need of a capable and creative graphic designer to tackle the responsibilities of logo design, branding design, and packaging design for my project. The designs will factor heavily into solidifying the brand identity and product packaging. While no specific style or theme has been chosen, adeptness in various styles and the ability to make strong style recommendations is a bonus. Skill and Experience: - Proficiency in logo design, branding design, and packaging design - Ability to conceptualize and execute strong brand identity - Creativity and a keen eye for aesthetics - Knowledge and experience in multiple design styles - Strong portfolio showcasing a variety of design work.
I'm seeking an Excel expert to create a user-friendly data entry workbook. The job is straightforward and requires the following: - **Data Entry:** The workbook should mostly focus on simple data, like names and dates. I am not looking for any intricate calculations, formulas, or pivot tables. The main focus is on creating an Excel workbook that streamlines the process of entering simple data in a structured and efficient way. Experience in creating user-friendly UX within Excel is a plus. No integration with external systems or services is needed - this is a standalone project. I look forward to collaborating with an experienced professional who can deliver an effective, easy-to-use data entry solution within Excel.
I need a PHP expert to integrate PayPal into my website for one-time payments. The system should ideally support multiple international currencies. Key requirements: - Integration with PayPal: The freelancer should have extensive experience with integrating PayPal into websites. - PHP expertise: The project requires a solid understanding of PHP to ensure the integration is smooth and effective. - International currency support: The ideal candidate will have experience in configuring PayPal to support multiple international currencies, as this is a key requirement for the project. Please share your relevant experience and a clear plan on how you intend to approach this project.
...proficient in React Native and equipped with experience in the development and integration of media streaming features for both iOS and Android platforms. The developer will be required to incorporate video and live streaming functionalities into the app. Key responsibilities: - Develop an app using React Native. - Incorporate video and live-streaming features. - Ensure the app is compatible with both iOS and Android platforms. Ideal Skills: - React Native development - Media streaming (video and live-streaming) - iOS and Android app development I am hopeful to have the project completed within a month. The perfect candidate will have a good understanding of using native mobile features such as camera recording and splitting screens for runni...
As the client, I require the services of a skilled copy typist who can accurately duplicate a PDF document. The original document contains tables, so a certain level of precision and attention to detail will be necessary. Your tasks: - Copy typing a PDF document - Transcribing tables as text - Ensuring 100% accuracy The ideal freelancer for this job has previous experience with copy typing and transcription, and is familiar with working with PDF documents and tables. A strong understanding of English and high attention to detail is imperative.
I'm in need of a proficient typer to execute a medium volume job, of between 100 and 500 pages. Here are the details: - You have to retype handwritten notes into a Microsoft Word document format. Accuracy and attention to detail are paramount, as the formatting needs to adhere strictly to the layout of Microsoft Word. - Although the task does not come with a tight deadline, efficiency in completing the job would be highly appreciated. - Experience in a similar role would be an advantage, as the typer needs to have stellar knowledge in document formatting and editing in Microsoft Word. This project does not require rush execution, therefore making it a perfect opportunity for those balan...
...seeking a professional who has experience in setting up Fresh Sales and integrating it seamlessly with Insightly. My specific requirements include building a customized sales pipeline, managing contacts and leads effectively, and generating comprehensive reports. Key Tasks: - Customized Sales Pipeline: I need the freelancer to design a sales pipeline that aligns with our unique business practices and sales processes. The pipeline should be intuitive and easy to navigate. - Contact and Lead Management: The professional should ensure seamless migration of data from Insightly to Fresh Sales. They must create an organized system for managing contacts and leads, including appropriate tagging and categorization. - Report Generation: I require the freelance...
I have the SQL file and main images of my current Wordpress site, and am looking for a professional to migrate and set it up on the new hosting account. We have the hosting account set up and will share the files with a dropbox link. Key Requirements: - Migrate current Wordpress site to a new hosting account - Setup and configure Wordpress in the new hosting environment - Ensure all site functionalities are working post migration - Provide login credentials for the access to Wordpress Please note: - There are no custom changes or updates needed during the migration - The new hosting environment is fully compatible with Wordpress Ideal Skills: - Proficient in Wordpress migration and setup - Knowledgeable in SQL databases and...
Graphic Design Brief for ™ Digital Marketing Assets Objective: To design and develop cohesive digital marketing assets that promote the ™ free trial across multiple platforms including Facebook, LinkedIn, and Google Performance Max campaign. The assets should consistently convey the all-in-one marketing software’s value and encourage users to sign up for a free trial. Target URL: Core Message: "All-in-One Marketing Solution - Start Your Free Trial Today" Call to Action (CTA): "Start Your Free Trial" Digital Asset Requirements Facebook: Cover Banner Size: 820 x 312 pixels Quantity: 1 Format: PNG Notes: Ensure clarity within Facebook layout. Feed Ad Graphic Size: 1080 x 1080 pixels Quantity: 1 Format: P...
I'm searching for an outgoing, eloquent individual to make calls to homeowners in New Hampshire, with a focus on selling our solar home improvement services. Responsibilities will include: - Communicating professionally to promote our product - Answering any questions homeowners may have about the service - Tailoring your sales pitch to persuade homeowners of our solar service's value It's essential that the candidate possess: - Exceptional communication and persuasion skills - Previous experience in telemarketing, preferably within the home improvement sector - Knowledge of solar energy systems and their benefits, as this will count heavily in your favor when conveying the product’s value ...
As the developer of an existing project written in Python, SQL Server, and MongoDB, I am currently facing a challenge. A logical error in the code is causing a bug, and I need an expert to fix it. High-level summary of the code- 1. Fetch records from SQL server ( total 680000 records) 2. Apply face recognition on each record 3. Insert the response from step 2 in MongoDB along with other data from the SQL server Issue- The existing code is currently doing steps 1 & 2 and performing step 3 at last when face recognition is applied on all records. Due to this it step 3 is waiting to complete the step 1 & 2. Expectation- After fetching each record from SQL server, the code ...
