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...

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...

How to query for rows that have the different values for one column?...

T-SQL calculate percentage of count group by date...

CASE WHEN to calculate tax on a tier based tax system...

SQL Server concatenate ignore null value...

SQL Server Convert Timestamp DataType to Decimal...

Can I set ignore_dup_key on for a primary key?...

Separate 1 tables into two based on conditions and then JOIN the two tables keeping NULL instead of ...

How can I use like in a list for SQL?...

Arithmetic overflow error converting numeric to data type numeric...

How to filter based on first occurrence in my table using SQL...

SQL Query to extract the numbers before a specific word...

How do I determine if a column is an identity column in MSSQL 2000?...