Tsql jobs
...who can build, maintain, migrate, and customize. Responsibilities -Build customizations for the company's Dynamics GP system -Modify GP modules and third party products -Implement modules and third party products as needed -Design and create integrations with Dynamics GP and third-party products -Design and develop reports on SQL based platforms, including SSRS. -Write and troubleshooting TSQL code -Perform SQL server administration as needed -Build Integrations with third party partners and customers Requirements -Bachelor’s degree or equivalent experience -4+ years of MS Dynamics GP / Great Plains experience -4+ years with .NET development -4+ years of MS SQL as well as SSRS - developing Microsoft SQL custom tables/views, stored procedures, trigge...
...Skills Requirement: • At least 4+ years of developing .net web applications and working in agile environment. • Possesses Enterprise development experience. • Expert knowledge of Object Oriented Programming and design patterns. • Expert knowledge of C#, .NET platform, ASP.NET Ajax, JavaScript and/or jQuery, HTML/DOM/CSS • Experience in Web services and WCF technologies • Knowledge of , TSQL and stored procedure development. • Practical knowledge of using Telerik components will be a bonus Please include answers to these questions in your proposal: • How many hours per week can you dedicate to our projects? • What is your proficiency level in ASP.Net, MVC, C#, MSSQLServer? • Do you have experience in using Telerik Dev...
Create complex SQL reports for various business units (accounting, sales...business units (accounting, sales, purchasing, inventory) Write simple ad-hoc queries for end users Implement new BI and online platform Design beautiful executive dashboards for stakeholders Gather knowledge and document report requirements Analyze and improve business process improvement using data QA to reconcile results Track metrics, trends, KPIs Technical Skills: SQL/SSRS 2012 --- TSQL queries, stored procedures, functions ERP software -- Microsoft Dynamics GP (Great Plains) a big+ Excel (i.e. Vlookup, Pivots) Basic understanding of Accounting and Inventory concepts Business Intelligence Tools (PowerBI, bi360, Jet Reports, Management Reporter) Preferred: SalesPad, WMS, Ecommerce, Bud...
...build an e-commerce full stack website with Django (Python) using continuous integration and continuous delivery and deployment tools. Preferably (Jenkins and Docker). I need to learn how to develop full stack from zero to one! I am not too interested in the front end or UI. I know web development, I have develop websites AJAX/Java for back end, I know about data structures, I have used MySQL and TSQL before. By the end of the project I want to be able to develop and deploy a full, complete and useful website with Django (Python) and I want to be familiarize with the CI and CD tools. Also, my main focus will be developing the website but I want to know and understand DevOps (CI and CD). I am a fast learner and this is the way that I learn with a one and one experience! This shou...
Need ETL and Database developer with strong knowledge in T-SQL. Have to have strong background in writing sophisticated Stored Procedures. Must have 5 years of working knowledge in enterprise level. - Must have good communication - Industry Knowledge Preferred: Finance, Healthcare etc development. If you looking to make some good money please contact me. Thanks!
I need someone that can write a TSQL code to add new product to nopcommercer using as a source another SQL Server database. The code need to be able to add new product and add image also from a SQL Server table
...technology experience with at least 4-6 years hands-on technical roles in the field and relies on experience and judgment to plan and accomplish goals. Strong background with the following: C#.NET ASP.NET, MVC Javascript, AngularJS 2/4. Pubnub VisualBasic 6 Database knowledge, including tuning, access, and ability to converse in common language with Database Administrators using SQLServer TSQL programming language Good working knowledge of database design, Microsoft Office Products, Visual Studio, and Microsoft Visio Possesses an understanding of CI tools (GitHub, Jenkins, NuGet, Arifactory, Octopus Deploy). Visual Studio Team System Development tools - VB.NET, ASP.NET and C#; o Experience in working with various versions of .NET Frameworks (1.1, 2.0, 3.5, and 4.0). ...
...technology experience with at least 4-6 years hands-on technical roles in the field and relies on experience and judgment to plan and accomplish goals. Strong background with the following: C#.NET ASP.NET, MVC Javascript, AngularJS 2/4. Pubnub VisualBasic 6 Database knowledge, including tuning, access, and ability to converse in common language with Database Administrators using SQLServer TSQL programming language Good working knowledge of database design, Microsoft Office Products, Visual Studio, and Microsoft Visio Possesses an understanding of CI tools (GitHub, Jenkins, NuGet, Arifactory, Octopus Deploy). Visual Studio Team System Development tools - VB.NET, ASP.NET and C#; o Experience in working with various versions of .NET Frameworks (1.1, 2.0, 3.5, and 4.0)....
I require approximately 50 stored procedures in Oracle PL-SQL to be converted to MS SQL Server T-SQL
I require approximately 50 stored procedures in Oracle PL-SQL to be converted to MS SQL Server T-SQL
...working 30-40 hours per week on an ongoing basis to start ASAP for an awesome company! If you are interested and think you fit the bill, please apply immediately and answer the questions for a chance to land the role. The development questions are open-ended for your expansive interpretation. Consider these as an invitation to 'show-off' your talent as an infrastructure professional. 1) Write a TSQL script to generate triggers so as to save the cumulative row count per object of all DML operations in a database. 2) Write powershell to search and replace a database connection string used by IIS on a server farm of 500 servers. 3) We like to understand who we work with and value (to a small extent) MBTI profiling. Visit , complete the personality as...
We are looking for an AngularJS Developer responsible for the client side of our service. Your primary focus will be to implement a complete user interface in the form of a mobile and desk...vanilla JS to using a custom wrapper around $resource • Experience with building the infrastructure for serving the front-end app and assets • Architecting and automating the build process for production, using task runners or scripts • Creating configuration, build, and test scripts for Continuous Integration environments • Experience with Google APIs for Maps • Experience with MS SQL Server and TSQL • Experience with JAVA, Tomcat, Spring, JPA for API. Position will be Temp and after 4 weeks evaluation, possible for long. Candidate must be able to work du...
Need someone to fix issues with site and provide ongoing support. Need someone available on EST The skills required are below VB.NET Windows Azure MS SQL Server TSQL Telerik JS IIS
I have a query which runs fast when the date clause "and datediff(day,con2.DT_DateIncluded),'2017-01-01')<=0" in the code below isn't used in the query, but runs slowly when it is included. Though it runs fast when I run just the part "select top 2 ID_Contact...", even including the date clause. I have this query on a classic ASP application, and it can't be converted in to a stored procedure (project scope reasons). Can you help me find a way to improve the performance of the full query just by changing the query code? Obs: I have already tried: con2.DT_DateIncluded >= '2017-01-01'. select distinct top 10 ID_Contact, NO_CodCompany from tblContacts con1 where ID_Contact in ( select top 2 ID_Contact from tblContacts con2 inner ...
Need someone to fix issues with site and provide ongoing support. Need someone available on EST The skills required are below VB.NET Windows Azure MS SQL Server TSQL Telerik JS IIS
Looking for tsql and BI expert who can help me to optimize newly created billing process.
Looking for tsql and BI expert who can help me to optimize newly created billing process.
Looking for tsql and BI expert who can help me to optimize newly created billing process.
I have a stored procedure that carries out 4 separate INSERTs into 4 different tables. The issue is that 2 of these tables frequently have other locks on them which means that the tables are locked and the INSERT has to wait; so the entire storedprocedure takes a long time to complete. I want to decouple these two INSERTs, so if these 2 are blocked the stored procedu...these two INSERTs, so if these 2 are blocked the stored procedure still continues. I want to do this with minimal changes to the stored procedure as it passes input parameters. I was thinking of using dynamic SQL and passing out these INSERTS with either xp_cmdshell and sqlcmd to create a new session (decouple) or uise sp_executesql or exec to do the same. Need assistance from a more experienced TSQL programmer....
Looking for a professional in Atlanta who can teach T-SQL course class. from the basics of T-SQL. Teach T-SQL features step by step, using SQL Server Express 2012, teach how to use AdventureWorks 2012 as a database. Along the way teaching the students how to create their own sample databases to illustrate some key points. make AdventureWorks 2012 the main focus. As far as T-SQL, start with the simple select statements and add new features as we go. introduce to students data types available so they can make the appropriate selection when creating a about joins, functions, tables, procedures, triggers, indexes, and much more.
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/2014, Visual Studio 2013/2015, Visual Studio Online (TFS in Cloud - for source control), Wikipedia REST API, Windows Server 2012, JSON, HTML 5, Microsoft Teams (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 and into database functions/stored procs. Complete withi...
...can support us remotely preferably working during 4 PM to 12.30 PM IST. Prefered location of the candidate would be Coimbatore or remote. Principal Activities: Monitor performance and propose enhancements to T-SQL queries Support Development efforts and enforce SQL standards and best practices Build and maintain SSIS Packages for ETL processes Required core skills: 5+ years of SQL Server, TSQL Expert in stored procedures, triggers, functions using T-SQL Expert level experience in SSIS Strong experience in techniques to Extract and Transform data from various data sources and Load to the Transactional/Dimensional Databases Performance tuning and troubleshooting Required supporting skills: Exceptional problem solving abilities and communication skills, both verbal a...
We have a website and for timing issues we'd like to hire a developer to help us out developing some new modules that still need to be done. We need a developer with high experience with ReactJS, JQuery, C#, NancyFx, Sql Server, TSQL, , Reflection, Razor, GIT. Knowledge with AngularJS 2, APIs, NativeScript, and Braintree will be appreciated. We are using Git as our Version Control System and Visual Studio. Experience and feed back from design and UX perspective will be also appreciated. We will give the job to the person that SHOWS that knows how to work with it, not just the one that SAYS can do it. So please reply the questions with samples that do it. Only saying you can is not enough. We can provide any info, code or help that help you showing what you need to te...
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 lay...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 6) You will trace and debug code that has recently been developed This could turn into a very large project. 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...
Hi I need someone who is good in converting MySQL scripts to MS SQL 2008. These scripts (approx 7-8) are not very complex and are mainly mainly pivot query that returns data from a two tables. Please find attached a sample script. I will provide the backup of MSSQL database as well as MySQL database if you need. I need the data format to be exactly as that of what is being returned from the existing MySQL scripts. Thank you for your interest.
I need an SQL Develper to help with writing some Stored Procedures and Re-writing some TSQL Queries that are running slow; I only need experienced developers who know what they are doing i.e. 5years + Experience
...Webservices, WCF, WPF. - Evaluates systems specifications for client area web site requirements and determines and implements the most efficient and cost effective software/package solution. - Researches and tracks new web technologies, develops service applications, and analyzes business requirements as they pertain to web-based systems. Required Experience: • 7+ years database experience with TSQL (SQL Server) and PLSQL/Oracle Demonstrated solid application development skills utilizing .NET framework 4.0, C#, ASP.NET, AJAX, Java Script, HTML, XML, Webservices, WCF, WPF, JQuery, JIRA.• Knowledge of MVVM and MVC design patterns. • 5+ years background in OO design and programming, knowledge of UML and modern software engineering practices • Experience in NHi...
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,
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
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...
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...
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' + ...
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
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.