Query a Normalised Table Twice Without Using an Alias2

sql-server-2019

John K NJohn K N

6Not using an alias is a strange requirement, but *technically* yes.

Paul White

Using where in a json array in sql server

sql-server

kuskus

10One solution is below

PeterVandivier

Deadlock between online index rebuild and auto update stats

sql-server-2017

Anonymous 2148Anonymous 2148

Executions count reported by sp_QuickieStore 7

sql-server-2016

Anonymous 2148Anonymous 2148

9Hi there!

meme

sql server query error4

sql-server

Anonymous 2135Anonymous 2135

5This condition that compares `shour` with `datetime` is the problem:

ypercubeᵀᴹ

External verification of `SIGNBYCERT()` signatures from SQL Server 20163

sql-server-2016

NReilinghNReilingh

How do I write "proper" cursors?2

sql-server

Hannah VernonHannah Vernon

9`CURSOR_STATUS` provides a nice way of ensuring the cursor is ready and contains rows.

Hannah Vernon

Breaking infinite loop in recursive CTE25

sql-server

artaxerxeartaxerxe

8Jack's solution is good for scenarios where loops can only be encountered at the beginning of traversing the hierarchies.

Andriy M

4With a slightly simplified case:

Jack Douglas

Replacing A Scalar UDF That Processes Variable Numbers Of Rows46

sql-server-2016

memememe

11This is a fairly literal, but general, interpretation of the underlying recursive algorithm implemented as an inline table-valued function:

Paul White

Discarded alternatives

sql-server

i-onei-one