Serg's user avatar
Serg's user avatar
Serg's user avatar
Serg
  • Member for 7 years, 11 months
  • Last seen more than a week ago
  • Nizhny Novgorod, Nizhny Novgorod Oblast, Russia
7 votes
Accepted

Maintaining integrity between 3 tables when reference could be through or direct

7 votes

Why does this query work?

6 votes
Accepted

Many to many between lots of tables?

6 votes

Convert a date range to an interval description

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

4 votes

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

4 votes
Accepted

Please explain why deadlock is detected in my example

3 votes
Accepted

Grant sysadmin permissions to 'NT AUTHORITY\SYSTEM'

2 votes
Accepted

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

2 votes

Database design for an exam

2 votes
Accepted

Abstracting away filtering behavior from Oracle SQL Function

2 votes
Accepted

Use Alias In Join Condition

2 votes

Separate letters from digits in alphanumeric string

2 votes

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

2 votes
Accepted

Retrieve data from two tables where table 2 has multiple entries for one value

2 votes

Avoid repeated traversing of hierarchical data when parsing a big tree frequently

2 votes
Accepted

Mysql columns mutual exclusion

2 votes

SQL server is there recursive reserve word?

2 votes
Accepted

Convert hierarchy in an ordered list of rows

1 vote

"Upsert" trigger writing mass duplicates from SSIS

1 vote
Accepted

How to perform multiple checks on same column of same table in Mysql?

1 vote

Sorting by month by chronological occurrence when the year doesn't matter?

1 vote

How do I find the cumulative distance between geometry points in SQL Server 2014?

1 vote

Append Records to a fixed number of columns using dynamic data

1 vote

How could I get the value as Y or N in one table if value is exists on another that meets certain condition?

1 vote

Dependency preserving decomposition

1 vote

Total duration "server" was in "In" state per day

1 vote
Accepted

Complex MySQL query through relational tables

1 vote

need to join Vertical row as per values in Horizontal rows

1 vote

How can I pivot a view into a join so I get multiple query rows as columns in a single row?