Search code examples
Display the average number of days between a customer's last and second to the last transaction...


sqlsql-server

Read More
Fastest way to determine if record exists...


sqlsql-serverperformanceselectcount

Read More
Unrecognized column name that I define...


sqlsql-server

Read More
How do I get the MAX of two values in SQL Server?...


sql-server

Read More
How can I split a single, very long string into separate columns and rows delimited by commas and se...


sql-serverrow

Read More
Why can't I use table names of aliased tables in WHERE clause?...


sql-servert-sqltable-alias

Read More
Function vs. Stored Procedure in SQL Server...


sqlsql-servert-sqlstored-proceduressql-function

Read More
What happens when I split partitioned table by using ALTER PARTITION FUNCTION?...


sql-server

Read More
How to correctly join two tables that each have Start Date and Stop Date columns?...


sqlsql-serverdatet-sqljoin

Read More
SQL copying data with new foreign keys...


sqlsql-serverstored-procedures

Read More
SQL Server truncates decimal points of a newly created field in a view...


sql-servert-sqlprecision

Read More
SQL Grouping and Nested Concatenation...


sqlsql-server

Read More
Extract and process substring between varying numbers of delimiters in a variable length string...


sqlsql-serversplitsql-server-2005

Read More
How to pull width & height out of string?...


sqlsql-server

Read More
How to delete, re-create, move, import, and export LocalDB databases?...


c#sql-serverentity-frameworklocaldb

Read More
The locale identifier (LCID) 8192 is not supported by SQL Server...


sql-servertransactional-replication

Read More
SQL Server Initial database connection timeout in 30 seconds...


c#sql-servertimeout

Read More
Why use a READ UNCOMMITTED isolation level?...


sql-servert-sqlisolation-level

Read More
Recursive CTE and how to overcome circular reference error...


sql-servert-sql

Read More
Select min or max based on where duplicate value exists...


sqlsql-server

Read More
Converting accented characters in varchar() to XML causing "illegal XML character"...


sql-serverxmlunicodecharacter-encodingtype-conversion

Read More
Incorrect syntax near '1'. Expecting ID, QUOTED_ID, or '.' Error with SQL Pivot...


sqlsql-serversql-server-2008pivotpivot-table

Read More
Update SQL table using selection from another table...


sqlsql-serverinsert-update

Read More
Clarification on joins...


sqlsql-serverleft-join

Read More
Foreign key constraint may cause cycles or multiple cascade paths?...


sqlsql-serverconstraints

Read More
pyodbc cursor.fetchall() is returning "strange" values...


pythonsql-serverpyodbc

Read More
T-SQL Get File Extension Name from a Column...


sqlsql-server

Read More
How to do a cross-database-query join in SQLAlchemy?...


pythonsql-serversqlalchemy

Read More
Return the contents of an EXEC from a stored procedure...


sql-serverstored-proceduresexecreturn-value

Read More
How to transform "Types" a List<string> foo class property into a SQL Server table [...


c#sql-serverlistentity-framework-coresystem.text.json

Read More
BackNext