Tsqltrabajos

I am searching asp.net webforms developer with 3 experience in webforms report Tsql,stored procs,triggers must work on remote for the first 10 hours

...by the supervisor supporting enterprise infrastructure. Handle daily maintenance tasks of supported platforms to ensure contract performance requirements for availability and support is met/exceeded. Deliver quality products across multiple technical disciplines when working with cross functional group requirements. SKILLS Must have strong troubleshooting skills Proficient with ASP.NET, C#, SQL/TSQL, HTML/XHTML, CSS, jQuery and similar web application technologies. Proficient in JavaScript, VBScript, PowerShell and the Windows Scripting environment in support of system level operation maintenance and workflow tasks. Proficient in Microsoft Visual Studio and familiar with Microsoft Team Foundation Server for development. Experienced working with Microsoft Active Directory, Inter...

...Responsibilities: • Responsible for design, development, and implementation of solutions to exchange data using the required ETL tool, Informatica Powercenter. • Strong verbal and written communication and shall be able to work directly with client and business to understand the domain/requirements. • Strong in DWH concepts and good understanding of modern analytics tools and processes. • Strong in SQL/ TSQL/PL/SQL, writing effective SQL codes and stored procedures. • Experience in DBMS like SQL Server and knowledge of know-hows of the same and troubleshooting experience. • Develop new code and/or support operations, maintenance, and enhancements of existing code • Conduct multiple levels of testing including unit, system, integration and perf...

...racehorse) will have its parents, grandparents, and so on through to 10-12 generations of its ancestry. We require some processes that will allow us to create calculations on these relationships and the family pedigrees. Most of these calculations already have some source code, but it is in Fortran or Python. I am unsure if it is best to rewrite this code for computational efficiency, or create C#/tSQL bindings to the code and use that. A freelancer with good knowledge of FORTRAN would be preferred. If you can have a look at the detailed description below and give me an idea of what your approach would be in terms of development and what the hours required would be, it would be appreciated. A full description of what is required can be found here -

Eu preciso de você para desenvolver um software para mim. Gostaria que este software fosse desenvolvido usando SQL.

I need you to develop some TSQL Script. I would like this software to be developed for Windows using SQL.

TSQL Script for a excel reporting project

Thoughtspot ( connections with servers, pinbords, TSQL, pentaho jobs) Asg rochade Becubic

just very small project write code with C# , HTML, TSQL, MySQL, within 1 day small budget If you interested, Pls contact

To help answer the HTML, TSQL test questions

TSQL procedure will accept a birthday date and display the age of the person. If the date is in the future or date format is incorrect, your procedure should display an error message.

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

Project Objective: 1. Build a data processing command line application. The application will scan a large collection of json files, read information and store the information in a database (the database provided (not built by the developer)). 2. Maintain a windows C# .NET web scrapping windows app to conform to changes in the target websites. Skills needed: - C# .NET, Entity Framework 6, TSQL (Sql Server) - Well versed in object oriented programming - Good technical English. Working conditions: - The developer will be working in our environment (a developer VM) remotely and will have to upload changes to CVS daily. - Advice and guidance will be provided. Upon successful completion further projects will be assigned. Please send a description of your relevant skills/experience.

Write a tsql to read data in json format from API and Write it sql table 2008 version

We require a document transmittal history report to record the versions of document despatched and the recipients they were despatched to. The report is to be produced using Microsoft Report builder (SSRS). Core to the report are the Document and Recipient cross tab matrix. The document matrix shows the vers...The Recipient records the method used to despatch a document for any particular document i.e. “e”=email. Visually, It’s important that unpopulated columns are still printered to fill the page out. See example The number of documents, transmittals and recipients may exceed 1 sheet so page breaks are required to accommodate all 3 scenarios. We have attached a SQL backup database with sample data + tsql for the header document and recipient matrix together with...

Exp level 5-7 Yrs Extensive experience in QuickBooks integration Experience in the repair database with Quickbooks system Familiarity with QuickBooks Online and QuickBooks Desktop, multiple versions Foremost - Advanced SQL database experience, so you can fully understand tables and business logic/ More importantly - proper TSQL so we do not impact the Database Server. API Development experience needed for QuickBooks Online. QBXML Experience needed for QuickBooks Desktop CFML Scripting if you keep on the platform we built it on. JavaScript would be beneficial as well.

CLARIFICATION: This project is pure JS using the package, html (for proof of work only) and TSQL. NO server side development is required aside from the SQL query itself and the output should have no other dependencies. We are a small business implementing an internal SAAS app with Highcharts. We require a Highchart Organisation chart as per the example at: Other chart properties required: 1. Responsive to allow full page expansion 2. Two box types: Unit and Position 3. Drill Down by Unit level (Co and Division with Departments Listed-->Dept Detail with Sections Listed-->Sect Detail) 4. Unit Box content: unit name, person in charge name, total positions/ filled positions/vacant positions 5. Position Box content: position name

