...(checking video before visible to users or public), arranging videos and setting video ordering on pages 3. 100% secured website from XSS, CSRF, Direct Object References, SQL injection etc. T We will provide the Mobile App UI designs (jpg images of app screens) for understanding the functionality only. The website need to look same as app. So the app design
...variables and pls comment what the code lines stand for. I have a basic understandment but not that much. Don´t make the site too complicated just a simple code. It needs two sql statements. One to read and one to write(insert). I have the read sql statement already so only the insert statement is left. I would like as an insert statement to see a guestbook
I have update statements that presently work by me feeding it 1 itemnumber at a time. i need a UPDATE CURSOR to let me feed a list of 2500 items to it from a select statement and run the update statement and go to the next.
I need this asap. should take an experienced sql guy an hour. I need these sql statements put together so it brings back one dataset from the stored procedure. Its a legacy system so please forgive the backticks in the field names: There are three tables, Apoteek_data, holds all the information about products given out. ZINummer, a master
...application for Managing a Vaccinations for children to handle dose of Vaccinations and kind using C#.Net with a MS SQL Server 2012 DB. • Currently developing a web application for Managing learning online for "T-Thinkers" using C#.Net with a MS SQL Server 2008 DB and ASP. Net. • Developed a windows application for Managing a Food Store Market to hand...
I want to implement a dashboard(with KPIs) for an online store of [log ind for at se URL] will need to create a database to provide you the data(so you won`t have real numbers to work with) for the following KPIs:daily sales, conversion rate, site traffic, shopping cart abandonment rate, traffic sources, promotional click-through rates, social shares, bounce rates
...WebAPI developer on Microsoft stack. C#, .NET framework, MVC Framework, WebAPI, Entity Framework, T-SQL IIS, MS SQL Server, Azure Cloud Platform Experience with OWIN and ASP.NET Core (This will be harder to find) Experience with Code First and MS SQL Server Experience with RESTful API design and Swagger Experience with Web Services and Web APIs on
Experience working in complex (enterprise-level) SQL Server environments • Experience with a wide variety of hardware configurations (SAN, flash storage, etc.) • Experience in complex T-SQL development (advanced skills) • Full understanding of SQL Server internals • Expert-level understanding of execution plan analysis and query tuning • E...
Hello , t I have developed a project on ASP MVC platform . I have used sql as backend. It is a saas platform , My my all clinets has records of around 300,000 people in their accounts. My problem is when they are searching for specific added records or any person name in their database then search is taking too much time , also search is not user
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
don t bid if you don t know the CI need to fetch data from relational table,its minor brain storming task. sql is ready
Poszukujemy partnera do współpracy przy modernizacji oraz rozwoju autorskiego oprogramowania wewnętrznego firmy. Wymagamy - biegłej znajomości programowania w języku C#, T-Sql - podstawowej znajomości HTML/CSS - bardzo dobrej organizacji pracy, umiejętności zarządzania projektami, kreatywności oraz otwartości - dużego zaangażowanie w wykonywaną
800 word...SECURITY(look at the series of questions and the python file ). reject anyone who doesn`t know about security and python, the person accepts this project must know the knowledge about key hashes, a buffer overflow, both knowledge about python and java(compare these two), SQL injection attack. please read before accept this project, thanks
I am updating our ERP from our CRM to add a new account. I have a table that has a batch of records to insert. Each record in the batch table will be used to insert into about 20 tables for the new account. I'm using a stored procedure with a cursor. I want to try each insert, If any insert fails all need to be removed. The errors need to be logged to a table and I have a script that does tha...
T-SQL Coding Transformations for ERP CRM Bridge We're developing a Bridge for our ERP CRM. The bridge synchronizes data between the two applications. When a record in the CRM is approved it is inserted into the Bridge Changes table. At an interval of 15 minutes the Changes are inserted to our ERP as new records. Transactions coding is different
...max_length ,C.is_nullable FROM [log ind for at se URL] C INNER JOIN [log ind for at se URL] tb ON tb.[object_id] = C.[object_id] INNER JOIN [log ind for at se URL] T ON C.system_type_id = T.user_type_id --INNER JOIN -- [log ind for at se URL] TF ON TF.PC_Column = [log ind for at se URL] WHERE tb.[is_ms_ship...
... ,C.max_length ,C.is_nullable FROM [log ind for at se URL] C INNER JOIN [log ind for at se URL] tb ON tb.[object_id] = C.[object_id] INNER JOIN [log ind for at se URL] T ON C.system_type_id = T.user_type_id --INNER JOIN [log ind for at se URL] TF ON TF.PC_Column = [log ind for at se URL] WHERE tb.[is_m...
We are looking for a C# Developer to help our team with the delivery of solutions that drive and support business growth. Experience required It...Experience required It is essential that you are degree educated and have proven experience in a business environment of the following: NET (Web Forms) or MVC C# Agile (Scrum) T-SQL JQuery or equivalent
I can select these columns but when I try to join them i the Like clause I get errors T-SQL Errors multi-part identifier "[log ind for at se URL]" could not be bound, Could not find server 'Bridge_test' in sys.servers. In a stored procedure, sql server 2008r. SELECT CountryId from powercampustest.dbo.CODE_COUNTRY --pass SELECT LONG_DESC
...- Static content -- Privacy -- T&C -- Help section with subsections -- Sitemap -- About -- Contact page - Live chat integration with existing providers - Responsive UI - SEO friendly Preferred technologies from Microsoft stack: - .NET Core 1.1 - ASP.NET MVC 6 and WebAPI - Entity Framework Core - SQL Server - Angular 4 - Bootstrap
...corier script : 1) Add bank SQL into DB 2)when create trackid posibility to edit default bank details 3)show bank details on pdf invoice 4) show bank details if is unpaid when user search trackid 5)add on admin menu bank details (for default bank details) is easy job this mean it can be done into 30-60 minutes. don t bid if you not programer
I am inserting records from our crm to our erp. The phone tabl...PEOPLECHANGES, need to join union all select PersonId,'Cell', 3333333333 from @IdentityID --3333333333 will be phone number column from PEOPLECHANGES, --need to join SQL Server 2008r Please reply with the time of day you are available. I am available 8am to 3pm UTC -06:00
...reporting statistical findings to work colleagues and senior managers Manipulating, cleansing & processing data using Excel, Access and SQL. Analyzing raw data, drawing conclusions & developing recommendations Writing T-SQL scripts to manipulate data for data loads and extracts. Interacting with customers for process related clarifications. Reporting
...MS Access application with lots of VBA code. The data is stored in SQL server and some of the code (currency conversion, finding cheapest supplier) is written in T-SQL (functions and stored procedures) on SQL server. MS Access and VBA skills are most important for this product. SQL Server skills are nice to have. We have a test database in the cloud
Urgent! If you`re not able to realize it quick - please, don`t respond. We`re looking for somebody to convert huge SQL file which doesn`t content any relationship with JSON. Also, conversion of all fields including HTML to markdown.
We need to track the time when our truck driver deliver the product to the clients every day. The application ...the web application part. The mobile application part for the driver should be work for android and be able to read the data set by day. We don´t have any specific requirement for the database, could be on sql or any any file on the cloud.
...Middle_Name, [log ind for at se URL], '1234', 'n', GetDate(), GetDate(), 'SCT', '1', GetDate(), GetDate(), 'PGHERE', '1', 'n' FROM [log ind for at se URL] i CROSS APPLY [log ind for at se URL]([log ind for at se URL]) T WHERE [log ind for at se URL] = '31-ATE' OR ([log ind for at se URL] = ...
...format, prefix first middle last suffix. Not all parts may be included. Most commonly there may be no middle name, prefix, or suffix. I want to be able to accomplish this in SQL not using any platform dependent functions so it can be a platform independent bridge. I tried some code but the suffix Jr. gets stuffed in with the last name. It may be that
...two applications and ERP and CRM. I'm using a table for changes with a column to mark Y after processed and a stored procedure that will run on a 15 minute interval with the sql server agent. When I run the batch I need to check for any missed records in the event that the last batch batch didn't run. I need a way to determine how to check that the
...be developed for Windows using SQL. This is the specific job:
Top 3 Required Skills/Experience
• Microsoft SQL Server; Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS) , 2 – 4 years’ experience with SQL Server tools such as SSIS and SSAS
• T-SQL queries;
...data will be stored in sql server db via php web service. What I have already done. 1. have installed Visual Studio Code (VSC) Editor . 2. Installed latest version of node js. 3. Installed ionic and cordova and did "Hello World" Program 4. I have Created simple Ionic project using ([log ind for at se URL]) You have to
...handout, Page 5. If you can’t figure out how to do it, just show ProdId and Descrip. No points will be deducted.) 4. Find all employees whose names start with either an S, A, or T whether it comes in lower case or upper case. List all information about each employee in the output. Even though this query can be done without using a function, to receive full
...Microsoft .NET framework. · 5+ years of experience designing, developing, and supporting web applications. · Must be experienced in Microsoft SQL server. Specifically database design t-sql, and stored procedures. · Must be experienced in Internet Information Server (IIS) and Visual Studio. · Experience building and...
I need to learn SQL SERVER REPORTING SERVICES (SSRS) using SSDT(Sequel Server Data Tools) and Report Builder (SQL Server 2016). I do have all the software required and installed in my machine including administrator access to my SQL Server 2016 Management Studio. I have basic knowledge of T-SQL but need more help with that too. In a nutshell I will
I a looking for a coder to assist me with my current MS Access application...and MSSQL 2012 BE. I need assistance with some Stored Procedures, Functions and some VBA. I will be working on the GUI and general VBA and SQL coding, but i just need assistance with the more complicated T-SQL, Stored Procedures/Function etc. Happy to answer any questions.