Looking for MSSQL Server Developer and SQL Specialist
$5-20 USD / hod.
Hi
I am currently looking to hire MSSQL Server Developer who is experienced in writing SQL coding for MSSQL databases. I am having set of queries or functions to be developed. The selected developer will be given a sample MSSQL database with set of queries to be developed. It will be a bonus if the bidder does have experience with the data of Spatial (Geometry) type in MSSQL Server.
PLEASE bid for this work ONLY if you are quite experienced with SQL coding for MSSQL Server and quite comfortable with such work
This work requires to be started immediately
In couple of hours, I will share with short listed bidder, sample MSSQL database with set of initially required queries. That is so confident bidders can confirm their interest and readiness to start immediately. I am using MSSQL Server 2008R2 Express version
In the attached excel file, their are four Fields: ID (autcomplete), File_Name, Date, Result.
***Data Description:
* Field: File_Name stores names of text files. Files: A, A_Rev1, A_Rev2 are regarded as having same file name but only different versions. Version of a file is noted by _Rev1, _Rev2, etc. It can also happen that the exact file name duplicates (e.g. A,A).
* Column: Date, stores the date which each file was created on.
***Required Result Field:
The Result field should be filled with the output integer value by the script required from this project. The intended value in the Result field shall assist to get the following:
- Latest file version: Here Result should be equal to 1111111, If their are more than files of the same name (e.g. A, A_Rev1, A_Rev2) or (e.g. A, A), then Result = 1111111 should be given to the file of the most recent date, and other files of the same name should be given the ID of the file having the most recent date.
- In case of files having same file names and also same Dates: Here Result will be equal to: 9999999. That is like the scenario (A.Date= Date1, A_Rev1 = Date1) or (A.Date= Date1, A.Date=Date1). If we are having scenario (A.Date = Date2, A_Rev1= Date1, A_Rev2 = Date1), then here it is clear that A file is having the latest date, and hence A.Result should be equal 111111, and A_Rev1.Result = A.ID, A_Rev2.Result = A.ID).
To clarify more, we will put Result equal to 9999999 ONLY if we can't determine which file is the latest file.
You will find above scenarios given as an example in the attached excel file. We will be having these data as a table in MSSQL Server, but number of records will be around 100000 records.
This is one SQL coding from many similar requirements which will be requiring in the coming days
Please send me confirmation of your interest to write the SQL code required to get the values for the field: Result and time required to do it.
Thanks
Identifikační číslo projektu: #5334530
O projektu
32 Freelnceři na váš projekt zveřejňují nabídky v průměru $14/hod.
Hi, I have 9 years experience in SQL Server 2005|2008|2008R2|2012 and involve in designing databases, Indexing Strategies, table partitioning, writing Stored Procedures, Triggers, functions and views. I have expe Další
Dear Sir, I'm expert with MS SQL Server, talent with T-SQL, and i'm interested on helping you. Best Regards, NourElDeen
Salam Alaikom, I'm very interested helping you creating your SQL script, I have more then 7 years of experience in SQL and database administration, modeling, optimizing and manipulating, please do not hesitate to che Další
Hi, please tell me detail on your job. I am good in MS SQL in geotry. I believe i can complete it on time.
Hi, I have over than 5 years of experience in SQLSERVER. Contact me and we will discuss further. Wait for your response. Best Regards Ghazi Oualha
Hi, i have 5+ years of exp in .net and sql server. i have developed many full application including db designs. please visit my profile for more details. we can discuss in chat for more clarification. Thanks Další
Hi. I am certified SQL Server expert (MCITP, MCSE). Ready to do this project for you. Regards, Yuri .
Greetings I would like to discuss in more details before placing a confirm bid. Let me know if you have some time to chat on Freelancer. Awaiting to hear from you,Have done similar work to your requirements in the pa Další
i have been writing 1000+ lines of queries for complex reports with performance optimization done, for the past 5yrs. please consider my bid.
Hello I am working on SQL Server 2005 now and have good experience.. I may help you out in solving problems by giving you set of queries and functions to maintain your database.. I am available more than 5hrs per Další
Hi, I have 10 years of experience in MS SQL Server and have very good expertise in creating SQL scripts. Regards Sri ==