Mike S's user avatar
Mike S's user avatar
Mike S's user avatar
Mike S
  • Member for 4 years, 2 months
  • Last seen more than a month ago
  • Rochester, NY, USA
4 votes
3 answers
527 views

Why do subsequent unmet conditions in my CASE statement affect my return data type?

2 votes
1 answer
137 views

Why does SQL Server Trace Flag 715 behave differently from the TABLOCK query hint?

1 vote
0 answers
186 views

Why do some applications use implicit transactions in SQL Server?

1 vote
1 answer
71 views

What would be the best way to conditionally insert or update a table that has this unique design?

1 vote
1 answer
3k views

How can I transpose multiple unrelated columns into rows in SQL Server?

1 vote
1 answer
810 views

How can I exclude rows from two tables whose values are encompassed by each other?

1 vote
1 answer
2k views

In SQL Server, what's the best way to split multiple delimited strings into rows without a function?

1 vote
3 answers
753 views

How can parse column names using ordinal position (not name) from XML data in SQL Server?

0 votes
1 answer
533 views

How can I apply the same logic to multiple tables that have the same number of columns and data types?

0 votes
1 answer
340 views

How can you split multiple delimited strings of varying sizes into rows?