Sql server select wheredela

- poslovna inteligenca na Microsoft tehnologij tako on-premise kot v Cloudu - Programski jeziki: DAX, MDX, C#, TSQL, SQL, python, spark

Potrebujemo programerja za občasne dodelave v okolju Microsoft dynamics CRM, office 365 z bazo Microsoft SQL. Plačamo po urnih postavkah.

Izdelava aplikacija (za začetek working verzija - brez avtomatskih in EndToEnd testov) za prikaz: -Drevesnih struktur iz sql tabel -Logiranje -Shranjevanje aktivnosti na drevesnih strukturah -Poročila -Komunikacija med uporabniki Več v priloženem PDFju. Gre za osebni projekt - ne predstavljam podjetja.

I'm seeking a skilled professional who can help me generate leads specifically for my E-commerce business based in the United States. My main goal is to increase sales and revenue through Google Ads and Meta Ads. Key Requirements: - Demonstrable experience in Google Ads and Meta Ads, specifically in the E-commerce & Leads G...strategy discussions. In addition to targeting the US market effectively, the ideal candidate should be able to fine-tune campaigns for optimal performance, ensuring that the generated leads are highly likely to convert into sales. This role is pivotal for our growth, and I'm looking for a results-oriented professional who can deliver. Please submit your portfolio's as well so that our team can select and interview according to your ex...

...name) is Yugantar Gupta. The book covers everything that a student needs to do to get the best course in exams the various exams that are covered include IIT JEE NEET CA CAT UPSC etc. The cover will include my photo. I have not yet got the photo clicked. Please put a model's photo in the cover design as a placeholder and I will get a photo clicked in the same pose based on whichever cover I select. If you have suggestions for what kind of photo will be best, feel free to include that I need both front and back. I don't want you to share perfect designs at this stage. Just the overall design should be excellent. I'm looking for great colour combinations, placement of various elements, tiny illustrations if needed, and a great photo pose that matches and integrat...

...user experience. Automated responses to user queries: The bot needs to be capable of responding to a series of predefined queries, providing quick and accurate information. - Broadcast messages to subscribers: I aim to frequently update and engage with my current customers, and the bot should be able to distribute messages efficiently. The robot sends information about specific products that I select It works on a subscription system Continuous interaction with the target website High speed and accuracy A system for sending messages to subscribers and non-subscribers. Work on lists that are organized and interactive The ideal candidate for this role would possess a blend of technical expertise in Python and a knack for user-centric design. This project has the potential to be a...

...to accommodate a multi-level structure to incentivize different tiers of referrals. - Direct referral bonuses: Ensure that users get rewarded for directly referring new participants. - Performance-based incentives: The system should be able to track and reward users based on their performance within the program. - Plan package stake: The stake plan should be constructed in a way that users can select different packages for staking. Ideal Skills: - Deep understanding of blockchain technology, particularly Binance Smart Chain and the BEP20 standard. - Experience in creating smart contracts for cryptocurrencies. - Prior involvement in developing referral programs. - Ability to create a stake plan that can accommodate different package options. - Strong communication skills and a co...

...both Canvas and Model-driven Power Apps. These applications should be designed to interface seamlessly with SharePoint and SQL databases. Key functionalities to be incorporated include; * Workflow automation: Our applications should aid in achieving seamless workflow, eliminating unnecessary delays and redundancies. * Data integration: Facilitating effective synchronization of data across different platforms and databases. * Document management: Applications developed should have mechanisms that streamline the creation, storage, and retrieval of digital documents. The ideal freelancer should possess a wealth of experience in Power Apps development, SharePoint, SQL, and proficiency in Power Automate. We're looking for a skilled individual who understands the intric...

Determine the right sensors and communication protocols to use in a particular IoT - reference Select from a range of possible technologies and appropriately deploy Cloud Services using different cloud - reference Implement security features to protect data stored in the cloud. MO3 - reference

...website). It should fetch the current Kitco market values and cache them as needed, possibly using a crontab. The output price is always for Fine Gold, 999. The customer should be able to select karat numbers such as 8K (333), 9K (375), 14K (585), 18K (750), 21.5K, 22K, etc., to display the current market price according to the karat numbers. It should display as follows: Estimated Value: [current market value] Maximum Pawn Amount: 50% of the market value It's important that no other API is used, but rather prices are fetched from kitco.com. Additionally, at the beginning, customers should be able to select Gold, Silver, or Platinum. These prices must effectively be queried from Kitco, with the output being less than 50%, just like with Gold. Furthermore, a visua...

