Tsql xquerypekerjaan
Dear freelancer, I have a sql server db with the following columns: Date, number1, number2, number3, number4, number5, number6 and few other columns. I need a tsql query that will create all possible combinations for numbers from 1 to 90 escluding occurences in database. For example, if there's already in db a combination such as 8, 11, 18, 46, 48, 88 then it should be excluded from the result set. Parameters to be accepted are as follows: NUMBERS TO BE EXCLUDED: set of number that should be excluded from result set CONTINUOUS NUMBERS YES/NO: Exclude from result set sequences with continuous numbers (eg. 12345 or 1, 2, 15, 16, 22, 23, etc) RANGE OF NUMBERS (FROM 1 TO 10): How many numbers to be included in result set RANGE OF NUMBERS (FROM 11 TO 20): How many numbers to be i...
Sila Dafter atau Log masuk untuk melihat butiran.
Requirement - Zoom Developer (DB Specialty) training wish list PAX – 15 – 20 ( Both Freshers & Laterals) Technologies to be covered 1. SQL Server Integration Services (SSIS) 2. SQL Server Analysis Services (SSAS) 3. DAX 4. Advanced TSQL – Emphasis on Stored Procedure development Expectaions: Should have some familiarity with coding in general of course. Frontend UI Developers should have the following general skillset: Net Core, ASP.NET, Web API, Microservices, C#, TSQL, AngularJS, Java Script, Linux, Azure Power Apps, Bots, RPA, Python.
Hi I need a tsql expert who is reliable and have time to do a small project. The project is about integration of slack and tsql. Slack need to be used to recover notifications from mssql regarding mssql notifications.
Experience : 4+ Years Open Positions : 06 Developers Joining: Immediate Job Type: FullTime Salary: 20-30% increment on current CTC Location : Pune / remote/WorkFromHome option available Job Description: - Excellent knowledge of coding and NET is required. - Expertise in TSQL, ASP.Net, IIS, MVC, Web API, Entity Framework, JavaScript, HTML5, CSS, jQuery and similar technologies is required. - Programming experience building Responsive Web Applications using Bootstrap or similar technologies is required. - Programming experience with SQL Server Integration Services (#SSIS), SQL Server Reporting Services(SSRS) and Microsoft Dynamics CRM is desirable. - Solid debugging, testing, and problem solving skills. Strong written and verbal communication skills.
Hi, we are looking to hire a TSQL SQL Server developer for a long term development works. The candidate should have extensive experience in SQL Server development and should be available to work with us during IST hours
...architects and support teams. So there will be no 20 hours of 'discovery' on our applications. We will point you to the pages, code and database assets we need changed. Hopefully over time you will get to know our applications. Required skills - ASP.NET (VB) - MS SQL Server - TSQL - HTML/CSS/JQuery - Visual Studio - VSO (Online Source Code) - Creation of Console App - Creation/Consumption of Web Services/APIs Ideally you will have worked with: - Large database driven websites - Integrating 3rd party Web Services/APIs - Complex TSQL to improve performance - Experience with the Metronic Admin framework The team member assigned must - Be able to follow older style code (but be up to speed with newer concepts) - Be able to follow step by step instructions. - Be ab...
We're looking for asp.net MVC core developers who have worked with. .NET Core C# .asp.net MVC .Angular TSQL. Sqlserver Rdlc Crystal reports Because this is a long-term position, the developer will be interviewed and put through a practical exam before working 40 to 60 hours per week. for the next 5 to 8 months, at a rate of 4-5 USD/h
We have several Oracle scripts that are using Oracle's dbms_aq (Advanced Queuing). We want to have an experienced SQL Server developer who can write queries based on SQL Server Service Broker
Hi, we have a project that requires a minimum of 100 hours of work. We want an experienced TSQL developer to work with us on this project.
Need a mentor for tsql and implementation of some logic
I am looking for multiple instructors experts in TSQL, PLSQL , .NET , React, Angular, JAVA, Python, SSRS/SSIS , Business Intelligent Development for my company to train my consultant. Online and Onshore are welcome to contact me. Class will start in month or month and half later in mid May. I would need instructors in M/W/F/S and Sundays ..Flexible hours on weekend. After 5 pm cst in Week Days
Hi Sk A., I noticed your profile and would like to offer you my project. We can discuss any details over chat.
Hi, I am looking for TSQL Developer, who has experience with SQL 2014,2016, 2017, Powershell, TSQL, Performance tuning. it is urgent requirement
As discussed in chat.
Develop high-quality database solutions. Use T-SQL to develop and implement procedures and functions. Review and interpret ongoing business report requirements. Research required data. Build appropriate and useful reporting deliverables. Analyze existing SQL queries for performance improvements. Suggest new queries. Develop procedures and scripts for data migration. Provide timely scheduled management reporting. Investigate exceptions with regard to asset movements.
Must Have Qualification: Knowledge and familiarity of using Microsoft Technology Stack such as SCCM, SCOM. Nice to have: Oracle Service Bus Message Flow, Proxy Service, Business Service, XQuery, XML, XSLT, JMS, SOAP, REST, WSDL, Adapters and concepts of SOA development.
I need someone with experience of deployment of a website in AWS EC2 or LightSail. He should also have experience with NGINX and should have deployment experience of deploying a .NET Core application in LINUX machine using a docker container and RDS. Should have experience of IIS deployment, SSL configuration, DNS configuration, FTP configuration Ability to convert TSQL queries to MySQL is an added advantage
Help collect learning / study material for data mining. Data sets and instructions for solving data mining challenges within those datasets. Focus on data wrangling (common parts), Validation, mining algorithms. In: + Excel + SQL Server (SSAS in Visual Studio) Extra plus if you involve: MDX & TSQL.
I have clear instructions about the xquery which you need to submit in zip file
On-going development for existing projects. English a must!
Hi , I need a professional who got experience in XQuery XML i got a task which is about 4 queries If anyone got the experience please reach out for further details Many thanks, saad
Require a state of the art training content for Power BI. It should cover SQL,TSQL, SSIS and Power BI modules from beginner to advanced level. Looking to have a content which is very easy to understand with real time datasets, problem statements and scenarios. Need one major project with real time data for SQL, one small project for SSIS and One major project for Power BI to fulfil hands-on requirements of the course content with devised assignments as course progresses.
Hello, We have a working Django, Graphene GraphQL backend for almost all our models. At the front we use TypeScript, React, Material-UI, GraphQL Code Generator, React-Query. The layout (login handling, menu, etc.) is working OK. All the code is on GitLab, and we use gts (google typescript standard), lint-staged, and husky. We would like to hire an expert on that stack to create CRUD pages ...React, Material-UI, GraphQL Code Generator, React-Query. The layout (login handling, menu, etc.) is working OK. All the code is on GitLab, and we use gts (google typescript standard), lint-staged, and husky. We would like to hire an expert on that stack to create CRUD pages and form handling on those pages (we use Formik so far but we are open to recommendations) Please start your bid with &quo...
...based on convenience. PPW is 100 to 120 INR per 1000 words We have openings for Software Tutorial Videos Creation for Android,Java,Python,C,C++,MySql,Html ,HTML5,CSS,JavaScript,React.js,Node.js,PHP,Django,Selenium,Kotlin,Ruby,Rail,Software Design Pattern,Unity ,Mongo DB,React Native,Quants ,English Grammar,C#, jQuery UI,XML,json,Ajax,Web Services,Bootstrap,,Backbone,Sass,Less,XSLT,XPath,XQuery,XHTML,,Materialize,Framework7,DHTML,Laravel,WordPress,CodeIgniter,Magento 2,Joomla,Phalcon,YII,Xampp,,,WPF,SSRS,SSIS,Web API,LINQ,SharePoint,F#,VB.NET,,SQL,PL/SQL,MongoDB,PostgreSQL,SQL Server,Oracle,Cassandra,SQLite,Neo4j,CouchDB,MariaDB,DB2,PouchDB,Redis,,Servlet,JSP,Spring Boot,Spring Framework,Hibernate,Web Services,Struts,RESTful Web Services,Microservices,Spring Cloud,Jenkins
Sila Dafter atau Log masuk untuk melihat butiran.
Job Description mandatory SN Required Information Details 1 Role Oracle SOA/OSB – Developer/ Designer 2 Required Technical Skill Set** Oracle SOA 12C, Oracle OSB 12C, Oracle BPM 12C, XQuery, XSLT, YAM Desired Competencies (Technical/Behavioral Competency) Hands on experience in Oracle SOA 12C and Oracle OSB 12C Good understanding on Message Flow, Proxy Service, Business Service, XQuery, XML, XSLT, SOAP, REST,WSDL, Adapters, SLA Alerts etc. Configuration of JMS Servers, JMS Queues, JMS Bridges, and its components Strong Analytical and Problem-solving abilities Should be able to understand E2E requirements and design the flows and suggest appropriate framework Lead and anchor solution workshops & discussions with customer SME and other teams to design robust and ...
Dell Boomi Development , Unit Testing and Deployment of API Microservices. Candidates must be proficient in Maven , GIT, Spring Core and XML, REST,SOAP apis, Api client software ( SOAP UI, Postman ), Linux basic command, Junit, EJB, Oracle SQL, WebLogic, Groovy, XQuery
• University degree in Computer Science or other related fields preferred; equivalent experience will be considered; • Over 5 years’ experience in .NET Stack; • Strong knowledge in C#, ASP.NET, .NET Core, Entity Framework, Web API, Web Services, MVC; • SQL, TSQL, MSSQL (Microsoft SQL Server); • Knockout or Vue.js; • Knowledge of OOP patterns and best practices; • Written and verbal skills in English; • Dedicated, reliable team player with a high sense of responsibility;
Deliver examples as per requirement in next 2-3 hours
Deliver examples as per requirement in next 2-3 hours
Queridos colegas, nuestro proyecto necesita de programadores con conocimiento avanzado de PHP 7+ y Laravel. Asimismo se necesitan conocimientos avanzados de XML, XQUERY y XPath. Estos conocimientos son imprescindibles y deben ser demostrados en proyectos anteriores. Aparte de todo esto son necesarios conocimientos en MySQL, PHP Cli, Javascript, Vue.js (CoreUI) así como conocimientos avanzados de HTML, CSS y en los entornos Linux con conocimientos de Administración de servidores. Atte. Carlos Medina
• Responsible for different Software Development Life Cycle (SDLC) processes included Analysis, Design, Programming, Testing (Unit & System) and Documentation • Responsible for Data Analysis, Data Mapping between multiple applications as part of integration process, analyze data between m...modules and make changes to the code improve the performance and prepare SQL Scripts to fix production data issues. • Develop and maintain technical architecture for the application. • Participate in Vision, Stakeholders, User story, Sprint review and scrum meetings for Design and Analysis of new projects. • Developing data model Diagrams, Microsoft SQL server database design including PLSQL / TSQL packages and Stored Procedures (Using MS SQL Server 13) for execut...
Looking for someone who has knowledge for Power BI and TSQL.
What I need to do is find the Day of the Week and the Month within the Date Range of the data and return to me that value. I have the first part of the procedure; USE [Test-DB] GO /****** Object: StoredProcedure [dbo].[proc_parseXLRule] Script Date: 7/7/2021 9:08:01 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[proc_parseXLRule]( @OldRule varchar(1000), @NewRule varchar(1000) output ) AS BEGIN SET NOCOUNT ON; --SET @OldRule= '10JAN-31JUL/XR:P$100|90 DR:P$50~01AUG-20NOV/XR:P%50 DR:P%25~21NOV-09JAN/XR:NR' DECLARE @NowDay VARCHAR(2) DECLARE @Today DateTime DECLARE @NowMonth VARCHAR(3) SET @NowDay = RIGHT('00' + CONVERT(NVARCHAR(2), DATEPART(DAY, GETDATE())), 2) SET @Today=getdate() SET @NowMonth=UPPER(FORMAT(@Today,'MM...
The existing stored procedure needs to be modified with additional conditions.
Hi All Looking for expert in below skillset Tech Stack: Java Full Stack; Testing, CICD pipeline, AWS, microservice architecture, general backed development, JS frameworks, node.JS/react.JS, Mobile - react native Backend DB: PostGres, Redis, DocumentDB (similar to Mongo), DynamoDB, Kafka, Clojure, PL/Sql, TSQL, PLpgSQL Let me know if you have experience in it
a. Stored procedure for loading all the databases directly from a csv/text file from a folder by date timestamp. So assuming there are multiple files the stored procedure will only load the most current file by table b. Stored procedure to load incremental/delta load .. So assuming the changes are minor the job will only load that part and ensure the changes is properly tracked. So the job will load a staging table before the final table c. Stored procedure that capture all changes. d. SQL to create an aggregate table on the diagram - Derived table from all tables.
Hola JoseLlanosLopez me gustaria poderte realizar los pagos pendientes y encargate un nuevo proyecto sobre XPath, XSLT, XQuery
I have a ASP.NET - MVC project created in C# / TSQL / Bootstrap The project works as required, no problems, BUT i need to make some modifications to some areas Some data entry popups need modifications Some data PDL created with itext sharp also need modifications We need to have online meeting with anydesk and work on my computer to see and modify the issues
Hola JoseLlanosLopez, soy el chaval que te encargo un proyecto de su e-portafolio y tengo otro trabajo para ti haber si sabrías es un trabajo sobre XPath, XSLT, XQuery.
Apriso Flexnet training I need a training for config / admin at Flexnet Apriso MES. This is something I want to pay myself to expand my knowledge; I don't really need at this time. I don't need an official certification, but if possible a place to practice; documentation, or any material. Please share your training plan with me, what do you know that can be shared with me. Customization, TSQL/PLSQL, Orders management, etc
Looking for a Java Developer to support on a part-time capacity with 20 Hours per week. Requirements: • 10+ years of application development using Enterprise Java /JEE technologies • Experience with XML Technologies is a must. (XML, XSD, XPath, XQuery, XSL, XSLT) • Must have good experience with JAX-RS and Jersey • Proficiency in designing and developing SOAP/ REST based APIs and Web Services focused on the below list but not limited to: o Service integration with Workflow Management tools o Data Persistence to RDMS and/or NO SQL o UI integration o Authorization and Authentication • Experience with Java Swing / JavaFX / Rich Client Platforms (such as NetBeans, Eclipse, Flash/Flex) • Experience with current web technologies (e.g. HTML5) and O/S...
Technical consultant who is proficient in .NET Core API & SQL datab...hand-coding using Visual Studio Code, test them via Postman tool, implement and optimize stored procedures and functions using T-SQL • Customize API development using .Net Core considering re-use & caching for optimized performance • Database designing and ensuring their stability, reliability, and performance. • Debugging API issues by taking SQL Trace & fix the root cause of the issue in .Net / TSQL • Development of Integration touch points using API / Web services • Would require to learn in-house development tools for development of APIs • Profile server resource usage and optimize and tweak as necessary • Prepare documentations and specifications • Collabor...
Hola Ernest V., vi tu perfil y me gustaría ofrecerte mi proyecto. Estoy buscando a alguien que me eche una mano con una tarea de xquery de un ciclo superior. Necesito ejecutar 10 sentencias para que se muestre el resultado. Le adjunto el XML y la tarea que tengo que realizar. ¿Podría ayudarme? Si es así, ¿Cómo procederíamos?
Hola Buenas tardes: Estoy buscando a alguien que me eche una mano con una tarea de xquery de un ciclo superior. Necesito ejecutar 10 sentencias para que se muestre el resultado. Le adjunto el XML y la tarea que tengo que realizar. ¿Podría ayudarme? Si es así, ¿Cómo procederíamos?
Hola Adolfo M., vi tu perfil y me gustaría ofrecerte mi proyecto. Podemos conversar por chat acerca de los detalles. Es un trabajo bastante pequeño de todos modos el precio lo cerraríamos después de hablar sobre las condiciones y eso.
Es un trabajo bastante pequeño de todos modos el precio lo cerraríamos después de hablar sobre las condiciones y eso..
Es un trabajo bastante pequeño de todos modos el precio lo cerraríamos después de hablar sobre las condiciones y eso.
