Search code examples
Recursive CTE and how to overcome circular reference error...

sql-servert-sql

Read More
TRIM is not a recognized built-in function name...

sqlsql-servert-sql

Read More
How to calculate a rolling sum for a group of data...

sqlsql-servert-sql

Read More
Using SELECT to obtain only fields with alphanumeric data (and certain punctuation) in SQL Server...

sql-servert-sql

Read More
Unable to Create Multiple User Defined Functions in SQL Server Using System.Data.SqlClient...

sqlsql-servert-sql

Read More
Get the database name in which Stored Procedure exists...

sql-serverdatabasesql-server-2008t-sqlstored-procedures

Read More
Convert Month Number to Month Name Function in SQL...

sqlsql-servert-sqlsql-server-2005

Read More
Exception when trying to make a dynamic database call...

c#t-sqlreflectionentity-framework-core

Read More
Order of XML nodes from document preserved in insert?...

sql-serverxmlt-sql

Read More
Create users dynamically from a table variable...

sqlsql-servert-sqlsql-server-2022

Read More
Pass variables to the SqlAzureDacpacDeployment@1 task of a SQL Server instance while running an Azur...

sql-servert-sqlazure-pipelinessqlcmdpublish-profiles

Read More
How to select the next lowest value and next highest value from a specific record value that's b...

sqlsql-servert-sql

Read More
Create an auto incrementing alpha numeric primary key...

sqlsql-servert-sql

Read More
SQL Server 2005 Get First and Last date for any Month in any Year...

sqlsql-serversql-server-2005t-sqldatetime

Read More
HAVING Count clauses with conditions?...

sqlsql-servert-sqlselect

Read More
Get MAX value of a BIT column...

sqlsql-servert-sqlsql-server-2008stored-procedures

Read More
How do I group my data based on time differences i.e. so I can seperate one group of 'events&#39...

t-sql

Read More
SQL server query processor ran out of internal resources...

sql-servert-sql

Read More
Azure Data Studio use SQL parameters...

sql-serverazuret-sqlazure-data-studio

Read More
How to convert to Date format like 'January 2024' in T-SQL?...

datet-sql

Read More
Recursive CTE and performance issue when anchor member is a large table...

sql-servert-sqlrecursive-query

Read More
How to custom format a number in T-SQL...

sql-servert-sqlsql-server-2022

Read More
Update rows for generic vs specific inputs...

sqlsql-servert-sql

Read More
Select top rows until value in specific column has appeared twice...

sqlsql-servert-sqlwindow-functions

Read More
Trunc(sysdate) in SQL Server...

sqlsql-serversql-server-2005oracle-databaset-sql

Read More
Generating Bootstrapped Samples in T-SQL...

sql-servert-sqlrandom

Read More
Treating empty elements as nulls in SQL Server's OPENXML function...

sql-serverxmlt-sqlnullopenxml

Read More
Empty statement in T-SQL...

sql-servert-sql

Read More
Return duplicate rows from a table...

sqlsql-servert-sql

Read More
Looking for a way to avoid a cursor...

sql-servert-sqldatabase-cursor

Read More
BackNext