User Caleb Carl

2 votes

Convert varchar into datetime and use date diff on the where clause

answered Nov 9 at 19:06

1 vote

Specific query gives me trouble

answered Nov 17 at 16:42

1 vote

How to sum up the distinct Total Time of an Event ignoring duplicate overlaps in Times?

answered Nov 17 at 18:40

1 vote

Insert 2 output result sets from sp_spaceused into Temp Table (SQL Server non-2016)

answered Nov 21 at 17:38

1 vote

How to apply JOIN only if there are rows available

answered Nov 8 at 2:09

1 vote

Accepted

Rewriting a DELETE statement to reduce pagelatch_ex waits

answered Nov 3 at 7:12

1 vote

How can I get the accurate and optimized grouped data by passing expression in partition by statement?

answered Nov 3 at 21:57

1 vote

New column that subtacts 2 rows from a different column and pushing out the difference number

answered Nov 3 at 22:53

1 vote

How to retrieve min/max values and corresponding dates in a table

answered Nov 3 at 23:37

1 vote

Select data divided in groups evenly distributed by value

answered Oct 31 at 1:36

1 vote

Auto-increment [id] field in a table in an SQL-Server database

answered Nov 1 at 23:49

1 vote

Accepted

Why does inserting a value into a temp table's BINARY(8) column cause an error when casting the same value to BINARY(8) does not?

answered Nov 13 at 19:35

1 vote

Accepted

Replace multiple words in a single value using SQL

answered Nov 14 at 0:30

0 votes

How do I filter down the latest Date from multiple columns

answered Nov 16 at 0:12

0 votes

Accepted

Question on joins with multi tables

answered Nov 16 at 20:45

0 votes

Using OUTPUT INSERTED.id to UPDATE (i.e. not insert new record) existing rows

answered Nov 2 at 22:05

0 votes

How to join matching Date fields as intervals?

answered Nov 2 at 22:56

0 votes

Why does my query take a long time to run, and why does changing the order of the joins make it quicker?

answered Nov 4 at 5:39

0 votes

Update one table's row from the results of multiple rows of another table

answered Nov 6 at 19:39

0 votes

Partitioning an existing table yearly in SQL Server with huge data

answered Nov 6 at 22:38

0 votes

Get Point from Another Table based on Category and Value Range

answered Nov 7 at 0:24

0 votes

SQL Server: Trigger with UPDATE statement causes deadlocks

answered Nov 13 at 18:58

Stack Exchange Network

22 Answers

Convert varchar into datetime and use date diff on the where clause

Specific query gives me trouble

How to sum up the distinct Total Time of an Event ignoring duplicate overlaps in Times?

Insert 2 output result sets from sp_spaceused into Temp Table (SQL Server non-2016)

How to apply JOIN only if there are rows available

Rewriting a DELETE statement to reduce pagelatch_ex waits

How can I get the accurate and optimized grouped data by passing expression in partition by statement?

New column that subtacts 2 rows from a different column and pushing out the difference number

How to retrieve min/max values and corresponding dates in a table

Select data divided in groups evenly distributed by value

Auto-increment [id] field in a table in an SQL-Server database

Why does inserting a value into a temp table's BINARY(8) column cause an error when casting the same value to BINARY(8) does not?

Replace multiple words in a single value using SQL

How do I filter down the latest Date from multiple columns

Question on joins with multi tables

Using OUTPUT INSERTED.id to UPDATE (i.e. not insert new record) existing rows

How to join matching Date fields as intervals?

Why does my query take a long time to run, and why does changing the order of the joins make it quicker?

Update one table's row from the results of multiple rows of another table

Partitioning an existing table yearly in SQL Server with huge data

Get Point from Another Table based on Category and Value Range

SQL Server: Trigger with UPDATE statement causes deadlocks