Variable column count sql punët
Pershendetje Glen. Jam e interesuar per ndihmen tuaj ne SQL. Do te me duhet ndihma jote ne nje provim neser. A mundeni te me ndihmoni me nje shume prej 10 euro per 1 or e gjysem?
Programing in Dot Net & SQL Server. Visual Studio 2010, SQL Server 2012 Express ose më të avancuar. Modify existing modules, add modules, design interface, Reports...etc
...section (or entire side - like the attached sample Example 2) for our testimonials. We'll use variable data for the testimonial text based on our seller's avatar (see Target Groups image for testimonials). We'd like three different testimonial images: Anglo (white), Latino, and African-American. We will use different images based on the zip codes and the prominent ethnicity in the area. Our business is data-driven so we can target our customers based on problems we know they're facing and have solutions for them. In the Example 1 card, you can see where it says "We can help with: <STATEMENT 1>, <STATEMENT 2>, <STATEMENT 13>. Please see the Targeted Messages image to see some of the variable data that will be placed in this s...
...email inbox in order to geocode the addresses present in the file via the Google Maps API and insert the geographic coordinates into an SQL table. You can follow these steps: 1. Retrieve the xls file from the mailbox - cron every hour 2. Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL table. Each line in the xls file corresponds to a delivery. The file has 15 columns. The column names are, in order: Shipment, Rush order, Mode of delivery, Drop sequence, PP number...
I need assistance with scraping data from a website and delivering it in an Excel file. The specifics of the project are as follows: I am looking for a person who will conduct scraping sessions for our business on a regular basis. Desired skills are knowledge of screen-scraper software, sql, Someone with Python knowledge will be better. Willing to follow instructions. Not cramped up with other jobs or other side hustles. Need to have solid internet connection. Expected work takes 5-10 hours per week, once fully trained. Must be responsible. Able to accept PayPal. - The source of the data is a website. This means the freelancer needs to have experience in web scraping. - The data should be delivered in an Excel file. Proficiency in handling and formatting data into Excel is a mu...
Data Specialist: The Data Specialist is responsible for pr...information that is in databases, organizing and assembling the information so that teams can make decisions using data. Responsabilities: > Access database. > Create dashboards and analysis according to the demand of the business areas. > Update and automate dashboards that need frequent updating. > Provide suggestions of improvements in business areas. Requirements: > Mandarim is a must > SQL > Office Package > Database usage At Shein, we believe that diversity is the force that drives innovation. We are committed to creating an environment where all voices are heard, valued and respected. All our vacancies are inclusive for people with disabilities, women, black people, LGBTQIAPN+ com...
I need a skilled professional who's an expert in Azure Data Factory (ADF) development, SQL, Power BI, and ADF monitoring. Key Tasks: - Creating data pipelines - Building data transformation workflows - Integrating with SQL databases Power BI Usage: - Visualizing data through interactive dashboards - Creating data reports and analytics - Real-time monitoring and alerts ADF Monitoring: - Tracking data pipeline performance - Monitoring data integration processes - Setting up alerts and notifications for job failures. Ideal Skills and Experience: - Expertise in Azure Data Factory (ADF) development - Proficiency in SQL, Power BI, and data visualization - Strong background in monitoring ADF performance - Experience setting up real-time alerts and notifications - Pr...
I'm currently s...Short circuit protection * Cell balancing * Reverse polarity protection - The system should allow for charging and discharging through the same port I need this project to be completed within a month. Ideal skills and experience for this job include: - In-depth knowledge and experience in BMS design, particularly with LiFePO4 batteries - Proficiency in creating flexible BMS systems with variable ampere capacity - Extensive experience with temperature monitoring, short circuit protection, cell balancing, and reverse polarity protection - Ability to deliver the project within the stipulated timeframe - Strong problem-solving skills and attention to detail. Please provide a detailed proposal if you believe you have the necessary expertise and skills fo...
I'm seeking an independent ASP.NET developer based in India with at least 5 years of experience, strong C# programming skills, and familiarity with SQL Server and Asp.net core. Your English skills will be crucial as direct communication with me is required. Key Responsibilities: - Develop a robust business management system leveraging ASP.NET - Implement user authentication and authorization features - Integrate appropriate APIs to enhance system functionality Ideal Candidate: - Minimum 5 years experience in ASP.NET development - Proficient in C# programming and SQL Server - Familiarity with Asp.net core - Experience in developing business management systems preferred - Strong communication skills for client call Please note that this project is only open to Indian-ba...
...on TikTok. You will need to reach out to the KOLs on the list and ask them to accept business partnership. We provide them with the free sample product, they will use it, and make a video to sell the product. KOLs will get 20% of sales as commission. They are risk free. The risk is on us: they agree and make committment, but just don't make video after they received the products, which doesn't count a job done. For this task, you need to have a strong understanding of influencer marketing on TikTok, a good network of influencers, and experience in outreach and negotiation within the beauty and personal care niche. It will be a bonus if you have experience working with influencers from different age groups and have a good eye for identifying influencers who will be a ...
As a business that primarily gains leads through referrals, I'm eager to expand my reach with effective Facebook ad campaigns. I'm keen on briskly escalating my lead count. To achieve this, I seek a Facebook Ads expert with a proven track record in lead generation. Key tasks: - Design targeted Facebook ads to draw potential clients. - Track and adjust campaigns according to performance. Ideal Skills: - Experience in creating high-converting Facebook ad campaigns. - Proficiency in lead generation strategies. - Strong problem-solving skills to identify and fix poorly performing campaigns. - Extensive knowledge of Facebook Ads Manager. Is this your skillset? Bid on this project, and let's take my business to the next level.
I am presently seeking a highly skilled freelancer for an email extraction project from two highly popular social media platforms - Facebook and Instagram. Key Project Specifications: - Scrape email addresses from both Facebook and Instagram. - Selection of the profiles for scraping should be primarily based on the following criteria: levels of user engagement and followers count. - Along with the email addresses, extract additional user information namely: the account name and its location. Ideal Candidate Profile: - Must have experience in deducing complex social media algorithms. - Understanding of digital privacy laws to ensure compliance during the extraction process. - Fluency in software that can automate this extraction process would be advantageous. My ultimat...
... The role may also involve programming. Key points: - Coaching: I need 1/1 coaching via Teams on Data Analysis & Data Visualization within Azure Analytics - Programming: If the opportunity arises, the candidate could get involved in programming using SQL - Proficiency: I consider myself at an Intermediate level with Azure Analytics Ideal Skills and Experience: - Proficient in Azure Analytics: You should have a strong understanding of Azure Analytics, specifically in Data Analysis and Data Visualization - SQL Programming: Experience with SQL is a must as you may be involved in programming for this project - Teaching or Coaching Experience: Prior experience in teaching or coaching Azure Analytics would be advantageous - Strong Communication: The ability to clear...
I'm currently using a Python scraping bot for my project, but I need to make some adjustments. Key Requirements: - The primary modification involves segmenting the scraped data by day. To achieve this, I would like to have a timestamp column added that differentiates data on a daily basis. This will allow me to have a better understanding of the data collected each day. Your Proposal: In your application, please provide a detailed project proposal. I'm interested in freelancers who can clearly articulate how they will approach this task and ensure its successful implementation. Ideal Skills and Experience: - Proven experience in Python scraping bot modification - Familiarity with data segmentation and timestamping
A business-centric, data-oriented, and analytical mindset. Comprehensive knowledge of data science concepts and disciplines. Knowledge of enterprise information management processes and methodologies. Skills in database design, data security, and data lifecycle ...considerations. . Combinations of experience and education will be considered on a case-by-case basis. Experience in data warehousing and governance. Practical experience in enabling data usability, availability, and efficiency. Experience in data management, quality, metadata management, and modeling. Knowledge of database systems: MS SQL Server, Oracle, or another commercial RDBMS required, Snowflake, or other non-relational database desired. Knowledge of SQL. Experience with scripting languages, especially Python...
I am seeking a native English speaker to review and evaluate three articles written in English by a non-native speaker. The total word count for all three articles is approximately 6,000 words. The articles cover the topics of traveling. Responsibilities: - Read all three articles - Evaluate the language quality of each article, including flow, grammar, vocabulary, and style. - [Main Task] Assess the likelihood that a native English reader would recognize that the articles were written by a non-native speaker. Note that you don't have to write/rewrite anything. All you need to do is to provide your feedback and assessment.
I'm in need of a skilled developer who is experienced with inventory management systems, report production, analytics, user access control, and Windows-based applications. This job involves maintenance of a warranty return tracking software, with specific attention to: -...considered a plus. The overriding purpose of this software is to track and manage warranty returns effectively. Ideally, you should have previous experience in software creation and maintenance for tracking and managing products. The purpose of this project would be Bug fixing and improvement of the software tool already existing. Required: Experience with ER Models architecture Experience with MS SQL server 2017 express as DBMS Experience with Python 3.8.3 and Tkinter GUI toolkit Experience with Powe...
As someone who needs bilingual copywriting for my emails and messages, here's what I'm looking for: 10 years+ experience in copy wr...candidate should have strong writing skills in both languages and a deep understanding of cultural nuances. - The main task would be creating email and message templates. The templates should cover different scenarios and they should comply with professional etiquettes. - I have some specific examples or templates for the messages and emails I need. I will provide these for reference, although I count on your creativity to bring a fresh perspective. The job would suit someone with previous experience in bilingual copywriting, particularly those who have previously written emails and messages in a professional context. Strong communicatio...
I'm looking for a skilled Magento 2 developer who can help me with a couple of issues I'm facing on my website. - The first concern is related to JavaScript errors. I'm encountering undefined variable errors, syntax errors, and function not defined errors on the browser console. These errors seem to be causing some functionalities on my website to malfunction, and I need someone who can quickly identify the root cause and provide a solution. - The second issue is regarding CSS layout problems. My website is not displaying properly due to CSS issues. It seems like the layout is not consistent across different pages. The ideal candidate should be able to fix these CSS problems, ensuring a smooth and consistent user experience. Ideal skills and experience: - Proficie...
Need to convert text file to a clean page and remove the colums showing passwords.
I need an adept SQL developer proficient in crafting SQL queries for various tables within our database. The task entails generating four queries, each encompassing approximately 20 conditions that must be met. Utilizing ChatGPT, could you assist in devising these queries?
I'm seeking an experienced Excel guru to help create / identify two specific formulas on my spreadsheet. This project is URGENT. The right excel Guru can probably figure this out in less than an hour. Easy money. The first formula is related to searching a cell for one of four words and populating an adjacent column with a correlating value, based on the word found. The four words to be searched for are "Low", "Medium", "High", and "Not currently a priority". The adjacent cells are to be populated with correlating values 1, 2, 3, and 0 (to generate a Score). The cells are currently blank, and users of the spreadsheet will fill these cells by selecting from a drop-down list (of these 4 words). The objective is to create a formula that co...
I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles. - Medium-sized project: The data needing in...
I need a simple, single-column WordPress site set up with the following requirements: - The site will need to be built from a provided WP demo content folder, including plugins and theme. - The main content will be of a standard, text and image-based nature. - The site design should be a straightforward single column layout. For this project, you would need: - Proficient skills in WordPress - Experience with SCSS - The ability to set up a local site - Familiarity with migrating WordPress sites Please ensure you can work with the provided WP demo content folder as the basis for the site.
...focus is on expenses. Here is what I require: - Just the expenses data extracted from the Excel file and made available for the creation of a pivot table. - You'll need to determine the format of the data in the Expenses column. Your skills and experience: - Advanced knowledge of Microsoft Excel, especially in working with different types of data. - Proven experience in handling financial data, specifically expenses. - Ability to interpret varying formats of data on Excel. - Good problem-solving abilities, given that the specific format of the data in the Expenses column wasn't provided. If interested, please provide a portfolio showcasing your past work relating to Excel and financial data management. Your ability to deliver quality and accurate work will b...
Note: Budget Fix 2000INR and time line 5 Day's I have a project currently in Codeigniter 3, and I'd like it converted to Laravel 10. This pro...will require thorough understanding of both frameworks, and it's crucial that all existing features and functionalities are precisely replicated in the new version. While I don't have specific features to prioritize, I will identify specific elements as the project progresses. Skills and experience required: - Profound knowledge in Codeigniter 3 and Laravel 10 - Expertise in PHP development and SQL databases - Proven experience in similar conversion projects Note: The finalized budget for this project is 2000INR. Please only bid if you can work within this budget. The timeline for project completion can be discussed d...
Please make wordpress site as atteched image. 1 column and respoinsive design.※If possible,bootstrap design. Anything is include dummy text and dummy images. I make inquiry and faq,sitemap page by myself and send you wordpress login details. Required Pages:Top page,fx,crypto-ex page,1 currency detail page Please make within $120(absolute requirement) and delivery within about 2 weeks and give me a progress report every about 4 days. I think only the table part is a little more challenging.
I'm in need of skilled manufacturers to create top-notch stonewashed cotton bed sheets for single and double sized beds. Bed sheets will have a key difference where they have a zip connecting them together, unlike anything currently on the market. Applicants should have experience in textile manufacturing, specif...stonewashed cotton bed sheets for single and double sized beds. Bed sheets will have a key difference where they have a zip connecting them together, unlike anything currently on the market. Applicants should have experience in textile manufacturing, specifically with the production of cotton bedding items. Knowledge in thread count specifications and bed sizing is a must. Expected deliverable is high-quality, durable, and comfortable bed sheets made of 400-500 threa...
...high-complexity T-SQL stored procedure used for data analysis that I need translated into PySpark code. The procedure involves advanced SQL operations, temporary tables, and dynamic SQL. It currently handles over 10GB of data. - Skills Required: - Strong understanding and experience in PySpark and T-SQL languages - Proficiency in transforming high complexity SQL scripts to PySpark - Experience with large volume data processing - Job Scope: - Understand the functionality of the existing T-SQL stored procedure - Rewrite the procedure to return the same results using PySpark - Test the new script with the provided data set The successful freelancer will assure that the new PySpark script can handle a large volume of data and maintai...
Our ex...script is encountering issues when importing the exam's section breakdown from a .dat file. Due to this, we are unable to import the breakdown of results per section of the exam into the SQL database. We are seeking a proficient developer who can: - Analyze our existing CGI script and identify the cause of the breakdown import issue. - Provide actionable advice and steps to troubleshoot and resolve the problem. - Ensure the script effectively imports the section breakdown from the .dat file as intended. The ideal candidate for this project should have: - Extensive experience in CGI scripting and SQL database management. - Proficiency in handling and troubleshooting data import/export issues. - Ability to work quickly and efficiently, as we need thi...
...on TikTok. You will need to reach out to the KOLs on the list and ask them to accept business partnership. We provide them with the free sample product, they will use it, and make a video to sell the product. KOLs will get 20% of sales as commission. They are risk free. The risk is on us: they agree and make committment, but just don't make video after they received the products, which doesn't count a job done. For this task, you need to have a strong understanding of influencer marketing on TikTok, a good network of influencers, and experience in outreach and negotiation within the beauty and personal care niche. It will be a bonus if you have experience working with influencers from different age groups and have a good eye for identifying influencers who will be a ...
...Development: Use HTML, CSS, and JavaScript for the frontend, with frameworks like React or Angular to enhance the user interface. Backend Development: Python with Flask or Django for server-side logic, handling API integrations, and user data management. Machine Learning: Use TensorFlow or PyTorch for building the recommendation engine, and NLTK or similar libraries for sentiment analysis. Data Management: SQL or NoSQL database to store user profiles and their preferences. Version Control: Git for source code management and collaboration. Submission Requirements: Code: Source code with comprehensive comments detailing the functionality of each part of the system. Documentation: A detailed documentation covering the system design, implementation details, and instructions for setti...
...warehousing, ad hoc reporting, complex SQL formation, and more. The primary purpose of the project is to streamline and enhance our data storage capabilities. By integrating new data into our warehouse on a monthly basis, we aim to improve our decision-making and business performance through enhanced data access and analysis. Key responsibilities include: - Reviewing and providing recommendations on the SOW for data warehousing - Offering expertise on ad hoc reporting and complex SQL formation - Helping to streamline data storage and improve decision-making - Ensuring the architecture can support monthly data integrations Ideal candidates should have: - Proven experience as a data architect - Expertise in data warehousing and ad hoc reporting - Strong SQL skills,...
I need a competent translator who can translate text from Polish to English. The content of the text is non-technical and non-legal in nature, falling under the general category. - Unknown Word Count: The exact word count isn't clear, so please be prepared for flexibility in this regard. - Page Range: The text that needs translating is estimated to be between 1-5 pages in length. The ideal candidate will be a native English speaker who is also proficient in Polish, with experience in translation work. Reliability and commitment to deliver quality work are also important.
...up-to-date with the latest trends and technologies in database management and architecture. Skills and Qualifications Bachelor's degree in Computer Science, Information Technology, or a related field. Master's degree preferred. 8+ years of total experience. Minimum of 5 years of experience in database architecture and development, with a focus on Netezza and Oracle. Proficiency in SQL and PL/SQL programming languages. Strong understanding of database design principles and data modeling techniques. Experience with database performance tuning and optimization. Excellent communication and leadership skills. Ability to work effectively in a fast-paced environment and manage multiple priorities. Relevant certifications in Netezza and Oracle te...
...down -if you mess up, that is OK, but then you must edit the video. (there is no negative to a video with many edits/cuts) If you rehearse it 2X and then record, it takes about 11 minutes. Total time to perform is approximately 35 minutes... So less than 1 hour Here is the google sheet that is a "conceptual guide". For each row, it tells you how many signs are needed for that row (See” count" column).... (many are done with LEFT and RIGHT hand). In some cases signs are moving vs static and it shows you the "States" of the specific sign. Again, this is a conceptual guide but the example video is what you want to use as a reference. https://docs.google.com/spreadsheets/d/14PJe9FmxsQXvaq-Rm7r1MjD0AjMEfFHocKeVYDtQTDg/edit#gid=10251319 ...
I'm seeking a talented professional to help me grow my Telegram channel. Here are some key details: - **Goal**: My primary aim is to increase the subscriber count of my channel. You will be focusing on developing and executing strategies that directly contribute to this goal. - **Target Audience**: My channel caters to adult content consumers. Therefore, your methods will need to be tailored to attract this specific demographic. - **Strategies**: Your role will involve utilizing a combination of paid advertising and cross-promotion with similar channels to help attract more subscribers. - **Skills and Experience**: I'm looking for someone with a proven track record in growing Telegram channels, particularly those targeting niche audiences. Experience with adult content pr...
Looking for a Senior BDA with experience in. AZURE SQL SERVER. English mandatory. 1d per week helping to improve and maintain our main DBs.
...representing personnel move in real-time.] Narrator: "With our real-time digital twin feature, supervisors can track personnel movements, muster points, and evacuation routes, all from the palm of their hand." [The animation seamlessly transitions to a scene where a person equipped with a BLE tag enters a floor, passing through BLE gateways. In Restrata’s Connected Site, the Personnel on Board (POB) count is instantly updated to reflect their presence.] Narrator: "Watch as our integration with BLE technology accurately updates POB counts in real-time as personnel move within the facility." [The animation showcases a scenario where an incident occurs on-site. The supervisor receives an alert on their mobile device, and they quickly locate affected perso...
...PÍXEL: <img src="${CONVERSION_ID}&orv=${ORDER_VALUE}&cli=${ICLID}&orc=EUR&ver=4.31" width="1" height="1" border="0" style="display:none;"> NOTAS SOBRE LAS TAREAS A REALIZAR: En el pixel el "cid", debe recoger el ID del pedido, mientras que "orv", debe recoger el valor del pedido sin gastos de envío ni impuestos., la variable que se llama "cli" y esta recoge el iclid que estamos creando con la cookie. Hay que modificar la sintaxis del lenguaje y utilizar la que corresponda a Prestashop. Estas tareas preferimos que se realicen a través del Google Tag Manager....
...developer. To qualify you must be full stack and conde in . , .NET ASP WEB API + MS SQL Details of our current project STACK can be seen here -> Prerequisites: For this optimization task you can bid your normal hourly rate but for the long term project the starting wage will be as stated below. 1) Accept initial hourly rate of U$5.00 2) Accept and start work immediatly 3) Have MINIMUM OF 20+ hours a week for long term ongoing support and development. 4) If you are awarded the project accept IMMEDIATELY 5) Work hours: predominantly 20:00 to 02:00 (UTC -3 Brazil TIME) 6) Be available to work on weekends. Our projects use: GITLAB -> , ag-grid, C#, .NET API, MS SQL 2017 , WooCommerce digital product sales This is for ongoing long term development and we
I am looking for a cloud engineer who can assist with deploying an ASP.NET Web Form application on a Windows Server 2022 on VPS. Key Requirements: - The SQL Server DB and ASP.NET Forms have already been set up on the VPS Windows Server 2022. The main task is to ensure the successful deployment of the ASP.NET Web Form application. Additional Details: - The cloud provider I am currently using is WABYNE. Ideal Skills and Experience: - Proficiency in cloud engineering and deployment processes. - Experience with ASP.NET Web Form applications. - Familiarity with Windows Server 2022 on VPS. - Knowledge of SSL certificate installation, database configuration, and firewall settings is a plus. Please provide your relevant experience, certifications, and portfolio when applying. Your app...
I'm looking for an experienced app developer to create a versatile webapp for both iOS and Android, with the following key features and functionalities: - The webapp should have a hybrid design, but I'm not sure yet if it will be a hybrid app or separate apps for iOS and Android. Your insights and expertise in this regard will be greatly appreciated. - The prim...Android platforms. Ideal Skills and Experience: - Proficiency in app development for both iOS and Android - Previous experience with webapp development - Understanding of hybrid app development - Knowledge of user-friendly design and user experience - Ability to optimize apps for iOS and Android platforms If you have any questions or need more details, feel free to ask. Website url will be variable and i want ...
I need a proficient developer to create a custom inventory management system that directly caters to the needs of supply chain managers. The following details explain my project requirements: Required Features: - The inventory management system should effectively track inventory in real-time - Maintain up-to-date inventory count instantaneously to avoid running out of stock - Implement intermediate level alerts for low stock to enable proactive inventory replenishment Skills and Experience: - Proven experience in developing inventory management systems is crucial - Understanding of supply chain operations will be beneficial - Demonstrable knowledge in establishing real-time tracking and alert systems The main aim is to optimize inventory control, minimize stockouts, maintain th...
...data analyst with proficiency in SQL and R for a comprehensive evaluation of a recently completed data analysis project. This project requires a review of SQL queries, R scripts, and database connections as detailed in a provided PDF. If you're ready to start right away and can deliver within 24 to 48 hours, please get in touch. Responsibilities: Conduct a thorough review of project requirements as specified in the PDF. Evaluate the accuracy and efficiency of SQL queries and R script implementations. Verify database connections and the effectiveness of data visualizations. Identify any discrepancies or areas for improvement. Deliver a comprehensive report detailing findings, issues, and potential improvements. Requirements: Demonstrated expertise in SQL...
...seeking a skilled full stack developer to help with a web application project that I'm working on. The ideal candidate should be proficient in JavaScript and .NET, with specific experience in Angular and SQL Server. Key Skills and Experience: - Proficiency in JavaScript and .NET. - Strong knowledge of Angular and SQL Server. - Previous experience in developing web applications. - Ability to work collaboratively in a team setting. Responsibilities: - Develop the front-end using Angular. - Design and maintain the back-end of the application using .NET. - Ensure seamless integration of SQL Server for database management. - Conduct thorough testing to guarantee the application's functionality. This is a great opportunity for a skilled full stack developer t...
...and converting it into JSON format. The PDFs, such as the example provided here, vary in format and column structure based on their categories. The solution should not require downloading the PDFs manually. Sample URLs Requirements: - Develop a tool or API endpoint for extracting data from PDF files located at given extracted PDF table data into JSON format. - Handle various PDF formats with different column structures. - Preferred tech stack: PHP (Laravel), Node.js, or Python. - Ensure robust error handling
Fix related issue in the module. Authentication, column view issue. Able to follow to fix one by one and with ftp