I am working on React JS with Javascript Development Project. I need someone to Support me for this Project atleast 4 to 5 hours Per day. Project will Exist more than 2 years. I need support through Remotely(zoom). I am looking for Good Experienced(4+ years) Person as a Frontend Developer, Who can work on the tasks super...Quickly. I am looking for Long term relationship. After this Project Completed means, we will give immediately another support project. I will Give you the Sample Task on Cypress Unit Test Cases for 30 mins, If you Completed ON TIME means we will give you the Project. Cypress Unit Test Cases Immediately Required. Required Skills : React JS, HTML, CSS, Javascript, Cypress Test Cases(Mandatory), SQL Basics Language Speaking Person : English Note: I will pay on ho...

...interface for students in a school to have conversations with OpenAI through the school's OpenAI account and key (configurable through a file). Through this interface, students would log in with a given username, password plus a "Session ID" (they need a valid "SessionID" to log in. Once logged in, it should basically feel quite similar to ChatGPT where they can have a conversation with the AI. There should be a backend where an administrator can create teacher users and student users. The DB table for users would hold the teachers and students username and password and type of user (no identifiable information like actual names, last names or emails). There is a second "backend" which is for teachers. Teachers can log in with their t...

Ubuntu Apache Server Setup with PHP and MySQL

...experienced MERN Stack Developer with a minimum of 8 years of hands-on experience in the MERN stack (MongoDB, , React.js, Node.js). This role is critical for our recruitment process as we look to hire a talented Junior MERN Stack Developer for our in-house team. The primary responsibilities include conducting technical interviews and providing expert recommendations to help us identify and select the best candidates. Responsibilities: 1. Conduct technical interviews with potential Junior MERN Stack Developer candidates. 2. Assess candidates' technical skills, problem-solving abilities, and overall fit for the role. 3. Evaluate coding tests and project submissions to ensure candidates meet our technical standards. 4. Provide detailed feedback and recommendations to our HR te...

...my mobile detailing service. The app should be available on both Android and iOS platforms. Key Features: * Online Booking and Scheduling: Users should be able to conveniently book detailing services at their preferred times. * Customer Reviews and Ratings: The app should have a system for users to rate and review services provided. * Vehicle Registration: Users should be able to register and select their cars within the app. Ideal Proposal Includes: I am particularly interested in receiving detailed project proposals showcasing your understanding of this project and a roadmap to completion. Design Preference: I prefer a colorful theme with Red, Yellow, and Blue as dominant colors. Ideal Candidate: A freelancer who has experience in creating mobile applications with the requ...

...analytical and problem-solving skills. Strong communication skills, both written and verbal. Ability to work independently and manage time effectively to meet project deadlines. Preferred Qualifications: Experience with testing web applications in various browsers and devices. Knowledge of HTML, CSS, and JavaScript. Experience with bug tracking tools like JIRA, Bugzilla, or similar. Familiarity with SQL and scripting. What We Offer: Competitive project-based rates. Flexible working hours. Opportunity to work with a dynamic and innovative team. Potential for ongoing collaboration on future projects. If you are a meticulous QA professional with a passion for ensuring top-quality web applications and are looking for project-based work, we would love to hear from you. Please submit...

I am looking for a female voice artist who can create audio stories & JOI based on very erotic role-plays and fantasies. The voice should be original & seductive, and native to Hindi or Bengali language. The ideal candidate should have experience in voice acting and storyt...teacher-student, director-heroine, secretary etc. If you are a talented voice-over artist with a seductive voice and you are comfortable with adult erotic contents, then this project is perfect for you. Rest assured that your talent will be respected with an adequate payment. This is a personal project and your work won't be published anywhere. You need to send your voice samples so that I can select the right candidate. You should also include your comfort level in doing erotic voice acting with...

