Tsqlpráce
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 ...
Hello I am certified data engineer. I have experience in SQL server database development TSQL, SSRS, SSIS and Power BI. Thanks
...Purchase ID ItemID Qty Price TransCode CurrentQty CurrentValue 1 1000 10 10 IN 10 100 2 1000 10 20 IN 20 300 Now Sales with FIFO 3 1000 6 0 Out 14 240 Sales With LIFO 3 1000 6 0 Out 14 180 Sales With Avg 3 1000 6 0 Out 14 210 ----- the Problem Will happen If the Customer Need to Delete the Transaction With ID=1 then I must re Calc All Rows again depend to the change , and this need very fast TSQL Code Please read the article as reference --- ---- Please download the test data from the Unzip the file and import the data (consisting of over a million rows) into the Stock table using your method of choice (I used the SQL
I have a full project/solution of source code for a SQL monitor - I have re-designed the interface and want to change the current design to a more modern UI that I have designed. I also want to add a few more features. PM me directly for more details to discuss. Please understand C# and TSQL.
Need to create dynamic SQL script for database restore. Grab the latest backup file out of several files. Backup Location: fileshareBackupFULL In this location I have 3 full backup file Name Data Modified Type 10/7/2018 BAK File 10/8/2018 BAK File 10/9/2018 BAK File Now from the latest file want a script to restore the database in DEV instance. Want to create the job in dev instance. No need to create the job, only need the dynamic SQL for grabing the backup file and then restore the database.
Estamos buscando un DBA SQL para dar soporte a un proyecto. El proyecto tendrá una duración de 1 o 2 meses y la persona tendrá una dedicación Part Time (unos días 6 horas, otros 2h, otros 4h, etc). Requisitos: - Experiencia en la configuración de bases de datos complejos. - Experiencia en TSQL, stored procedures, functions, jobs. - Experiencia en mover grandes cantidades de datos manteniendo integridad de la base de datos. - Experiencia en optimización y rendimiento: políticas de claves primarias, indexos y logs. - Sobretodo experiencia en SQL Server 2008 i 2012. Lugar de trabajo: Oficinas Pasiona
This project is to write a script that can run on Windows Server 2008. The script will execute a stored procedure (or TSQL script) every 15 or 30 seconds.
...database sql interview questions sql quiz sql query interview questions sql interview questions for experienced sql interview questions and answers basic sql interview questions sql developer interview questions sql query interview questions and answers aql chart sql joins interview questions sql interview questions for freshers nosql db sql convert sql queries sql index sql online test rollback sql tsql w3schools sql sql injection sql formatter sql group by sql create table dba pl sql tutorial sql not in sql stored procedure in sql sql commands triggers in sql sql view mysql mysql download my sql postgresql mysql tutorial phpmyadmin nosql vs sql nosql tutorial w3schools sql Set 5) TOC automata theory formal languages and automata theory theory of computation number theory finit...
I need a new website. I already have a design, I just need you to build it. A very basic fintech concept to service a niche local to + TSQL
Looking for senior .Net MVC freelancer ASP.NET, MVC, C #, TSQL, JavaScript, CSS Creation of highly scalable systems and frameworks Documentation of product enhancements and bug fixes Responsive design/development and mobile web best practices Basic cross-browser testing and troubleshooting experience Ability to understand the big picture, look forward, anticipate problems, and assess risk Demonstration of technical problem-solving abilities Highly organized, detail oriented, and able to work autonomously with minimal direction from high level requirements and managers Effective communication, collaboration, and interpersonal skills Ability to brainstorm with other team members and leverage constructive feedback success driven about learning new things and taking ...
Looking for senior .Net MVC freelancer ASP.NET, MVC, C #, TSQL, JavaScript, CSS Creation of highly scalable systems and frameworks Documentation of product enhancements and bug fixes Responsive design/development and mobile web best practices Basic cross-browser testing and troubleshooting experience Ability to understand the big picture, look forward, anticipate problems, and assess risk Demonstration of technical problem-solving abilities Highly organized, detail oriented, and able to work autonomously with minimal direction from high level requirements and managers Effective communication, collaboration, and interpersonal skills Ability to brainstorm with other team members and leverage constructive feedback success driven about learning new things and taking ...
I need a tsql script to generate some test data 1. for each row in a table, read the companyid and customer name 2. for each company generate a 7 column transaction for each first of the month between the start date and the end date (current month) 3. test if transaction exists in a second table and if not, insert it a transaction would look like [CompanyID] read name from first table ,[TransID] NULL ,[TransType] 'Maintenance' ,[InvoiceNumber] NULL ,[Customer] read name from first table ,[SettlementDate] 1/1/2017 ( and every first of the month until current month ,[Amount] 99
...Sales With LIFO 3 1000 6 0 Out 14 180 Sales With Avg 3 1000 6 0 Out 14 210 ----- the Problem Will happen If the Customer Need to Delete the Transaction With ID=1 then I must re Calc All Rows again depend to the change , and this need very fast TSQL Code Please read the article as reference --- ---- Please download the test data from the Unzip the file and import the data (consisting of over a million rows) into the Stock table using your method of choice (I used
I Use Sql server 2012 I have ERP System and I need to calc FIFO,LIFO and Average cost in for the inventory Item I have 4 types of transaction 'IN' (Purchase) ,'OUT' Sale ,'INR' Returned Purchase , ''OUTR' for Sales return Database Structure - Items Table ( Has ItemID, And ItemID and Calculation Method ) -Transaction Table (has ItemID,Date,Qty,Price,TransactionCode) I need To calculat... 14 240 If In LIFO 3 1000 6 0 Out 14 180 If In Avg 3 1000 6 0 Out 14 210 the Problem Will happen If the Customer Need to Delete the Transaction With ID=1 then I must re Calc All Rows again depend t...
...Requirements • Azure / AWS (Nice to have!!!) • Excellent Technical Architecture Capabilities (Nice to have!!!) • Available US Hours 9-5 EST (Nice to have!!!) • Experience with Agile/Scrum • Excellent Communication Skills Languages • ASP.NET • ASP.NET MVC • C# • C# TDD • JavaScript • JavaScript Framework TDD (Angular x, React, etc.) • CSS (SASS) • HTML5 • TSQL/PL-SQL • JSON • WebApi • REST • WCF Tools • GitHub • TFS • ZenHub • Postman Runtimes • .NET Core (all versions) • .NET Framework (all versions) • .NET Standard (all versions) Libraries • JavaScript Framew...
...support in MS SQL Server environments. SQL Development – ability to write and troubleshoot SQL Code and design ( stored procs, functions, tables, views, triggers, indexes, constraints ) Strong knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively. Strong experience in TSQL code Knowledge in Database Administration in SQL Server Knowledge to detect and troubleshoot SQL Server related CPU,memory,I/O, disk space and other resource contention. Knowledge in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues ...
...cronogramas a través de capacidades analíticas y de resolución de problemas. • Experiencia en la lectura de esquemas eléctricos / diagramas de cableado y dibujos de PI & D. • Debe tener un título universitario o postgrado apropiado en Electricidad / Electrónica o Ingeniería Informática o Control y Automatización Industrial • La experiencia de programación con .Net, C / C ++, C #, VB / VB.Net, SQL / TSQL / SQL + u otro lenguaje de alto nivel es una gran ventaja. • Experiencia en diseño / dibujo eléctrico con AutoCAD Electrical, Eplan, etc. es un activo definitivo. • Horario de trabajo flexible con la posibilidad de viajar. • Fuertes habilidades de comunicaci&oacu...
I cannot give you access to my database. I am looking for help summing when the account number changes. See Example. I want to Sum to total Cost from Table 'a' based on the Account#. In other words when the account number changes I want to stop, Add a line for the Totals. I don't want to repeat the Total Sales Price from Table 'b' over and over, I just want it once on the Total Line. Finally I want to add a column for Profit. Total From Table 'b' - Total from Table 'a'
We need to migrate the tables of an Azure SQL Server to another Azure SQL Server during the rewriting of an application. The definitions of the tables have changed in the new version of the application so an analysis of the...application. The definitions of the tables have changed in the new version of the application so an analysis of the tables in both source DB and destination DB has been done to determine the mapping from old tables to new tables. The work needed is to extract the data from the source Azure SQL Server and load it into the destination DB according to the mapping rules. Coding should be done using TSQL in SSIS packages. There is also some data to be loaded to an Azure Cosmos DB from the source Azure SQL Server. There will be about 30 tables to load into the desti...
I need a basic tsql query for a the attached spreadsheet to produce the desired output. I believe I need a subquery to output file where; Distinct records where the status <> 'Active' Where there are duplicate records with multiple Status I need to output only one record where there are no Status = 'Active' The purpose of the report is to determine which stores do not currently have an Status = Active contract.
We need to migrate the tables of an Azure SQL Server to another Azure SQL Server during the rewriting of an application. The definitions of the tables have changed in the new version of ...application. The definitions of the tables have changed in the new version of the application so an analysis of the tables in both source DB and destination DB has been done to determine the mapping from old tables to new tables. The work needed is to extract the data from the source Azure SQL Server and load it into the destination DB according to the mapping rules. Coding should be done using TSQL in SSIS packages. There is also some data to be loaded to an Azure Cosmos DB from the source Azure SQL Server. The source DB has about 1000 columns to extract and feed into 500 columns in the desti...
I have a stored procedure with query that return data for a report. It uses 2 user defined functions. The procedure takes too long to execute on MSSQL; it is currently deployed to Azure SQL. I need the procedure to be rewritten in a more efficient way. Attached is the tsql. Please let me know your experience and your best bid; I would like to get started right away.
