User Serg

7 votes

Accepted

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

answered May 19, 2016 at 19:29

7 votes

Why does this query work?

answered Jun 27, 2016 at 9:24

6 votes

Accepted

Many to many between lots of tables?

answered Apr 30, 2016 at 19:46

6 votes

Convert a date range to an interval description

answered May 10, 2016 at 9:50

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

answered Jul 7, 2016 at 16:02

4 votes

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

answered Jun 24, 2016 at 11:03

4 votes

Accepted

Please explain why deadlock is detected in my example

answered Jun 17, 2016 at 9:57

3 votes

Accepted

Grant sysadmin permissions to 'NT AUTHORITY\SYSTEM'

answered Jun 24, 2016 at 14:59

2 votes

Accepted

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

answered Jun 22, 2016 at 9:11

2 votes

Database design for an exam

answered Jun 29, 2016 at 18:35

2 votes

Accepted

Abstracting away filtering behavior from Oracle SQL Function

answered Jun 16, 2016 at 12:55

2 votes

Accepted

Use Alias In Join Condition

answered Jun 20, 2016 at 14:10

2 votes

Separate letters from digits in alphanumeric string

answered May 6, 2016 at 9:52

2 votes

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

answered Jun 2, 2016 at 7:49

2 votes

Accepted

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

answered May 23, 2016 at 16:27

2 votes

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

answered May 25, 2016 at 19:34

2 votes

Accepted

Mysql columns mutual exclusion

answered Jun 6, 2016 at 8:19

2 votes

SQL server is there recursive reserve word?

answered Jun 3, 2016 at 13:20

2 votes

Accepted

Convert hierarchy in an ordered list of rows

answered Jun 12, 2016 at 13:15

1 vote

"Upsert" trigger writing mass duplicates from SSIS

answered Jun 8, 2016 at 8:12

1 vote

Accepted

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

answered May 28, 2016 at 16:54

1 vote

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

answered May 30, 2016 at 13:25

1 vote

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

answered May 22, 2016 at 15:16

1 vote

Append Records to a fixed number of columns using dynamic data

answered May 6, 2016 at 17:22

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?

answered May 8, 2016 at 12:13

1 vote

Dependency preserving decomposition

answered May 8, 2016 at 21:50

1 vote

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

answered May 9, 2016 at 18:11

1 vote

Accepted

Complex MySQL query through relational tables

answered May 3, 2016 at 18:24

1 vote

need to join Vertical row as per values in Horizontal rows

answered May 4, 2016 at 12:26

1 vote

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

answered May 10, 2016 at 12:35

Stack Exchange Network

54 Answers

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

Why does this query work?

Many to many between lots of tables?

Convert a date range to an interval description

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

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

Please explain why deadlock is detected in my example

Grant sysadmin permissions to 'NT AUTHORITY\SYSTEM'

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

Database design for an exam

Abstracting away filtering behavior from Oracle SQL Function

Use Alias In Join Condition

Separate letters from digits in alphanumeric string

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

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

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

Mysql columns mutual exclusion

SQL server is there recursive reserve word?

Convert hierarchy in an ordered list of rows

"Upsert" trigger writing mass duplicates from SSIS

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

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

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

Append Records to a fixed number of columns using dynamic data

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

Dependency preserving decomposition

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

Complex MySQL query through relational tables

need to join Vertical row as per values in Horizontal rows

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