Skip to main content
Share Your Experience: Take the 2024 Developer Survey
Serg's user avatar
Serg's user avatar
Serg's user avatar
Serg
  • Member for 8 years, 1 month
  • Last seen more than a month ago
  • Nizhny Novgorod, Nizhny Novgorod Oblast, Russia
3 votes
Accepted

Grant sysadmin permissions to 'NT AUTHORITY\SYSTEM'

6 votes

Convert a date range to an interval description

1 vote

Dimension Modelling Senario Data Warehouse Design

1 vote

Build JSON object from one-to-many relationship data in a single query?

4 votes

AVG with OVER - invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause

2 votes

Database design for an exam

1 vote

Subtract TotalExpense from BudgetAmount In Budget Table for a specific date

7 votes

Why does this query work?

0 votes

Combine intersecting ranges to produce new ranges based on the points of intersection

4 votes

Is there a way to make this select retrieve the same results with a single seek?

1 vote

Applying single quotes across multiple lines using ssms code snippet

2 votes
Accepted

convert historic local time to UTC taking into account of daylight saving

0 votes
Accepted

How do I place an UpdateLock on a row with an index

1 vote
Accepted

Enforce 1 or many relationship

1 vote
Accepted

How to SELECT cells from mysql for a HTML table?

2 votes
Accepted

Use Alias In Join Condition

1 vote
Accepted

1054 - Unknown column in subquery

4 votes
Accepted

Please explain why deadlock is detected in my example

2 votes
Accepted

Abstracting away filtering behavior from Oracle SQL Function

0 votes

SQL export select statement to Excel using script

2 votes
Accepted

Convert hierarchy in an ordered list of rows

0 votes
Accepted

Multi-level confirmation process

0 votes

Should every table in my database include store id?

1 vote

"Upsert" trigger writing mass duplicates from SSIS

2 votes
Accepted

Mysql columns mutual exclusion

0 votes

A test fixture database to experiment on performance tuning?

2 votes

SQL server is there recursive reserve word?

1 vote

SQL, category tree with multiple parents

0 votes
Accepted

Querying dates with different timezones at db and application level

2 votes

Single value from a list of comma separated values when used in inner join in SQL Server