Find Jobs
Hire Freelancers

t-sql help

₹100-400 INR / hour

Complété
Publié il y a plus d’un an

₹100-400 INR / hour

hi, I need to update a column for my table. I have updated a column ADDR which shows accounting date. Beacuse of this accounting date we know the items will match or not in the table. The problem with my UPDATE statement is that when the date is being picked up on monday, because of the date diff "sunday' is being picked up whereas it should pick friday. Now i have to use a case statement here as far i feel for this update statement one part:date diff will minus for the normal days other part:the moment it find sun, the diff should be -2 and pick friday date Could anyone help me
N° de projet : 35742321

Concernant le projet

5 propositions
Projet à distance
Actif à il y a 1 an

Cherchez-vous à gagner de l'argent ?

Avantages de faire une offre sur Freelancer

Fixez votre budget et vos délais
Soyez payé pour votre travail
Surlignez votre proposition
Il est gratuit de s'inscrire et de faire des offres sur des travaux
Décerné à :
Avatar de l'utilisateur
I can help you with sql server queries , please ping/connect me now I am available. Please check my reviews and project which I have completed. I can create sql queries for sql server database as per design, let me know when to proceed. I can work on future works for databases also if needed. I will work for cheapest budget within time, budget can be re negotiated again, send the details for the project. Please contact me asap. I have 12+ years of experience in database programming, website designing, powershell scripting and android development. Feel free to message me anytime if you need to discuss this further.
₹1 000 INR en 1 jour
5,0 (4 commentaires)
4,3
4,3
5 freelances proposent en moyenne ₹780 INR/heure pour ce travail
Avatar de l'utilisateur
Hello Friend ! We can do a 15-minute free call to discuss the project requirements and our work plan. I know "500-level things about Microsoft SQL Server". I have 7+ years of exceptional knowledge and experience in both Prod & Dev Environments. Please feel free to ask for adjustment if my Bid Amount or Hourly Rate does not suit your budget. "On 1st Jan 2023, I requested Microsoft for a feature improvement, which was accepted by Bob Ward, Principal Architect at Microsoft. Feature Improvement Request: 201 Buckets Problem, Histograms & Single 8KB Page Limitation, Statistics in SQL Server." Warm regards, Kundan Bihari (Freelance, Microsoft SQL Server Consultant.)
₹2 000 INR en 40 jours
5,0 (29 commentaires)
4,9
4,9
Avatar de l'utilisateur
Hi In my current Profession -I perfom the DBA and Developer duties in high traffic OLTP environment -Data Mining ,Data Science,Machine Learning -Python programing -data analysis using python and R -Data Scraping using python, -Database development in (Mysql,Postgres,SQlite and SQl) -Automation -Data warehousing on sql,mysql and postgres database (Star Schemas) and Business Intelligence systems development -Data extractions using Talend Open Studio,Python -Data Intergration using WSO2 ,Talend Open Studio -I have rich experienced in Database Administration, Excel -Data visualisation using Power BI,BIRT ,Jasper ,excel and Tableau -SQL server installations I am looking for the clear final requirements docs of your project so that I can start working immediately. If you need to discuss with me for any kind of suggestions or information, please knock me anytime. I am looking forward to hearing from you I can assure that if you work with me once, you will always work with me on these kind of projects and I can deliver quality and superior work at a price we are both comfortable with and within the agreed timeline. Kindly consider my bid.I will do whatever it takes to complete this project and earn a 5 star rating from you as well Kind Regards Takudzwa
₹400 INR en 40 jours
5,0 (30 commentaires)
4,7
4,7
Avatar de l'utilisateur
Hello, I have more than seven years of experience in the office and more than three years of freelance experience in the required task and would like to help you with this task. Thanks for posting in my area of work.
₹250 INR en 999 jours
5,0 (3 commentaires)
1,4
1,4
Avatar de l'utilisateur
I understand that the current update statement is not functioning properly when the date is picked up on Monday and instead of picking up the Friday date, it is picking up the Sunday date. Scope of Work: Analyze the current update statement and understand the issue Develop a case statement to correct the issue Test the updated statement to ensure that it is functioning properly Provide documentation on the update process and any necessary instructions for future reference.
₹250 INR en 40 jours
0,0 (0 commentaires)
0,0
0,0

À propos du client

Drapeau de INDIA
Sarojini Nagar Market, India
0,0
0
Membre depuis juin 13, 2016

Vérification du client

Autres travaux de ce client

chart at excel
₹100-400 INR / hour
Merci ! Nous vous avons envoyé un lien par e-mail afin de réclamer votre crédit gratuit.
Une erreur a eu lieu lors de l'envoi de votre e-mail. Veuillez réessayer.
Utilisateurs enregistrés Total des travaux publiés
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Chargement de l'aperçu
Permission donnée pour la géolocalisation.
Votre session de connexion a expiré et vous avez été déconnecté. Veuillez vous connecter à nouveau.