Create a SQL query according to my needs.

I have understood your requirement. Professional Experience - Highlights • 8+ years of experience in MS SQL Server development • 6+ years of experience in C# asp.net application development • 4+ years of experience in SSIS development • Health Care, Financial, Renewable Energy and E-Commerce domain Executive Summary • As part of the team, extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects. Capable of handling responsibilities independently as well as a proactive team member • Worked on web applications and windows applications using C#, asp.net, MS SQL server and SSIS technologies. • Developed more than 10 web applications, more than 3 windows applications using c#, asp.net and MS SQL server in Financial, Renewable Energy and E-Commerce domain. • Expert in developing complex store procedures, SQL scripts, efficient triggers, required functions, creating indexes and indexed views for performance. Experience in writing complex SQL queries involving multiple tables inner and outer joins • Experience in monitoring SQL Server Performance tuning, identifying dead locks and resolving them in SQL Server 2008 using SQL Profiler • Expert in designing ETL data flows using SSIS; Worked extensively on ETL process using SSIS package from Excel, Flat Files to SQL Server databases • Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging

For the info shared by you it is not clear which field is being used to decide if there are items remaining in the bin to be picked up. ========== Hi, I have gone through Excel sheet as well as the image and have understood the need. It is possible to share the additional columns of the database along with sample data to understand what all needs to be sorted based on criteria provided by you. Let me introduce myself as an database expert, I am currently working with a compnay as DBA. I have worked extensively on database design, writing SQL Queries,concepts like normalization, unique keys, foreign keys, procedures, triggers etc.. I have more than 10 years of working experience to my credit. My prime focus is 100% customer satisfaction. I will be happy to answer any queries that you may have. Looking forward to your response. Thanks

HI ! Do you need the script to sort items according to the image ? list "bin" in such an order that the picker go from 1 bin to another without wasting time. skipping aisle without needed bin and so on. do the data in the xls are the "bin's ID" to be sorted ? and they are provided in the right order too ? Feel free to contact me I am interested by such queries Rudy Frenchlancer You can do as follow : sort bins by Aisle, then process odd bin first and then even, then by process bin number if the bin is odd first as it is if the bin is even, just do a x -1 on the number sort the new bin number asc MYSQL SCRIP would be : select substring_index(bin,'-',1) * 1, substring_index(substring_index(bin,'-',-2),'-',1) *1 , mod(substring_index(substring_index(bin,'-',-2),'-',1) *1, 2), if( mod(substring_index(substring_index(bin,'-',-2),'-',1) *1,2) = 1, substring_index(substring_index(bin,'-',-2),'-',1) * 1, substring_index(substring_index(bin,'-',-2),'-',1) * -1 ) from bins order by substring_index(bin,'-',1) * 1 , mod(substring_index(substring_index(bin,'-',-2),'-',1) *1, 2) desc, if( mod(substring_index(substring_index(bin,'-',-2),'-',1) *1,2) = 1, substring_index(substring_index(bin,'-',-2),'-',1) * 1, substring_index(substring_index(bin,'-',-2),'-',1) * -1 )

We are team of excellent developers. We have 2 year experience related to your project field. We can do your project and solve your all problems according to your requirements. We have read your description for projects and we understand what you want so we are confident that we can do it easily in mention time. We assure you that you will be completely satisfy with our work. And after delivering your project if you feel some issue in understanding the projects then we will teach you free until you understand. If you have any question then feel free to ask. We are here for you. Thank you Demon Developer Team

I am a professional web designer and developer. Experience in with HTML, CSS, JS, jQuery, PHP, MySQL. Very familiar with WordPress,MAgento,wooCommerce,Bootstrap,Plugins,API's and its customization. I have a lot of experience in designing and development works. We can discuss any details over chat, Thanks :)

I can make this query within few hours. I working with Microsoft SQL Server as my main database for my projects.

Hi... i read the descriptions and understand i will provide quality work according to your requirement in given time period i will work on our project until you satisfy i am professionally software engineer(Present) having 2 year experience in this field you can check my portfolio. i will feel confidence to work with you....! Thanks

Hello, I have checked your details and you mentioned that you cannot add extra columns to the database. Can you show me a screenshot of how is the structure of your table? Regards, Alejandro

Dear Employer, Thank you for this wonderful opportunity. I have excellent experience in Website Designing/Development. I am professional website designer/developer. I have 8 years of experience in this field and can provide you my past sample work. I will be serving you with all my hard work and skills. My expertise is: -PHP,MySQL,WordPress,CodeIgniter,E-commerce,MAGENTO,ZEND,Opencart,Yii,AJAX, JavaScript,JQuery,OOPS, HTML,DHTML,HTML5,designing (bootstrap/responsive) [LAMP/WAMP] My skills and Enthusiasm as follows:- •Excellent interpersonal skills. •Consistently building rapport with clients and co-workers. •Knowledge and experience with front-end web technologies such as HTML/XHTML,CSS,XML,JSP and JavaScript with Ajax,JSON,jQuery,CodeIgniter,WordPress. •Advanced knowledge of back-end web technologies such as classic ASP,OOP PHP,Apache,mod_rewrite, WordPress,SQL,MySQL and relational database concepts. •Knowledge of modern business applications such as Dreamweaver CS5, Photoshop CS5, Bootstrap and custom responsive website designing. I highly value professionalism and hold myself strictly accountable to represent my client's brand. I believe that, with my skills, experience and attitudes, I can bring a lot to you. If you award me then I will complete your project within time frame and budget. I will build exactly as you want with excellent quality and accuracy. Hope to chat you soon with all details. Thank you for your time and consideration.

A proposal has not yet been provided