...Development: Implementing the design onto a live website. • Back-End Development: Ensuring the website runs smoothly and effectively. As this will be an e-commerce website, special focus must be given to online payment processing, shopping cart system, and product listing. Knowledge and experience with these items are vital to the success of this project. The final website should enable visitors to view, select, and purchase products effortlessly. Please showcase any related work in your bid....

...Development: Implementing the design onto a live website. • Back-End Development: Ensuring the website runs smoothly and effectively. As this will be an e-commerce website, special focus must be given to online payment processing, shopping cart system, and product listing. Knowledge and experience with these items are vital to the success of this project. The final website should enable visitors to view, select, and purchase products effortlessly. Please showcase any related work in your bid....

...Umbraco (Microsoft open-source CMS). - Backend: C# coding. - Database: MySQL. - Currently hosted on a Windows server with IIS. - **New Hosting Environment:** - Hostinger VPS with Linux OS. - SQL Server installed via command line (no GUI). - No Windows server or IIS available. **Issues Encountered:** - Umbraco runs well locally on the VPS but not accessible externally. - Unable to attach the website domain. - Issues uploading the website from a local machine to the VPS. **Requirements:** - Expertise in Umbraco CMS. - Strong knowledge of C# and MySQL. - Experience with migrating websites from Windows/IIS to Linux environments. - Familiarity with configuring SQL Server on Linux. - Ability to troubleshoot and resolve issues with domai...

A website used to be a WP site. It is now remade with and the new version is hosted on a new server. I need to retrieve the old information from the DB drop. When I try to add the database entries to a freshly installed WP installation and access it (either localhost or server) it immediately throws 301 error and redirects to the new kobe-oukoku website. Please add this text in the beginning of your application so I know you've read the description: kobe animal kingdom.

I'm in need of a fashion designer who specializes in adult clothing. The designs should be suitable for everyday wear. Ideal Skills and Experience: - Demonstrable experience in adult clothing design - A strong portfolio showcasing previous everyday wear designs - Ability to understand and interpret current fashion trends - Knowledge of materials and ability to select appropriate materials for wearable, comfortable garments - Excellent communication skills to understand and translate my vision into a tangible clothing line.

I require a skilled professional to build an Asterix server on a Windows platform. The primary role of this server will be to host a communications web application. Key Responsibilities: -Build an efficient Asterix server on Windows -Make sure it's optimally configured to host a communications application Ideal Skills and Experience: -Experience in building servers on Windows -Understanding of communications application requirements -Proven expertise in handling Asterix servers This is a challenging yet rewarding opportunity, requiring a deep understanding of both Asterix servers and communication applications. Bidders with relevant experience, showcasing their capabilities at managing the requirements, will get preference.

As a business owner managing my domain hosting on a different server, I am looking for an experienced AWS specialist to help me migrate to AWS. Key Project Details: - My primary purpose for migrating to AWS is to improve my site's performance. As such, I'm looking for a freelancer with demonstrated experience in optimizing and enhancing performance on AWS. Ideal Skills & Experience: - Proficiency in AWS services, particularly Amazon EC2 and Amazon S3 - Experience with server migration, ideally from another hosting provider - Demonstrated ability to improve website performance through cloud services - Strong understanding of security measures associated with AWS - Good communication skills to ensure a smooth transition and understanding of the process Please p...

I'm setting up a bike rental bus...business. The company will offer different types of bicycles such as mountain bikes, road bikes, and hybrid bikes. - The rental company will provide accessories like helmets and locks. - I need a professional who can create an online booking system for the bike rentals. The system should be integrated into our website. - This system should make it easy for customers to browse available bikes, select the ones they want to rent, choose any accessories they need, and make the payment. - The ideal candidate should have experience in e-commerce website development, with a specific focus on building booking systems. A background in the bike rental or similar industry would be a big plus. - I'm open to suggestions for the best approach to t...

...that I need. The data columns listed above will be need to be automatically pulled into tables and columns and stored in Microsoft Excel. I need to be able to use SQL or a UI and ultimately easily import/embed into Microsoft Excel - the data finally must be pulled into Microsoft Excel. The freelancer must be Proficient in working with Amazon Seller Central and pulling back the relevant info for comprehensive, robust reporting purposes. Understanding of reporting data from Seller Central data and experience in data reporting and data analytics. Also ultimately this data is to be stored into a database and to where I can use SQL to create queries and tables for dashboard reporting purposes. Your work will be crucial in creating and enhancing reporting for acce...

