Refine 2x MS-SQL queries into one for a view

Hello, I have read your requirements and I can help to merge into one select. I have 6.2+ years of experience and I have developed complex queries with very good performance of larger database. I have worked with GPS tracking system which have lots of vehicles and almost we are getting 20,00,000 records per day and we have managed queries to do faster execution. Also I have developed many more. Please let me do it for you. Thanks. Best Regards, Nagajan Kariya Please le

Hello, I have read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I am having 7+ years of experience in Web Development. I have worked on below technologies/languages/database server. - Asp.net,C#.net, MVC - Linq to SQL,Entity Framework - Jquery,AngularJS,NodeJS - Crystal Reports,DevExpress Reports - SQL server,SSIS Package,SSRS Reports - Web API 2, WCF Rest WebService - Application Security Remediation,Penetration Testing,OWASP 10 - SVN,TFS,Git I love working on SQL and query/sp optimization . I can achieve the results that you are looking for. We can discuss further on chat. Looking forward from your end. Thanks

Hi! i'm senior lecturer on databases with 10+ years experience in MS SQL Server. I can change your scripts with temporary table to on select statement.

I have a 3 years of an experience in SQL Server Database Administration. Following are my skill sets : T-SQL, Writing Complex Queries, Stored Procedures, Auditing Triggers, Database Administration, Database Mirroring , Replication, Log Shipping, AlwaysOn Availability ,Performance Tuning , Database Optimization, Query Tuning, Monitor SQL by wait stats , performance monitor and DMs.

Hi there, Send me your queries and I will revritw thwm to VIEW. I also need database example or just DB schema. What I can promise is that you'll pay me only if you are 100% satisfied. Regards, Tom

Hi I am an expert in SQL. I have around 10 years of experience in writing SQL queries. I can help you create the view without the temp table. Let me know if you are interested. It might take me 30 mins to an hour to create the view. I am still online for next 30 mins. Thanks

Hello, I am interested in your project. I am a software engineer and I have professional experience with SQL. Could you please send me more details about your project? Thank you, Best regards, David

I can accomplish this by sub query concept.

.........................................................................................................................................

I'm a software developer with 4+ years of experience working on erp software solutions,accounting solutions, payroll solutions,pos solutions using microsoft sql as back end, i'm very experienced in microsoft sql, t-sql, stored procedures, triggers, view etc etc

working as MS SQL developer from 5.5 years

hi, could you give me sample schema and those 2 queries?

To learn more about me search by name Khalid Hussain MBA in LinkedIn

I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administration and maintenance with Linux/Unix and Windows Networking.

I've been working with SQL Server for 10 + years in both administration and as a developer. I would be able to solve your issue easily and provide fast results.

This sound very intriguing. I should be able to complete this for you very quickly. Thank you for your consideration. -Thomas

Hello, I could do that for you. I just need access to the database or database access and the current sql code. Sincerely cheapandeasyz

Hi, I have Eight years of working experience in software/Web development field. Over the three years I am mainly working PHP, Apache, Wordpress, Javascript, jQuery etc technologies, .NET/ASP.NET, WPF and SQL Server, MySQL, PGSQL etc DB based desktop, web, back-end, Cross knowledge, Social Text etc API related apps. I've experience to work in different type of applications such as standard Web, Social Web, Web wiki, Forum, HRM, Accounting, DB Migration, API integration, file/data import/export from/to DB/files etc. Recent works have been done and in progress on PHP, Apache, Wordpress, Javascript, jQuery etc technologies, .NET/ASP.NET, WPF and SQL Server, MySQL, PGSQL etc DB based desktop, web, back-end, Cross knowledge, Social Text etc API related apps. I have working in Asterisk, Dahdi, SIP, VPN, Linux, CEntOS, Natting, PHP, MYSQL, API Integration, and Networks Administration & System Administration as well. I am perfect solutions for you and complete this with dedication and efficiently. Thanks Furqan Ahmed Ghauri

i am dealing with this kind of stuff every day. :)

Understood Ur Requirement . Not a Problem at all . You may call me 24x7 to my number :+91-9038030838