user avatar
user avatar
user avatar
markp-fuso
  • Member for 5 years, 2 months
  • Last seen this week
  • North America
10 votes
Accepted

Why does SET ROWCOUNT not reset after GO?

8 votes
Accepted

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

6 votes
Accepted

Locate the smallest missing element based on a specific formula

5 votes

Best way to check if record exists or not in MySQL

5 votes
Accepted

Using SPID in DB Tables (instead of Table Variable)

4 votes

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

4 votes
Accepted

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

4 votes

Query detailing differences between rows for a large amount of data

4 votes

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

4 votes
Accepted

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

4 votes

Numbered stored procedures: introduction and deprecation?

3 votes

Calculations over UNION, merge query repetitive code

3 votes
Accepted

Calculations over UNION, merge query repetitive code

3 votes
Accepted

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

3 votes
Accepted

SQL Server Order SELECT List with condition

3 votes
Accepted

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

3 votes

Database size limit in Sybase Express edition

3 votes

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

2 votes
Accepted

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

2 votes

Improving query to generate a million empty rows

2 votes
Accepted

Use Dynamic SQL To Create View From Cursor

2 votes

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

2 votes
Accepted

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

2 votes

MySQL calculate overlapping period excluding overlapping rules

2 votes

How to create an alphanumeric sequence like AAAA0000 and so on

2 votes

Filling one value multiple times in mysql

2 votes
Accepted

Joining multiple tables with complicated rquirements

2 votes

Calculate period start and end date

2 votes
Accepted

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

2 votes

How do I add multiple new records based on old ones