I'm looking for a talented Excel expert who can create a highly interactive and visually appealing budget analysis dynamic dashboard. - Highly Interactive Dashboard: Develop a dashboard that allows users to interact seamlessly with the data. This includes the ability to navigate between different views, select specific time periods, and drill down into detailed information. - Visual Appeal: Design visually appealing charts, graphs, and tables that effectively communicate key financial metrics. Utilize color schemes, fonts, and layout techniques to enhance readability and engagement. - Monthly and YTD Sheets: Incorporate tables of accounts for 12 months and year-to-date (YTD) sheets into the dashboard. Ensure that data from these sheets can be easily accessed and analyzed wit...

I'm looking for an expert digital artist who can alter an image to create a humorous bachelor party concept. Your task will be to perform face swapping and uniform modification to make it appear as if a particular person is donning JTAC gear. Key requirements: - Ability to select an appropriate photo for the edit - Proficiency in face swapping and image manipulation techniques - Experience in photo modification towards a military theme - Detail-oriented, ensuring the final photo appears professional Please note that it is a military-themed fun project, not intended for misuse. I encourage photoshop experts with a good sense of humour to place their bids!

I require a meticulous professional, experienced in the workings of Microsoft A...Solve data type mismatch errors, ensuring seamless data integration - Add some of the small functionalities to the application. - Need the full application to run smooth without errors. Ideal Skills: - Commitment to meet tight deadlines as an immediate resolution is vital - Prior experience in troubleshooting errors in Microsoft Access 2007 - 2010 - Expert understanding of database structures and Sql syntax Ultimately, the freelancer should bring this software application back to its most optimal version in the earliest possible timeframe. If you're that hands-on problem solver with a keen eye for detail, you could be just what this project needs. *Some of the sub-application the software has t...

Se requiere un sistema diseñado en Python que trabaje en sistema operativo Wndows, el cual a través del uso del WebCam pueda hacer reconocimiento de rostros comparando el rostro en la cámara vs el rostro almacenado en formato digital en una base de datos en SQL Server 2016+. El resultados debe ser un True o False. El sistema debe trabajar localmente (No en la nube).

Mevcutta hibrit bir uygulamamız var. Sql üzerinden veri çeken bir servis mevcut Bu projeye rapor eklenecek

...a folder structure on your computer to organize the images by product category (e.g., Shoes, T-Shirts, Sofas). Ensure you have a stable internet connection for browsing and downloading images. 2. Finding Images on Amazon: Go to Amazon. Search for a product category (e.g., "Men's Shoes"). Click on individual products to view their detailed pages. Select images that meet the quality and content requirements. Right-click on the image and select “Save Image As…” to download. Name the file appropriately (e.g., "") and save it in the corresponding folder. 3. Finding Images on Shopify: Go to Shopify. Browse through the "Examples" section or search for specific product categories. Click on stores or products that showcase...

I'm in need of an expert server administrator with extensive experience in Plesk to assist with the configuration and troubleshooting of my server. Key Responsibilities: - Server Setup and Configuration: The server is already fully configured, but I'm facing some severe issues. Your role would be to assess the current setup, make necessary adjustments and ensure that the server is running optimally. - Troubleshooting: The primary issue I'm experiencing is a DB query failed: SQLSTATE[HY000]: General error: 1 Can't create/write to file '/var/tmp/#' (Errcode: 2), query was: DESCRIBE `sessions`. Your expertise in diagnosing and resolving such issues will be crucial. Skills and Experience Required: - Proven experience in Plesk ...

My Apache Web server is not loading pages, but there are no error messages. I have checked and it is running and accessible. All pages seem to load to the default server page. The pages are running on Apache in Docker containers I need a skilled freelancer to help me resolve this issue. Ideal Skills & Experience: - Proficient with Apache Web servers - Troubleshooting skills - Understanding of server configurations -Work done AnyDesk, no SSH! Paying $15 Please bid if you have relevant experience.

