Serg

Serg has asked 4 questions and find answers to 42 problems.

Stats

About

Serg questions

VS2019 Winforms SDK-style project, can't add a new form
Android listSelector still partly visible when the item is scrolled out
.Net DownloadFileTaskAsync robust WPF code

Serg answers

How to compute the differential sum per group of values based on order
How to UnPivot for multiple columns SQLServer
SQL to skip max row on condition
SQL SELECT only rows having MAX value of a column from two different tables
Multiple charactor match with LIKE clause
How to check if a set rows is covering the whole time range
Count where value is 1
SQL sum data between 2 dates in one column
How to avoid function repetition in SELECT, GROUP BY, and ORDER BY in SQL
How to dynamically pass in a date_or_time_part for DateDiff?