Skip to main content
SqlZim's user avatar
SqlZim's user avatar
SqlZim's user avatar
SqlZim
  • Member for 9 years, 11 months
  • Last seen more than a month ago
13 votes

Which is faster, SUM(CASE) or CTE PIVOT?

9 votes
Accepted

Getting the Date of Some Day of Last Week

9 votes
Accepted

Conversion of a varchar data type to a datetime data type resulted in an out-of-range value

8 votes

Get The Most Recent Record In A Table By Date And User

8 votes

How do I Loop through a table and update a field in SQL

8 votes

How can I improve speed of select?

7 votes

Is a MERGE with OUTPUT better practice than a conditional INSERT and SELECT?

6 votes

How to get max of combined columns?

5 votes
Accepted

Error converting NVARCHAR to BIGINT when in SUBQUERY with WHERE clause after invalid records filtered

5 votes
Accepted

Conditionally OR vs CASE vs IF

5 votes

Invalid object name after aliasing a table?

5 votes
Accepted

How to output to same line with relation information same table?

4 votes
Accepted

installing SSDT

4 votes

Lines starting with colons in SQL Server

4 votes
Accepted

Drop All Views With A Prefix

4 votes
Accepted

SQL Server: Stored Procedure to add parent & child records

4 votes
Accepted

Use SUM In Update Statement

4 votes

Optimize Subquery with Windowing Function

3 votes
Accepted

How to constrain many-to-many to mark a single record as a "default"?

3 votes

How to get prior data in a missing dates in sql table

3 votes

Select everything after the last space using PostgreSQL

3 votes
Accepted

Seems SQL Server couldn't optimize optional parameters

3 votes

Is it possible to choose RAISERROR or THROW depending on SQL Server version?

3 votes
Accepted

Filling in date holes in grouped-by-date SQL data

3 votes
Accepted

More trouble with STUFF

3 votes

How to port LTRIM from Oracle to SQL Server?

2 votes
Accepted

How to retreive deleted records in a trigger on a table with composite primary key

2 votes
Accepted

Turning multiple fields in column to row

2 votes

How to design a table with relationships to a group of users or individual users?

2 votes

Improve CPU consumption of query