User markp-fuso

10 votes

Accepted

Why does SET ROWCOUNT not reset after GO?

answered Aug 8, 2017 at 17:05

8 votes

Accepted

SQL update multiple rows in destination table with same id but different values from source table

answered Aug 10, 2017 at 17:16

6 votes

Accepted

Locate the smallest missing element based on a specific formula

answered Sep 6, 2017 at 0:14

5 votes

Best way to check if record exists or not in MySQL

answered Aug 18, 2017 at 14:19

5 votes

Accepted

Using SPID in DB Tables (instead of Table Variable)

answered Jul 18, 2019 at 2:38

4 votes

Query challenge: Creating even sized buckets, based on a measure not row count

answered Sep 16, 2018 at 13:19

4 votes

Accepted

Prevent T-SQL code that is not compatible to break the script

answered Aug 18, 2017 at 17:19

4 votes

Query detailing differences between rows for a large amount of data

answered Jun 10, 2017 at 15:39

4 votes

Are implicit transactions per batch or per session in SQL Server?

answered Jul 2, 2017 at 17:20

4 votes

Accepted

MySQL group by multiple columns on multiple tables only one result per group

answered Oct 1, 2017 at 19:12

4 votes

Numbered stored procedures: introduction and deprecation?

answered May 2, 2018 at 12:05

3 votes

Calculations over UNION, merge query repetitive code

answered Dec 8, 2017 at 14:48

3 votes

Accepted

Calculations over UNION, merge query repetitive code

answered Dec 8, 2017 at 15:29

3 votes

Accepted

Display child records in single column by comma separted with parent records

answered Dec 11, 2017 at 3:21

3 votes

Accepted

SQL Server Order SELECT List with condition

answered Oct 6, 2017 at 14:56

3 votes

Accepted

Auto-incremented ID with sequence and trigger: How to handle manual overrides (causing non-unique error)

answered Jun 29, 2017 at 1:40

3 votes

Accepted

Database size limit in Sybase Express edition

answered Nov 14, 2017 at 22:23

3 votes

How can I rectify an "arithmetic overflow occurred error" when trying to merge these two queries?

answered May 25, 2017 at 17:11

3 votes

Accepted

Join Fact table to SCD Type 2 ... how to write query? (SQL Server)

answered Aug 29, 2017 at 23:34

3 votes

Accepted

MySQL calculate overlapping period excluding overlapping rules

answered Sep 1, 2017 at 4:09

2 votes

How to create an alphanumeric sequence like AAAA0000 and so on

answered Sep 6, 2017 at 15:13

2 votes

Filling one value multiple times in mysql

answered Sep 10, 2017 at 17:21

2 votes

Accepted

how to confirm or refute that performance degradation is due because of too many indexes maintained

answered May 25, 2017 at 17:48

2 votes

Improving query to generate a million empty rows

answered Aug 15, 2017 at 19:31

2 votes

Accepted

Use Dynamic SQL To Create View From Cursor

answered Aug 16, 2017 at 14:43

2 votes

A column value depends on the values of two other columns, of which exactly one is nullable

answered Jul 3, 2017 at 14:46

2 votes

Accepted

Joining multiple tables with complicated rquirements

answered Nov 13, 2017 at 18:56

2 votes

Calculate period start and end date

answered Nov 7, 2017 at 13:54

2 votes

Accepted

What happens to replication if rows have been deleted on a target already?

answered Nov 7, 2017 at 19:44

2 votes

How do I add multiple new records based on old ones

answered Sep 28, 2017 at 0:35

Stack Exchange Network

98 Answers

Why does SET ROWCOUNT not reset after GO?

SQL update multiple rows in destination table with same id but different values from source table

Locate the smallest missing element based on a specific formula

Best way to check if record exists or not in MySQL

Using SPID in DB Tables (instead of Table Variable)

Query challenge: Creating even sized buckets, based on a measure not row count

Prevent T-SQL code that is not compatible to break the script

Query detailing differences between rows for a large amount of data

Are implicit transactions per batch or per session in SQL Server?

MySQL group by multiple columns on multiple tables only one result per group

Numbered stored procedures: introduction and deprecation?

Calculations over UNION, merge query repetitive code

Calculations over UNION, merge query repetitive code

Display child records in single column by comma separted with parent records

SQL Server Order SELECT List with condition

Auto-incremented ID with sequence and trigger: How to handle manual overrides (causing non-unique error)

Database size limit in Sybase Express edition

How can I rectify an "arithmetic overflow occurred error" when trying to merge these two queries?

Join Fact table to SCD Type 2 ... how to write query? (SQL Server)

MySQL calculate overlapping period excluding overlapping rules

How to create an alphanumeric sequence like AAAA0000 and so on

Filling one value multiple times in mysql

how to confirm or refute that performance degradation is due because of too many indexes maintained

Improving query to generate a million empty rows

Use Dynamic SQL To Create View From Cursor

A column value depends on the values of two other columns, of which exactly one is nullable

Joining multiple tables with complicated rquirements

Calculate period start and end date

What happens to replication if rows have been deleted on a target already?

How do I add multiple new records based on old ones