Generate unique invoice number for each permit where permits have multiple line items

Output sqlaudit File Results to Text File - TSQL

How to make a PIVOT query with two columns?

Checking if any date between date range was within a specific year

Force rename table column name (case spelling)

SQL Server PIVOT with Multiple Aggregate Columns and Totals Columns

T-SQL Trigger Insert record after update

T-SQL Syntax error - Can´t find where I´m doing wrong

Joining based on dates

How to get first character beside underscore for a given string

Insert into select in SQL server

Returning table from table-valued function and set that value in temp table

Date Format yyyy-mmm-dd hh:mm:ss in SQL server

Cannot pass column name as parameter to sp_executesql

Self Join on large tables slowness issue

Updating the table from stored procedure using openrowset

If Value is present in two consecutive months , display only one month in sql

SQL Server Active Record counts by month

MSSQL Exporting tables with some columns blank

Store result of exec sql in a temp table

Averaging event start time from DateTime column


SQL SELECT DISTINCT Row Joining Data into one Cell

Manage records ordering

Why does conversion from DATETIME to DATETIME2 appear to change value?

How to create an SSIS Package that will run a list of T-SQL queries located in a specific folder?

Eliminate duplicates between columns

T-SQL to sum total value instead of rejoining table multiple times

Combining data in several rows into one row

Cross database view ORDER BY performance

This SQL INSERT INTO does not work with a UNION

XML - Extract after a String and before a certain character

Difference between two sql statements

Check if field exists in DB using SQL trigger

Filter duplicates on cross fields

embedded methods .Net js

SQL to find only those records which are before certain date

SQL Server: return last day of the last year

Converting Stored Procedure to Inline Function

Generalised Sql with Latest max dates in where clause

Finding consecutive records

SQL Server query for date format

remove duplicate relations in self join

TSQL Concatenating data from 2 tables

Modifying Roll Up SQL

SQL : Compare rows in SQL Server in same table (or different tables with same structure)

Dynamic bulk insert silently failing

Why would replacing a parameter with a local variable speed up a query

LEFT JOIN: The multi-part identifier "_" could not be bound

Divide by zero error unique zeros

Join 2 Table Variables in SQL

WHERE conditions being listed in a column if they are met

Too Much Time to load Select Query

SSRS - producing csv file with mixed format header & footer

How to copy a table from database A on a linked server to database B?

Using PIVOT to aggregate monthly counts of products purchased and revenue generated

Transfer Data from tables that end with _Log into a another DB and only leaving 1 week of data in the main DB?

Left join on a table variable fails

How to optimize the Max Date query without subquery in sql server

Adding a value to a 'datetime'

Conditionally insert into table if column exists

Select Distinct on one column and eliminate nulls in Select Distinct?

Joining date with datetime and values per day

Fetching column names from another table in SQL

Showing Sub totals in SQL Server query results

What is the T-SQL syntax to get the length of each column of a specific Table?

How is a TSQL Join implemented internally when there is a many-to-single relationship?

Return single row from matching on multiple condition on column

tsql join tables with 2 ids

Get a row value based on criterias - T-SQL

In SQL Server, order by date not showing all dates in desc order

How ISNULL can affect query performance

Add column into Table through variable using SQL Server

Calling SKIP() in code or using TOP in function

Crafting a SP to determine which columns make a table unique

SQL View does not accept Subclause

Column name of function in SQL Server

T-SQL: Move rows from one table to another, log both source and destination primary keys

Grouping sets is not aggregating results

ETL triple reference timeKey, subquery returned more than 1 value

Updating Sum Case Statement Grouped By Id

How to convert my TSQL query to LINQ

Cast FLOAT to NVARCHAR - different number of decimal places

Skip insert (and continue) on duplicate key [T-SQL]

T-SQL: AVG function

How to run a scalar function over a length of time for multiple objects

Not getting Ouytput of Stored Procedure

Need some tip on a tricky SQL query

Working Out a Percentage of a Count Total

TSQL datetime field doesn't allow updating of the time part of the field from 00:00:00.000 to any other value

Converting Varchar to negative decimal in brackets

Error while viewing saved procedure - sql

Passing variable in Group By in SQL Server

Filtering result of Cross Join to select distinct column combination

How to check the correctness of adding records to the transaction log?

SQL Group Data with a Left Join to a Sub Select

Entity Framework and no execution plan caching

T-SQL Parse XML Column Problems

Difference between T-SQL and MySQL's SELECT syntax

Should I split my SQL Server table?