Skip to main content
Mike S's user avatar
Mike S's user avatar
Mike S's user avatar
Mike S
  • Member for 4 years, 7 months
  • Last seen more than a month ago
  • Rochester, NY, USA
4 votes
3 answers
542 views

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

2 votes
1 answer
154 views

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

1 vote
0 answers
201 views

Why do some applications use implicit transactions in SQL Server?

1 vote
1 answer
76 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
936 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
831 views

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

0 votes
1 answer
683 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
389 views

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