Find Jobs
Hire Freelancers

t-sql help

₹100-400 INR / hour

Finalizat
Data postării: peste 1 an în urmă

₹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
ID-ul proiectului: 35742321

Despre proiect

5 propuneri
Proiect la distanță
Activ: 1 an în urmă

Vrei să câștigi bani?

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal
Îți primești plata pentru serviciile prestate
Evidențiază-ți propunerea
Te înregistrezi și licitezi gratuit pentru proiecte
Acordat utilizatorului:
Avatarul utilizatorului
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 în 1 zi
5,0 (4 recenzii)
4,3
4,3
5 freelanceri plasează o ofertă medie de ₹780 INR/oră pentru proiect
Avatarul utilizatorului
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 în 40 zile
5,0 (29 recenzii)
4,9
4,9
Avatarul utilizatorului
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 în 40 zile
5,0 (30 recenzii)
4,7
4,7
Avatarul utilizatorului
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 în 999 zile
5,0 (3 recenzii)
1,4
1,4
Avatarul utilizatorului
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 în 40 zile
0,0 (0 recenzii)
0,0
0,0

Despre client

Steagul INDIA
Sarojini Nagar Market, India
0,0
0
Membru din iun. 13, 2016

Verificarea clientului

Alte proiecte ale acestui client

chart at excel
₹100-400 INR / hour
Mulțumim! Ți-am trimis prin e-mail linkul pe care trebuie să-l accesezi pentru a revendica creditul gratuit.
A apărut o eroare la trimiterea e-mailului. Încearcă din nou.
Utilizatori înregistrați Totalul proiectelor postate
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Se încarcă previzualizarea
S-a oferit permisiunea de depistare a locației.
Ți-a expirat sesiunea pentru conectare sau te-ai deconectat. Conectează-te din nou.