Does SQL Server Offer Anything Like MySQL's ON DUPLICATE KEY UPDATE...

How can I add a whole column of data as a row?...

SQL Server trigger with error message...

Create a Range From n to 1 in SQL...

Find the number of return calls that were done by customer care within 30 minutes of the missed call...

Improving Performance of Recursive CTE for calculating totals...

UPDATE Statement Not Updating in Execute T-SQL Task...

linked server OLE DB provider "SQLNCLI11" for linked server...

Display running totals in SSRS in a shape of triangle for Los Development (Loss Triangle) report...

In a T-SQL table of prizes awarded, how can I find all users that received two specific prizes?...

How to create a derived attribute from a foreign table using Alter Table?...

SUM over with distinct...

create TVC ("Table Value Constructor") script from temp table (same like SSMSBoost provide...

Find corresponding records over multiple columns for each key value given a sort order...

How to get the last plus and last minus datetime from a stock table...

Join the main Table with history table to get the current rate of the main table and the last and pr...

Calculating orders placed on the end of the month...

How to DROP multiple columns with a single ALTER TABLE statement in SQL Server?...

Returning XML Data in Tabular format when it isn't stored as XML...

Why can't I combine two SQL Server functions?...

Aggregate results in one row...

Cannot truncate table because it is being referenced by a FOREIGN KEY constraint?...

Return custom query with columns and a list that contains other columns...

'invalid column name' while using the HAVING...

Calculate the total weight of segments...

Is it possible to use a value from a result to union another result into the previous resultset?...

Best way to migrate one to many to many to many juction table?...

Get distinct path list ordered by date in SQL...

SQL SELECT query return total COUNT when filtering with WHERE clause...

Distribute sequential SQL results evenly based on count...