Find Jobs
Hire Freelancers

Solve a MS SQL problem

₹600-1500 INR

Mbyllur
Postuar about 6 years ago

₹600-1500 INR

Paguhet në dorëzim
I have log data and I'm trying to back-fill the data as much as possible to help improve analytics. The log data contains a SessionId, which is the SessionId created by the browser, the Name of the logged in user (if they are logged in) and a LogTime. I'm trying to get all the related sessions, sessions that are within 24 hours of each other, and get the first date of that group of sessions, the last date of that group of sessions and populate the first not null and not empty name into all the other name spaces. For instance, if I had the following data: --Id SessionId Name LogTime --1 1 2018-01-01 00:00 --2 1 LargeOne 2018-01-01 12:00 --3 2 Two 2018-01-01 13:00 --4 3 NULL 2018-01-02 00:00 --5 3 2018-01-03 00:00 --6 1 One 2018-01-03 00:00 --7 2 2018-01-03 00:00 --8 2 LargeTwo 2018-01-04 00:00 --9 1 2018-01-04 00:00 I would like to process the data as follows: --Id SessionId Name LogTime StartTime EndTime --1 1 LargeOne 2018-01-01 00:00 2018-01-01 00:00 2018-01-01 12:00 --2 1 LargeOne 2018-01-01 12:00 2018-01-01 00:00 2018-01-01 12:00 --3 2 Two 2018-01-01 13:00 2018-01-01 13:00 2018-01-01 13:00 --4 3 NULL 2018-01-02 00:00 2018-01-02 00:00 2018-01-03 00:00 --5 3 NULL 2018-01-03 00:00 2018-01-02 00:00 2018-01-03 00:00 --6 1 One 2018-01-03 00:00 2018-01-03 00:00 2018-01-04 00:00 --7 2 LargeTwo 2018-01-03 00:00 2018-01-03 00:00 2018-01-04 00:00 --8 2 LargeTwo 2018-01-04 00:00 2018-01-03 00:00 2018-01-04 00:00 --9 1 One 2018-01-04 00:00 2018-01-03 00:00 2018-01-04 00:00 Ids 1 and 2 are in the same session and in range (24 hours) of each other so they make one set, notice that the Id 1 doesn't have a name column but Id 2 does and because it's part of the same set, it backfills the name. Ids 6 and 9 are also in session 1 but is not in the 24 hour range of the first set so it makes a new set, Ids 6 and 9 are both in session 1 and even though new sessions appear between them, they are still the same session within range so they make a new set. I've attached the full question and what I've tried as a txt file.
ID e Projektit: 16475519

Rreth projektit

6 propozime
Projekt në distancë
Aktive 6 yrs ago

Po kërkoni të fitoni para?

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj
Paguhuni për punën tuaj
Përshkruani propozimin tuaj
Është falas të regjistrohesh dhe të bësh oferta për punë
6 freelancers are bidding on average ₹1 317 INR for this job
Avatari i Përdoruesit
i have solution for this. And i migrated many database from one to to another. well knowledge in sql queries
₹1 300 INR në 1 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
Hello Sir, I have not found any attached file but i understand the requirement. I can do this task within a day. We have 6+ years experience in PHP, MySQL and Website Designing. Please enable chat for more details. regards: Autarkic Infotech
₹2 000 INR në 1 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
A proposal has not yet been provided
₹1 250 INR në 2 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
A proposal has not yet been provided
₹1 500 INR në 1 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
Hi I am a software engineer with a strong expertise in sql. I write queries, stored procedures and reports using SSMS and SSRS everyday at my day job. Let’s talk more about what all you have and what you need to so I can get started for you.
₹1 250 INR në 3 ditë
0,0 (0 përshtypje)
0,0
0,0

Rreth klientit

Flamuri i INDIA
India
0,0
0
Anëtar që nga mar 12, 2018

Verifikimi i klientit

Punë të tjera nga ky klient

Web development
$30-250 USD
Faleminderit! Ne ju kemi dërguar me email një lidhje për të kërkuar kredinë tuaj falas.
Ndodhi një gabim gjatë dërgimit të email-it tuaj. Ju lutemi provoni përsëri.
Përdorues të regjistruar Punë të postuara
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Po ngarkohet shikimi paraprak
Leja u dha për Geolocation.
Seanca e hyrjes ka skaduar dhe ke dalë. Hyr sërish.