This project needs a skilled professional who is highly efficient with dbt, Databricks, Snowflake, Google Cloud Platform (GCP), Python programming, and SQL database management. Responsibilities: - Execute data transformation tasks using dbt - Process and analyze data using Databricks - Handle data storage and querying on Snowflake - Manage cloud platform setup and tasks on GCP - Implement Python programming for data manipulation - Write and manage SQL queries and database Ideal Skills and Experience: - Prior experience in the same field - Intermediate level expertise in dbt data transformation - Knowledge of Python and SQL - Understanding of cloud architectures, particularly Google Cloud Platform - Familiarity with Snowflake and Databricks Applicants with su...

Having problems with Docker and need configurations 1 - 3 current running containers need proper ports assigned to them. The containers connect be lost as they are for production. 2 - set up and configure three additional separate Docker groups, each for a different entity which would contain sql, Apache, and file storage. Key Requirements: - Configure 3 isolated Docker groups for Entity A, Entity B, and Entity C isolated from each other. - The setup should be designed for scalability, load balancing, and security although specific requirements for each are not yet defined Ideal Freelancer: - Proven experience in Docker containerization - Familiarity with setting up and managing production environments - Strong understanding of port assignment and management - Capability f...

I need a simple C# Windows Forms management project. It has three classes: Service, Tourist and Tranzactions. It's for college and supposed to be for a tourism agency wanting to keep track of its services, tourists and tranzactions. Nothing complicated, a CRUD app connected to a SQL database, simple UI and the project has to meet the requirements from the screenshot attached below.

...our Windows Server 2022 RDP server. I need an experienced professional to fix this problem and make sure it doesn't recur. Key Requirements: - Diagnose and Resolve: You should be able to diagnose the root cause of the issue and resolve it efficiently. - Windows Server 2022 Expertise: You must have proven experience working with Windows Server 2022 environments and a deep understanding of its functionalities. - Troubleshooting Skills: Your troubleshooting skills should be top-notch to identify any underlying issues that may be causing the problem. - User Profile Management: You should be skilled in managing user profiles effectively to ensure a smooth and error-free experience for all users. I've already tried restarting the server, creating...

I'm looking to develop an on-demand service application that focuses on car services. Here are some key features I'm looking to include: - **User Registration and Login**: The app should have a smooth and secure user registration and login system. - **Service Provider Profiles**: It's important for users to be able to view and select service providers based on their profiles. - **Booking and Scheduling**: Users should be able to book appointments with service providers easily. - **Tracking**: It would be great if an in-app feature could allow users to track the status of their service requests. - ** Service Reminders: Automatic reminders for upcoming maintenance based on service history - ** Emergency Services: Provide options for emergency roadside assistance, such ...

I'm seeking an expert in Windows Server licensing to clarify some key points. - I have a single Windows Server, specifically Windows Server 2019 or 2022. - 5000 user accounts will need to access this server concurrently and they will use web application on Blazor Server. - I need advice on the appropriate licensing model to accommodate this level of usage. Ideal candidates for this project are professionals with: - Profound knowledge of Windows Server licensing, preferably Windows Server 2019 or 2022 - Experience with large-scale user access scenarios and concurrent usage. - Ability to explain complex licensing models in simple, user-friendly terms. What is cheapest model for me to utilize. People will connect to app using Chrome b...

I have a simple powerbi poject. I have a dataset in excel based on which i need a table in the dashboard. I also require a filter to filter the rows The filter should be based on 3 columns in the table. In the dataset a user can be in more than one column. for example lets say the 3 columns are A, B and C. the values can ...rows The filter should be based on 3 columns in the table. In the dataset a user can be in more than one column. for example lets say the 3 columns are A, B and C. the values can be A, B, C or blank in those columns. user X had values A, B and blank in the columns A, B and C In this case if you filter the data using value A from the dropdown, it should show user X also if you select B. However if you select value C in the filter the user/row wil...

I am in need of a data mining expert proficient in Python, machine learning, and Selenium to facilitate a data mining project. If you are interested, so there would be 2 contract fix rate $50/country flow, and $3-5/hr for code's maintainance. Depends on your profile’s experience. $5/script for easier works (like scrap-data transferring between GS&SQL), Purpose of the project: The primary objective is to extract valuable information from a large set of data. The specific type of data to be mined will be shared with the successful candidate. - Skills and Experience: - Proficient in Python - Hands-on experience with Selenium - Thorough understanding of machine learning algorithms - Experience in handling large sets of data - Strong knowledge of d...

