I require some SQL scripts to be written for some data contained in a spreadsheet. The data contains the plate number, entry time (Lane 2) and the Exit time (Lane 1) for vehicles. I need the following;
- Duration of stay during a day (Only duration over singe day, no overlap to next day) No duration given if an exit is not detected
- Number of repeat visits by same plate in a day, in a week, in a month.
We will use this script in our SQL database to create the required data.
Dear Sir/Madam I've excellent database design, SQL programming and development skills and knowledge. I can provide an efficient, perfect, well documented development of your Database project according to 100% accu Daha Fazla
Bu iş için 17 freelancer ortalamada $130 teklif veriyor
I am a MCSA SQL Server 2014 certified professional, with more than 10 years of experience with SQL related projects and tasks. I can do this in a full day. Also, I am a near-native English speaker. Relevant Skills and Daha Fazla
I have 5 years of experience working on Database including SQL, MySql, Oracle database etc. I am sure on completing the project successfully.
Hello, c I hope you are well, I seem asado what you ask this I can build it in a stored procedure in the database so that it returns the data that you are needing Habilidades y experiencia relevante My main skills in Daha Fazla