Đã Đóng

i need MS SQL expert

i need MSSQL expert to work right now for small project

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

or

I tried to put up this bid previously with my Stack Overflow question, I'm happy for you to give me the answer via freelancer so that I can't avoid paying you, i just think it's easier to read on SO that on that txt file

[url removed, login to view]

Kĩ năng: .NET, Lập trình C#, Quản trị cơ sở dữ liệu, Microsoft SQL Server, SQL

Xem nhiều hơn: sql help online free, sql live help, sql experts online, sql chat room, i need help with sql, free sql help, expert sql, how to become expert in sql server developer, Trainer need for ms sql ssrs, ms access and sql expert freelance, need ms excel expert in nagpur, sql expert need, years need spend become expert redhat linux, sql script mssql, can open sql report mssql vbnet

Về Bên Thuê:
( 0 nhận xét ) India

ID dự án: #16488759

19 freelancer đang chào giá trung bình ₹12689 cho công việc này

rinsadsl

HI, I am expert in SQL query and I can help you in creating sql commands. I couldn't find any attachment in the bid

₹13888 INR trong 5 ngày
(97 Nhận xét)
6.6
ashupathania

A proposal has not yet been provided

₹11666 INR trong 3 ngày
(29 Nhận xét)
5.1
vinaysinghh

A proposal has not yet been provided

₹5555 INR trong 3 ngày
(47 Nhận xét)
5.2
bnrajumnc

A proposal has not yet been provided

₹5555 INR trong 3 ngày
(9 Nhận xét)
3.6
supergana

Hi - Getting his in a single query is going to make it way too complex with nested statements. Best suggestion is to go for a stored procedure with some views and queries on it. Will be happy to discuss further details Thêm

₹9998 INR trong 2 ngày
(4 Nhận xét)
3.1
₹7777 INR trong 3 ngày
(4 Nhận xét)
2.9
₹7777 INR trong 3 ngày
(6 Nhận xét)
2.6
sqldelivery

I have great experience in application log analyzing through SQL so i think my skills will help to resolve your task in effective way.

₹13888 INR trong 3 ngày
(1 Nhận xét)
1.6
adnanshafi91

Sir, i will do my best . This is my first project, just one chance to proof my self vry hard working Relevant Skills and Experience What kind of problem you have face . Let me know then i will give you the solutions .

₹7777 INR trong 3 ngày
(0 Nhận xét)
0.0
ashokkumar0101

I have rich 10+ years experience in MS Sql developer com developer. I have designed 50+ databases. Create database objects such as tables, stored procedures , UDFs & triggers, views etc. great experience of query op Thêm

₹11111 INR trong 3 ngày
(0 Nhận xét)
0.0
chandu213

.....................................................................................................................................................................................................

₹7777 INR trong 3 ngày
(0 Nhận xét)
0.0
murali91921

A proposal has not yet been provided

₹5555 INR trong 3 ngày
(0 Nhận xét)
0.0
Thilagavathy92

Good in SQL

₹5555 INR trong 1 ngày
(0 Nhận xét)
0.0
₹7777 INR trong 3 ngày
(0 Nhận xét)
0.0
vinodsonawane123

We need to use the case statement for id and session id then arrange log date and time in desc order by select statement. if you want I will provide query.

₹8888 INR trong 2 ngày
(0 Nhận xét)
0.0
SwathiBrahmadev

A proposal has not yet been provided

₹12222 INR trong 3 ngày
(0 Nhận xét)
0.0
chandan231981

A proposal has not yet been provided

₹77777 INR trong 3 ngày
(0 Nhận xét)
0.0
jemaineCole

Hi, I have already solved your problem. Please accept my bid and I will provide the solution. Kind regards, Jemaine Skills: • Creating and altering database objects as per business requirements which in Thêm

₹7777 INR trong 3 ngày
(0 Nhận xét)
0.0
raajasekarm

Good experiencing in SQL, T-SQL and PL/SQL programming. I've designed and written many SQLs, which are both ad hoc and transactional in nature.

₹12777 INR trong 2 ngày
(0 Nhận xét)
0.0