SQL query or function to get only numerical values before and after certain word...

CTE to match days after discharge and days supply from prescription...

RDSProxy is making SELECT DATABASEPROPERTYEX.. that have high WAITs on our SQL Server...

Creating a balance statement...

Ignore conflicts when logging a value...

Alternatives to OR NULL in SQL join...

Generating self-closing XML tags for lists in SQL Server...

Conditionally filter results of query based on a single flag...

Unable to install SQL Server(setup.exe) Exit code decimal: -2061893606...

Advanced SQL Server LIKE pattern...

SQL Server database copy utility fails - "Login failed for user"...

Search a JSON with multiple array elements for specific attribute and get another attribute value...

How to decrement a number in a character-separated string...

Is there a way to ignore the "STATISTICS_NORECOMPUTE" clause when doing a schema compare i...

How to find value for SSIS package project parameter manually set in the SQL Server Agent job?...

Add a value on their SESSION_CONTEXT for all sys.dm_exec_sessions...

Only on one server: "SQL Server Network Interfaces: The target principal name is incorrect.&quo...

Select top 1 row from multiple rows in inner join...

Two elements with the same name for xml path()...

How to concatenate T-SQL script with a wildcard and to be more dynamic?...

Get latest row based by date grouped by concat...

Recursive CTE for leave accrual projections...

Entity Framework truncating decimal places when updating table...

Query to parse JSON using openrowset converting special characters...

Why does normal execution resume after Raiserror in Catch block...

Get values of columns A of table 1 and values of column B of table 2 with same ID...

How to use EXECUTE AS in a procedure without giving a USER explicit IMPERSONATE permissions?...

Simple insert times out in application, but fast in SSMS...

Trying to preserve data types when duplicating a table, dynamically...

Edit asterisk symbol into list of column names in SSMS by wildcard expansion...