I need sql query that do the following
[url removed, login to view] certain items from items table.
2..Select certain restaurants from restaurants table.
[url removed, login to view] sum of items quantity from RequisitionDetails table for each restaurant in certain date.
[url removed, login to view] item not existed in selected date or not existed in RequisitionDetails table at all for certain restaurant it should be empty.
[url removed, login to view] the total
data base backup and script are included in the attachment.
out put should be like this
Cod ItemName Unit res1 res 2 res3 Total
1 item1 kg [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view]
2 item2 kg [url removed, login to view] Null [url removed, login to view] [url removed, login to view]
Este proyecto fue adjudicado a
6 stars! He understands the requirements very clearly and gave me the perfect result straight forward. While other freelancers trying to take time. bhaveshghodasara is a good English speaker so that there was no problem to communicate. I will definitely hire him again if I need more services that also he provides.
¿Buscas ganar algo de dinero?
- Establece tu presupuesto y el plazo
- Describe tu propuesta
- Recibe dinero por tu trabajo
Ofertas en este proyecto
Experienced and professional with a passion for all things data. sql, Oracle, vba, ssis, abap, excel
I am an experienced C#.net developer, focused on pragmatic solutions, with a passion for identifying and implementing the right pattern and approach for each task. I've been developing software targeting wide variety of domains, ranging from building cross browser compatible websites, to ‘n’ tier multi-threaded enterprise applications, with increasing use of design patterns, pair programming and test driven development techniques. Currently developing software using cutting edge technologies like bootstrap, Jquery, angular.js, etc. My Motive is to make my employer happy without adding additional charges. I have developed a lot of Desktop applications and web development too.
- Database SQL Expert - Microsoft SQL Server (ver. 2000/2005/2008/2012/2014) - Stored procedure, view, triggers, function - Data manipulation - Data migration - Data import / export
Expert web-scrapper, database designer and excel programmer.
Hi, I have good knowledge of C/C++/Java/Python programming on Linux, Windows and Mac OS. I have knowledge about Mathematics , and any Computer related concept such as Algorithms, Data Structures, Networking, Cryptography, Databases, Operating Systems , Compilers, Data Mining etc. I also have experience related to web. Feel free to discuss your project with me in these domains or any other relevant domain. I ensure 24*7 Support.
S. Cipriano Picentino (SA), Italy
I am a passionate programmer and software architect with over 14 years of experience in design and development client/server, web based and n-tier application, using Microsoft .NET and SQL Server. I have good technical and analytical experience and problem solving skill. I have managed international projects in healthcare domain. Over the years I have led teams of developers and leading the production process of framework and business solution. I received the B.S. degree in Computer Science from the University of Salerno. More info: https://it.linkedin.com/in/angnut