Tsqlemplois
PHP,MySQL/TSQL/PLSQL,HTML/HTML5,CSS/CSS3,JS/AJAX/JSON,C/C++,PERL,VB,PLSQL,XML/XSLT/XSD, SOAP, CBuilder, VB/MS Macros, JAVA/JSP, C#/ASP, Sometimes: Phython, OpenGL/WebGL 3D, 3DMax Script,
KAVER Consulting se encuentra en la búsqueda de un Analista Programador .NET Angular Js, para sumarse al equipo de una importante empresa requiere experiencia en:> C#, .Net, ASP .Net, Javascript, HTML5, XML, Bootstrap.> Angular JS > Programación TSQL> Desarrollos en Capas> Conocimientos de WCF, MVCOferta Laboral que ofrece proyectos de primer nivel y ultimas tecnologías. Importante empresa de sistemas !!Postulate!!-
Se esta buscando desarr...migración desde VFP 9 por lo que es imprescindible interpretar dicho código.<br />Alta disponibilidad horaria mensual. (No menos de 100 horas)<br /><br />Se valorará el conocimiento de HTML5, CSS3 y Boostrap (se entregará el HTML de todas las pantallas a realizar, por lo que no es requisito conocer el tema en profundidad)<br /><br />Se valorará experiencia con Scrum.<br />Conocimientos de SQL Server y TSQL<br />Microsoft Visual Studio 2013 o superior (C#, Linq)<br />Arquitectura Web MVC5<br />WebApi<br />HTML5 para el frontend<br />Bootstrap<br />Knockout<br />Jquery<br />Typescript<br />GITLAB como repositorio<br /><br />...
Dynamic Home Loan Calculator Script In Tsql and Should be same as most Indians bankers home calculator
Various project writing queries and integration of new routines. knowledge of TSQL, Webservices, Asp.net, C#, VB essential
Cerca de 10 anos de experiência business intelligence, banco de dados e desenvolvimento, participando de projetos em grandes companhias do ramo farmacêutica (Mantecorp), seguro e previdência (Mongeral AEGON, Dataprev), telecom (BRT, ...experiência business intelligence, banco de dados e desenvolvimento, participando de projetos em grandes companhias do ramo farmacêutica (Mantecorp), seguro e previdência (Mongeral AEGON, Dataprev), telecom (BRT, OI, Claro, TIM, Vivo, GVT, Algar), Gas LP (Supergasbras). Habilidades: • Administração de banco de dados SQL Server (2008R2/2012 ) • Microsoft SQL Server BI (SSIS, SSRS, SSAS, PowerBI, TSQL, DAX) • Pentaho Integration (Ketlle) • Informatica Powercenter • Modela...
Buscamos recursos .Net por 2 meses<br />Los recursos deben tener como minimo 1 año de experiencia en desarrollos .NET , entity framework, ASP .net, SQL Server TSQL y preferible ETLs<br />Vinculación por prestación de servicios<br />Altas posibilidades de tener vinculación hasta por el año
Poder leer código VFP trata de una migración desde VFP 9 por lo que es imprescindible interpretar dicho código.<br /><br />Se valorará el conocimiento de HTML5, CSS3 y Boostrap (se entregará el HTML de todas las pantallas a realizar, por lo que no es requisito conocer el tema en profundidad)<br />Se valorará experiencia con Scrum.<br />Conocimientos de SQL Server y TSQL<br />Microsoft Visual Studio 2013 o superior (C#, Linq)<br />Arquitectura Web MVC5<br />WebApi<br />HTML5 para el frontend<br />Bootstrap<br />Knockout<br />Jquery<br />Typescript<br />GITLAB como repositorio<br /><br />Adicionalmente, es bueno que sepa algo de:<br />Visual FoxPro...
KAVER Consulting se encuentra en la búsqueda de un Analista Programador .NET Angular Js, para sumarse al equipo de una importante empresa requiere experiencia en:> C#, .Net, ASP .Net, Javascript, HTML5, XML, Bootstrap.> Angular JS > Programación TSQL> Desarrollos en Capas> Conocimientos de WCF, MVCOferta Laboral que ofrece proyectos de primer nivel y ultimas tecnologías. Importante empresa de sistemas !!Postulate!!-
...Base de Datos. Instalación de servidores de Base de Datos, de acuerdo a los estándares del en el diseño de la arquitectura de infraestructura para nuevos desarrollos de Base de proactivo y aplicación de mejores prácticas para el rendimiento de servidores de Base de usuarios y seguridad de los usuarios de Base de ón de ETLs y código TSQL en Base de Datos SQL LógicoAnálisis NuméricoAlto Sentido de UrgenciaTrabajo en EquipoEnfoque a ResultadosOfrecemosSueldo:Competitivo y de acuerdo a experiencia Beneficios: Prestaciones de LeyContrato por tiempo indefinido Grandes Posibilidades de Crecimiento Horario: Lunes a Viernes 9.00 a 18.00hrsZona para laborar: POLANCO,a tres cuadras FAVOR DE POSTULARSE POR ESTE
I need to check if we store certain details in our database, so I need to write a stored procedure (like the one below) that allows you to search for any x digit numbers (eg. 12 or 20 digit numbers or 8 digit numbers in a row) in all columns of all tables in all databases of a particular instance and store the results in a # temptable the following format: Servername, InstanceName, DBName, TableName, ColumnName, PrimaryKeyValue, data Value, datetime of capture (getdate() sp with parameter of @n (number of consecutive digits ie only numbers no characters) with a where clause of something like: ' WHERE PATINDEX(''%[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]%'','+ @ColumnName +') > 0' Ple...
...similares (Deseable). O 3 años de experiencia con Angular.<br />Experiencia en realizar estimaciones.<br />Valorar la performance, escalabilidad y seguridad como temas fundamentales del desarrollo.<br />Conocimientos de UML<br /><br />Requisitos Tecnológicos<br /><br />C# .Net, ASP.NET, Javascript, HTML5, XML, Bootstrap.<br />Angular JS - Al menos 3 años de experiencia (excluyente)<br />Programación TSQL.<br />Desarrollos en capas.<br />Manejo de web services y WCF<br />Utilización de herramientas de prueba unitaria (UnitTest, NUnit)<br /><br />La Empresa Ofrece<br /><br />Relación de dependencia directa.<br />Posibilidad de hacer home of...
Buscamos ingeniero DBA para proyecto de 2 meses en sitio Bogota horario de oficina. Contrato prestacion de servicios. La persona debe contanr con disponibilidad para iniciar proyecto en periodo de 3ra o 4ta semana febrero 2016
Overview of Task: Write some TSQL code for SQL Server 2014 to search for substrings given text. Introduction: I have five small tables in the database. I want to specify a sentence like: 'Ian Excel "progress bar" '. Then the TSQL will return the details for the items in the database which best resemble this query. The most relevant items are at the top, the least relevant to the bottom. Note: "progress bar" here is in quotes and a compound word. I have attached an .SQL file to create the tables and insert some data. The main item returned from the example query above would should be as follows: Ian Progress 1 Excel 1 The recommended progress bar to use in Excel. Progress bar in Excel 1.0 training||code||Excel||coding standard...
Support work required for TSQL/SSIS/SSRS/SSAS
I need help with a TSQL procedure that I want to loop through a master table taking the server names as input from the table and then pinging the SQL server instances using either SQLCMD or OSQL or any other way and send an email out to the recipients if the ping fails. I am able to get the procedure to execute and successfully the ping using linked servers and if the instance is not available the TRY CATCH block catches the error and emails perfectly fine. I want the same TSQL procedure to ping using xp_cmshell + OSQL or SQLCMD and send an email out based on the output of the ping. I am attaching the TSQL that I have working with the xp_cmdshell + OSQL ***BUT I am just NOT able to send an email if the ping fails based on the results of the output of the procedu...
...[], ..[],...,[] I have following code which only generate 1 to 9 columns and not in one row. I want this in 1 day... DECLARE @TSQL varchar(8000), @VAR char(5),@wwVersion char(6) ,@Counter int,@Counterv1 int SELECT @VAR = 'delta' SELECT @wwVersion = 'Latest' SELECT @Counter = 0 SELECT @Counterv1 = 10 while @counter < 9 Begin set @counter = @counter + 1 -- SELECT @Counterstr = 'V00' + rtrim(cast(@counter as char)) print @counter SELECT @TSQL = 'SELECT * FROM OPENQUERY(INSQL,''SELECT IF ' + rtrim(cast(@counter as char)) + ' <= 10 THEN [CPW_V00' + rtrim(cast(@counter as char)) +'.WTOperationState] ELSE [CPW_V0' + ...
Se precisa un/a Analista Programador/a .NET C# con experiencia en WPF y WCF para Barcelona. Requisitos: Programación avanzada en el lenguaje C# preferiblemente en entorno Microsoft Visual Studio 2013 con Team Foundation Server (TFS). Experimentado en WPF. Servicios WCF. Servicios Windows Multithreading Programación avanzada en TSQL en entorno Microsoft Windows SQL server 2008, 2012. Diseño de Bases de datos relacionales. Programación de procedimientos almacenados y funciones. Tunning de índices y consultas. Documentación técnica Documentación de diseños y órdenes de desarrollo en Microsoft Word. Documentación de las nuevas funcionalidades en los manuales de producto. Documentación en Inglés. I...
Para proyecto de ingeniería de larga duración se precisa incorporar un perfil de Programador Back-End .NET. Las tareas a realizar serán:- Migración de protocolos de ...perfil de Programador Back-End .NET. Las tareas a realizar serán:- Migración de protocolos de comunicación XML. - Desarrollos .NET sobre plataforma B2B. El candidato deberá aportar conocimientos en:- Experto en transformación y adaptación de ficheros XML / XSD- Experiencia en protocolos de comunicación e intercambio de información B2B.- Experiencia en ASP.NET / Winforms.- Conocimientos en SQL Server (TSQL, Stored Procedurees, acceso LINQ).- Alta capacidad de abstracción lógica. Se ofrece:- Plan de desarrollo profesional.-...
Hi, Here is our requirement. ---- Project Environment: ASP.NET, .NET 4.5, C#, WCF, HTML, CSS, Javascript, JQuery, Bootstrap, Responsive UI, Google Analytics, TSQL (complex user functions & stored procs), SQL Server 2012, Visual Studio 2013, Visual Studio Express for Web 2013, Visual Studio Online (TFS in Cloud - for source control), Wikipedia REST API, Windows Server 2012, JSON, PhoneGap API, Windows 8 Mobile, HTML 5, Wordpress Forum (for Project tracking). ---- Website has 3 user modules (End User, Admin, Business User), 120 sql tables, 3-tier architecture (UAL/BAL/DAL). Most work is Integration work which requires deep understanding of existing code and writing of "missing code" after analyzing logic threads spread out to many files of many modules an...
I am looking for someone who can work everyday 1 to 2 hours on the on going project. Looking forward to work with the for long time. Can pay monthly up to 450. Let me know if you are interested work. Please you need to have good experience in Data warehousing and SSAS, SSRS, SSIS, TSQL, MDX.
Looking for a full time SQL Server expert. Who is very good in SSIS and TSQL. This is a full time position.
I have ongoing work related to our previous project 'Convert some basic TSQL to C#'
I have some basic 3 x TSQL functions that I had written that (SQL Server 2014) that I would like converted to C#.
I need a Windows console application that can convert an existing set of dbf/DB2 files to both tab delimited output and tsql. In a best case scenario: 1. copy a db2 file (which may be currently in use by the database) to a temp folder temp off of the application folder for now 2. read the copied db2 file and extract the database column names and data types 3. generate and execute tsql to create the table (target Microsoft SQL 2008 and higher) 4. generate and execute tsql to insert the data the 'bulk insert' might not work due to us running on a different system so something like sqlbulkcopy might be a better option 5. using the same process, export the data to a tab separated file Note - Item 4: this table will need to pair db2 types to standard...
.Net MVC5 database first using jQuery and Boostrap on the front end and MS SQL Enterprise Edition on the backend. Using MS visualstudio. 1) You will create controllers that consume objects in the repository and services projects (objects) 2) You will write methods in the services la...that provide logic to the controllers 3) You will create View and code them on the client side using jQuery 4) You will write AJAX functions in jQuery that consume the above objects and methods 5) The views will work on Mobile devices like tablets and phones, as well as Desktops Where are you located and what hours are you available for chats ? Can you code in TSQL ? How much experience do you have in the above including TSQL ? How many hours per week are you willing to devote to this an...
I need one or more perceptive programmers to assist me finishing a ASP.NET Control-Panel application. Before you apply, ask yourself if you can solve this guys problem: If you can solve above problem, and you also are an astute communicator, then I would be delighted to hear from you. I don't care i...you can solve above problem, and you also are an astute communicator, then I would be delighted to hear from you. I don't care if you are a still living in your moms basement, or if you are a mega-billion corporation, it's a question of programming and communication skills. Boilerplate cover-letters will be ignored and go unanswered. Obvious hard skills required are: ASP.NET, C#, TSQL, JS, TFS
PharmaHero es el primer comparador de farmacias y parafarmacias online que permite al cliente ahorrar hasta un 50% en sus compras. Buscamos desarrollador core con conocimientos de .NET, C#, TSQL, ASP.Net MVC, JavaScript, JQuery, AngularJS, XAML, TFS Asimimo se valorarán conocimientos de: Database - MongoDB - SQLServer - MySQL - Tunning - Indexes FrontEnd - HTML - CSS - JavaScript - FrameworksJS - PHP
Buscamos Programador en SQL SERVER, ASP CLASICO . Especialista en .ASP clásico y .NET (C#) Web no escritorio. Conocimientos en desarrollo MVC. Recomendable conociemintos Mysql. Desarrollo Web entorno Windows. Aplicaciones informáticas Online y Offline Lenguaje TSQL Base de Datos SQLServer 2008 R2: diseño, implementación y mantenimiento de base de datos, backaps. HTML, CSS, Javascript, JQuery (deseable conocimientos de Telerik, PHP, ) Conocimiento SQL Server
Se esta buscando desarrolladores Net C# para desarrollar una aplicación Web utilizando MVC4 o MVC5. Requisitos: Poder leer código VFP trata de una migración desde VFP 9 por lo que es imprescindible interpretar d...VFP trata de una migración desde VFP 9 por lo que es imprescindible interpretar dicho código. Alta disponibilidad horaria mensual. (No menos de 100 horas) Se valorará el conocimiento de HTML5, CSS3 y Boostrap (se entregará el HTML de todas las pantallas a realizar, por lo que no es requisito conocer el tema en profundidad) Se valorará experiencia con Scrum. Conocimientos de SQL Server y TSQL Se ofrece: Poder trabajar en forma remota (las reuniones de avance se realizarán preferentemente en forma remot...
We are developing at test for our organization - I require a SQL/report writer for 1 and a half hours on Oct 1st - 445pm Central Standard Time . ***YOU MUST BE AVAILABLE AND ON AT THIS TIME** You would screenshare with skype ...***YOU MUST BE AVAILABLE AND ON AT THIS TIME** You would screenshare with skype or another tool on my monitor which you would be asked sql and repoting questions. You must answer the questions fast and in a timely matter. Incorrect answers, not answering fast enough (wont be enough time to google or research answers) or not showing up will result in no pay. Questions would be around SQL - TSQL - Reporting Writing as well possibly crystal SAP/business reports etc... Please message me to let me know how you qualify and if you can be available at ...
Hi, Here is our requirement. ---- Project Environment: ASP.NET, .NET 4.5, C#, WCF, HTML, CSS, Javascript, JQuery, Bootstrap, Responsive UI, Google Analytics, TSQL (complex user functions & stored procs), SQL Server 2012, Visual Studio 2013, Visual Studio Express for Web 2013, Visual Studio Online (TFS in Cloud - for source control), Wikipedia REST API, Windows Server 2012, JSON, PhoneGap API, Windows 8 Mobile, HTML 5, Wordpress Forum (for Project tracking). ---- Website has 3 user modules (End User, Admin, Business User), 120 sql tables, 3-tier architecture (UAL/BAL/DAL). Most work is Integration work which requires deep understanding of existing code and writing of "missing code" after analyzing logic threads spread out to many files of many modules an...
Convert a tsql merge statement to a stored procedure for better performance.
Convert a tsql merge statement to a stored procedure for better performance.
We need a software developer that will join our team full time. Required skill are: c# development, visual studio 2013/2015, sql server, tsql, windows platform development know how. A small project will be delivered and evaluated before acceptance. Job will consists in interfaces implementation to extract, adapt and return data. New forms development, test of other forms and data analisys. Utility development. Web development knowledge or App development knowledge would be an added value to enhance some existing applications. WPF knowledge, devexpress, unit testing are welcome If you already applied to previous project please avoid.
MS SQL Server, TSQL, MySQL, Python. Web Marketing
want to work on Tsql and msbi project
I have a problem I cannot solve. I need to pass a table variable via a stored procedure from one database to another database, which of course is not allowed. I need someone to write the code for the workaround. You must know how to solve this problem in order to bid. I expect it is only a couple of hours work but we have requirements like this from time to time.
I have a problem I cannot solve. I need to pass a table variable from one database to another database, which of course is not allowed. I need someone to write the code for the workaround. You must know how to solve this problem in order to bid. I expect it is only a couple of hours work but we have requirements like this from time to time.
We are a small team who have launched several major startups in the ticketing marketplace. Our previous solutions set sales records in both music and sports, Pearl Jam for the fastest sellout and NASCAR for the biggest sellout. We have found a new problem to...interest and can address the items on this short list, we will send a more complete needs request and would like to schedule a call. We are outside the box thinkers and you must be flexible and experienced. Please send a resume or work experience directly to . Thanks SQL DBA needs and requirements General requirements: experience and knowledge of 1. Mammoth tables: million rows plus 2. TSQL coding and optimization 3. Transaction isolation and locking 4. Setting up security on individual db objects 5. Custom error ...
We need a software developer that will join our team full time. Required skill are: c# development, visual studio 2013, sql server, tsql, windows platform development know how. There will be need for interfaces implementation to extract, adapt and return data. New forms development, test of other forms and data analisys. Utility development. Web development knowledge or App development knowledge would be an added value to enhance some existing applications. Occasionally there could be the necessity to try new technologies or components such as WPF, new grids and so on.
We have a database with many stored procedures and functions. Some of the most important functions perform pretty badly. I know some bad practises are applied in these functions, but I have insufficient knowledge to rewrite them properly. For example a CURSOR is used, I use Multi-statement tables valued functions instead of inline, etc. I need an TSQL expert that can work on these functions and optimise them. Secondly we need to try and implement an Indexed View on some of these functions to generate a bigger performance increase (depending on how well the improvements on the function itself turn out). That also has some additional requirements that are not being met at the moment. For this project I will provide you with a sample database and pointers to what functions ar...
Need senior developers who knows java, coldfusion, php, html, tsql. Will be hired monthly for permanent basis to work homeoffice.
Need senior developers who knows java, coldfusion, php, html, tsql. Will be hired monthly for permanent basis to work homeoffice.
Need senior developers who knows java, coldfusion, php, html, tsql. Will be hired monthly for permanent basis to work homeoffice.
I have a small PHP page which pulls date from a TSQL database, formats it and presents it in a layout I've designed for printing or saving. The PHP is very poor, and the entire thing is amateur, but it's always worked. It uses sqlsrv_connect() and it fails when I attempt to use the same PHP on a modern server with IIS and PHP5+ I have rewritten the logic that makes the PHP complicated into a Stored Procedure (This work is already done) so all I need is: Script does some basic input checking, returning a form for entry of variables if it fails. If validated, it performs the query and populates a table with the results. The layout is fairly simple (very few CSS elements are used) and I'm happy playing with that after the results are at least being returne...
Preciso de programador para atuar em desenvolvimento de sistemas WEB, usando a tecnologia Asp.Net na linguagem C#, com o uso da Entity Framework e o DevExpress, com banco de dados SQLServer para consultas e regras de negócio. Interessados, enviar propostas!
Write 2 procedres in T-SQL. Write 2 procedures składowane in PL/SQL Write 2 triggers in T-SQL. Write 2 triggers in PL/SQL. - One must have [FOR EACH ROW] I can be the same questions but in 2 different languages. The task have to be meaningful business. Thanks!