DMS verfügt über drei Bereiche, die jeweils eigene Domains und Webseiten haben. Für diese Bereiche benötigen wir: a) SEO-Unterstützung, einschließlich Anpassungen für Google b) Pflege der WordPress-Webseiten sowie Aktivierung der Shop-Funktion Zusätzlich ist eine Zusammenarbeit mit externen Software-Entwicklern (Englisch) erforderlich,...benötigen wir: a) SEO-Unterstützung, einschließlich Anpassungen für Google b) Pflege der WordPress-Webseiten sowie Aktivierung der Shop-Funktion Zusätzlich ist eine Zusammenarbeit mit externen Software-Entwicklern (Englisch) erforderlich, die eine Software für die Ersatzteilverwaltung (sowohl Admin- als auch Client-Seite) betreut. Erforderlich sind auch Kenntnisse in der Software-Ins...

...dealing with customer data specifically. Tasks to be undertaken include - - Retrieving customer data from the database - Cleaning the data efficiently to ensure it is free from errors and inconsistencies - Analyzing the data to provide detailed insights - Demonstrating these insights through clear visual tools The ideal freelancer for this job would display deep understanding and experience in SQL to query and manipulate databases. Python scripting knowledge for data analysis and cleaning is a major plus. Proficiency in using data visualization tools like Tableau would also be beneficial in conveying the results of the database analysis. The ultimate goal of this project is to use data effectively to inform business decisions regarding our customer base. If you find you hav...

I'm in need of skilled SQL guru to support me with my project. Some of the tasks include handling database design, query optimization and data migration. Attributes and Experience Required: - It's essential you have advanced level SQL skills (more than 3 years experience). - Experienced in both basic and intermediate tasks, while also capable of tackling advanced tasks. - Database design and optimization expertise. - Proven track record in managing data migration. In your application, illustrate on your vast SQL experience. Share previous projects you've worked on. Proven expertise will be a determining factor for this job's selection.

I need to move my WordPress site, which is 8GB in size due to images and database, from one cPanel to another server. Key requirements: - The migration should be seamless and preserve all data, content, and functionality. - The site should be fully operational on the new server post-migration. Ideal Skills: - Expertise in WordPress site migration. - Proficiency in handling large-size migrations. - Strong understanding of cPanel and server configurations. Please provide prior experience with similar projects.

I'm in need of a website that can cater to new users and make scheduling appointments, managing user profiles, and processing payments an easy and seamless experience. Please go through figma file for detailed flow and screens of web needed. You can select react.js or any platform that will be easier for you.

I'm in need of an experienced application developer who can build a robust database application. The application will need to provide th...application must include a secure log-in mechanism for users, and feature robust access control settings to manage their privileges within the application. As for the type of data this database application will manage, this remains to be finalized. However, skills in handling different types of data - textual, numeric and multimedia - will be considered an advantage. Understanding of standard SQL language, knowledge with various database systems and strong problem-solving skills will be ideal for this project. Strong knowledge of frontend and backend development with user interface design skills will also greatly contribute to our collabo...

Hello, I want a development. I want a touchscreen interface to control a custom vending machine. I need someone who has already worked on the MDB protocol for payment. My request is that a customer can access a touchscreen with 2 to 8 pictures. He select a picture, it send via the MDB protocol the payment request and if payment is accepted it launch a small PLC siemens logo program. I need a manager interface to change the prices, the number of sales available for each product and the photo of the product. We will load at the beginning all the possible photos so no need to add photos in the user interface. I need to be able to access from a browser to basic informations (number of products available, last sales, temperature...)

I'm seeking an experienced system administrator to configure a Linux webserver that integrates Hestia Control Panel (CP). Key Deliverables: - Enable web hosting functionality for between 1 to 5 websites. - Configure email management services - specifically, the ability to setup email accounts and implement a solid spam filtering system. Ideally, the freelancers bidding on this project should have prior experience setting up and managing Linux servers and using HestiaCP. Knowledge of website and email database management, spam filtering techniques is a plus. Deliver reliable, secure, and high-performing results.