...contractors, 8-15 USD/hour rate, depending of the project. Responsibilities: ● Design and develop high performing dynamic end-to-end web applications ● Collaborate with the CTO/product manager, and other software developers to implement solutions ● Help write, verify, and modify procedures and documentation Required Skills: ● Programming : Java || Python || C# || PHP ● Relational Database: SQL && (TSQL || PL-SQL) && (Oracle || MySQL || Postgres || MS SQL ) ● Other: NoSQL || Elastic Search || DeepLearning || …. ● Web : HTML5 && CSS && JavaScript && (Angular || Vue|| React ) ● Web : HTML5 && CSS && JavaScript && jQuery && (Angular || Vue|| React ) ● Tools : Git && Jenkins && (Maven ||...

sql/tsql program help needed details will be sent

I'm looking for tsql developper to help me with conversion between database ,link server, utility to improve it s not one shot project

...system and user documentation • Input into strategy and standards around the Business Intelligence portfolio • Documenting systems to high standards in English • Experience in MS Azure Data Factory, Data Lake Store, Databricks, and Analytic Services; which is the focus of a new Data Warehouse implementation project • Design and implement Data Warehouse data modelling with old and new techniques TSQL, Extract, Transform, and Load (ETL) , SSIS, Extract, Load, and Transform (ELT) , PolyBase , Hadoop, Cloud PaaS. Azure Cloud MSSQL, On prem MSSQL • BI & Analytic Tools (Cognos, PowerBI, SSAS) • Web base programming skill HTML, client scripting (Java script), Server scripting (.Net C#) basic level. • Experience of data analysis • Experience of...

I setup SQL audit and dumping data into this location: O:AuditData1. Now I need to load data into SQL table, AuditInfo. I need to run the following query in SQL job everyday. The following script works fine. Modification needed, so when it runs every day, it will load only the previous day data into SQL table. SELECT distinct * FROM sys.fn_get_audit_file('O:AuditData1*.*', DEFAULT, DEFAULT) INSERT INTO Test.[dbo].[AuditInfo] ( event_time ,action_id ,server_principal_name ,server_instance_name ,database_name ,schema_name ,object_name ,statement ) SELECT event_time ,action_id ,server_principal_name ,server_instance_name ,database_name ,sc...

Hi! I need to make a query and stored procedures with about 12 parameters. Thank you!

goal, -to create a query to query a sql-server backend table -to create a ssis job to export the data in the query result to a csv file for the query, the goal to pivot/flatten a table column values, reference a lookup values, to rows. As shown in the picture, with the table and configuration, to produce the csv file as export. Urgent requirement, sooner the better.

...technologies and tools, as well as a love of testing solutions from the ground up as well as a potential of becoming a Tech Leader in our company in the future. Responsibilities & Requirements: - 5 years of experience with C#, Versions 3.5+ - 5 years of experience with web development including ASP.NET. - 3+ years of experience with WCF & LinQ - Proven knowledge of SQL (Version 2008) with TSQL. - 5 years of knowledge of a broad range technologies and practices from different companies. - Experience with Large scale Databases as a plus. - Аbility to write read speak English in a good level - Background working in software gaming company- Advantage. - Deep understanding with Enterprise Library, Entity Framework, HTML5- Advantage. - Experience with ...

Need to hire 3 freelancers. There is no limit to how involved you can be in the deve...finding new ways of improving, so your opinions and innovations will always be welcome. Essential Technical Skills: • Cloud based application development • JavaScript ES6+ • Angular 2 - 9 architecture, Design Patterns and Best Practices • Application State Management (Redux) • Angular Material • TypeScript • Visual Studio Code • HTML/CSS • TDD Relevant Technical Skills: • agGrid • SQL Server/tSQL • C#.Net • HighCharts • Jira/Confluence • Gulp • NPM • Karma • Jasmine • Pug • Jest • Angular CLI A standard week is 40 hours over 5 full-time professional days (normally 9am to 6pm GMT including ...

Need to hire 3 freelancers. There is no limit to how involved you can be in the dev...finding new ways of improving, so your opinions and innovations will always be welcome. Essential Technical Skills: • Cloud based application development • JavaScript ES6+ • Angular 2 - 9 architecture, Design Patterns and Best Practices • Application State Management (Redux) • Angular Material • TypeScript • Visual Studio Code • HTML/CSS • TDD Relevant Technical Skills: • agGrid • SQL Server/tSQL • C#.Net • HighCharts • Jira/Confluence • Gulp • NPM • Karma • Jasmine • Pug • Jest • Angular CLI A standard week is 40 hours over 5 full-time professional days (normally 9am to 6pm GMT including ...

Hello freelancers! I have a database with several tables and I need about 20/25 queries and several stored procedures. I would like to know if someone is available to help me create them. Please, indicate your price based on 1 query/stored procedure since currently I can not indicate exact number of queries that will be required. Looking forward to your bids.

I need SQL help once in a while and looking for some expert to rely on hourly rate.

Must know: * Ag-grid * Angular Essential tech skills: • Cloud based application development • JavaScript ES6+ • Angular 2 - 9 architecture, Design Patterns and Best Practices • Application State Management (Redux) • Angular Material • TypeScript • Visual Studio Code • HTML/CSS • TDD Relevant Technical Skills: • SQL Server/tSQL • C#.Net • HighCharts • Jira/Confluence • Gulp • NPM • Karma • Jasmine • Pug • Jest • Angular CLI

Must know: * Ag-grid * Angular Essential tech skills: • Cloud based application development • JavaScript ES6+ • Angular 2 - 9 architecture, Design Patterns and Best Practices • Application State Management (Redux) • Angular Material • TypeScript • Visual Studio Code • HTML/CSS • TDD Relevant Technical Skills: • SQL Server/tSQL • C#.Net • HighCharts • Jira/Confluence • Gulp • NPM • Karma • Jasmine • Pug • Jest • Angular CLI

Need somebody having excellent ssis skill set with sql and tsql

Desenvolvedor Java para análise de problemas (DEBUG) e adequações em aplicação já desenvolvida. Experiência em desenvolvimento de integrações com outros sistemas, webservices. Experiência em Java, Git, HTML5, TSQL e Linux. Projeto será realizado durante 30 dias mas, os testes e entregas serão realizados presencialmente. Por isso profissional deve ser do RJ ou estar disponível no RJ durante este periodo.

Hi, I am trying to design and script a SQL database using TSQL. The due is in 2 days and I will provide more information during our conversation. Thank you.

I want someone to convert all my TSQL queries to LINQ queries. Payment by hours.

-Must have solid working experiences with STATA or R for doing data analysis. - Have experiences working in company level environment. -Have experience in SQL, TSQL programming. Who: The person must have at least 10 years of professional level IT experiences. What: Must have data intensive travel shooting experiences with STATA ,R and TSQL; Must have solid experiences R-Studio, rewrite, upgrade, and improvement on the earlier codes, Advance level TSQL data base programming and SQL code development. and know how to create complex stored procedures and complex queries. Expert in writing STATA and R coding . When: As soon as possible. Where: Service can be delivered online. Why: Project work in Agile environment.

Ciao, per importante progetto a Milano siamo alla ricerca di un DBA ORACLE con almeno 5 anni di esperienza da inserire all'interno del team "Database...almeno 5 anni di esperienza da inserire all'interno del team "Database Services". Il candidato parteciperà a progetti internazionali e avrà la possibilità di influenzare le scelte tecnologiche di implementazione attuali e future. Gradita esperienza anche con altri RDBMS: SQL Server, MySQL, Postgresql o SAP Hana. Buona conoscenza di alcuni tra i principali linguaggi di riferimento: SQL, PL/SQL, TSQL, Shell Scripting, Perl Powershello Phyton. Richiesta conoscenza dell'inglese fluente. Completano il profilo proattività e passione per l'IT. il lavoro si svolgerà p...

...and local contracts and we have an incredible application we want you to work on. Our application, SARA Version 3.5, has a middle layer of MVC, Bootstrap, and C#. The backend is MS SQL. We are looking for someone to help maintain the application. That includes problem identification, analysis, design, testing a delivery. The app is 95% data-driven using stored procedures, so a solid knowledge of TSQL is essential. You will be working directly with the lead developer and CEO. We are NOT looking for a systems architect or creative developer. We ARE looking for someone who is detail-oriented, conscientious and meticulous. Our code is stable and we want to keep it that way using our 3-stage development/production environment and established procedures. For more information on our...

...solutions within multiple Cloud accounts and services Experience working in AWS via the CLI and management console. Experience with source control systems (i.e. GIT) Hands-on experience working as a DevOps, Build & Release Engineer ideally with Nodejs and Meteor-based applications online/on-prem. Demonstrated knowledge and skill using multiple high level and scripting languages (C#, JavaScript, TSQL, PowerShell, etc.) Be passionate about automation Excellent organizational and time management skills. Ability to perform in a fast paced, high-pressure environment. Demonstrated ability to interact effectively with branch, regional and corporate personnel. Please answer the following questions: - How long have you worked with AWS? - How long have you worked with Azure? - How ma...

Hello everyone, I wish hire MSSQL TSQL professional. You need be senior-developer and have good knowledge in TSQL and XML. Also you need have clear 5 star reputation. I have stored procedure and i need write mapper inside it. If you be smarty people then we build good long terms relation (i have many tasks assigned to tsql) Happy bidding.

Any relevant edsicovery experience needed for this project, must show examples of technical skills and experience

In this MS Access / VBA project, you will create a visual replica of a moderately complex, four page medical form. Your project will include a light-gray data entry form with data entry controls (text boxes, check-boxes, etc) that looks somewhat similar to the PDF report in order a...have an autonumber key as the first field in the table. Your tables will be converted to SQL Server -Database tables and fields must not use reserved words for Access or SQL Server (ie. don't call a field "Date", or "Field" etc) -Field names must not use spaces -You can complete the work at your site and present with Access tables, or on SQL Server linked tables in MS Access -You will provide a TSQL script to create any tables/views that you use in the report. -Firm bids only ...

TSQL Script to Import multiple flat files to SQL then convert them to our standard and update the data on a 2nd SQL server.

Looking for these skills for ongoing work: - Knowledge account systems and chart of accounts - ideally Navision. - Analysis Service Tabular (developed in Visual Studio) - SQL Server 2017 / T-SQL - Power BI / Excel I would like to hire a freelancer for ongoing adhoc help with T-SQL, Analysis Service 2017 Tabular model and MS SQL Server in a Power BI end product. It is a plus if you have R exp...final product will be presented in Excel or Power BI so logic should be in Analysis Service. The test is, that you show chart of account postings in the hieachy which is listed in GL Account with Totalling row ranges. The Totalling accounts will summerize a range of accounts dynamicly at the level you are to construct at dynamicly calculating and correct PNL (you cannot try to solve the task in ...

...create a SQL Server/TSQL stored procedure that will take Windows Server IIS logging information and to store into a series of SQL Server tables to track patterns of access of users and crawlers/robots. The goal is keep track of different classes of web requesters by the IP address, browser/device types, their location, what pages they accessed (when first, last, and how many times), with a lot of focus on detailed tracking of all crawlers/robots to our site. There are four additional tables that get populated when a crawler/robot is detected. Three REST API providers are used to get detailed information from the IP Address and User Agent Information provided of the requester that we want to then store in the database. Project Requirements: • All code should be written in ...

PlanSOFTT Planning Manager ver1.2 / Stage 2: C#, TSQL, Operator entry (multiuser system by authorization levels /passwords – when operatör finishes job confirms the finish) Machine Data Screen: - Capacity Indicators page : Capacity Calender for machines (to see how full is the machine on a calender.. past grey, future reserved capacity red, future maintenance orange, future empty capacity white) - Plant Capacity Utilization page performance history /cost calculators Production cost calculations on reference to purchase costs, depreciation costs, consumption costs Quality report / Confirmation / Add Scrap cards (each scrap should be deducted from flowing job qty Cutting tool database Database for Spare parts and packing + shipment data in UTP page Reviewing and completin...

...program We are opened to a continuous partnership in return of accomplishment of this project Obfuscation is not accepted System shouldn’t slow down as it grows ** the program will be for internal usage of a small factory and will not certainly constitute a commercial value and will not be copied to utilize in other companies.. User interface C#, database, TSQL, communication , web by HTML PlanSOFTT Planning Manager ver1.1 / Stage 1: C#, TSQL, Able to import data from excel Keep history database Pending Orders Screen (when a line is double clicked, sub operation tree explodes like “Windows Explorer”): - UTP Screen, including production route screen (accomplished operation enlight green), keep history in database - Show scrap qty - Save in UTP library...

...program We are opened to a continuous partnership in return of accomplishment of this project Obfuscation is not accepted System shouldn’t slow down as it grows ** the program will be for internal usage of a small factory and will not certainly constitute a commercial value and will not be copied to utilize in other companies.. User interface C#, database, TSQL, communication , web by HTML PlanSOFTT Planning Manager ver1.1 / Stage 1: C#, TSQL, Able to import data from excel Keep history database Pending Orders Screen (when a line is double clicked, sub operation tree explodes like “Windows Explorer”): - UTP Screen, including production route screen (accomplished operation enlight green), keep history in database - Show scrap qty - Save in UTP library...

Hi, I am looking for Sr SQL DBA, who has experience with SQL 2014,2016, 2017, Powershell, SSRS, replication, TSQL, Performance tuning. it is urgent requirement

We are soliciting Power BI Developers on a short term basis (approximately 1-2 months) for projects. Find below the brief description of the candidate profile. The person is required to work from our Chennai office. About US: Headstart Global is a leading IT solutions provider & software developer ...SSIS packages • Must have excellent experience in MS SQL Server - writing queries, joints, stored procedure, functions etc • Should have experience in writing MDX queries, Cube Development. • Should have experience in writing DAX. • Should have experience in Scope Scripting Language and Microsoft Cosmos • Should have worked in creating complicated calculated measures. • Should have understanding on TSQL, Data Warehouse concepts. • Should possess ...