Kirk Saunders's user avatar
Kirk Saunders's user avatar
Kirk Saunders's user avatar
Kirk Saunders
  • Member for 7 years, 10 months
  • Last seen this week
  • Louisville, KY, USA
3 votes
Accepted

How to calculate the sums of two columns, when that two columns brought by join queries?

3 votes
Accepted

How to get count 0 using group by if record not exist?

3 votes

Example of query execution plan where the cardinality estimation makes a difference

3 votes

Sql restrict insert records for the same client based on 2 columns

3 votes

Help - Database design

2 votes

How to merge records in SQL

2 votes

Best way to model the relationship of unique pairs

2 votes
Accepted

Hierarchical references abstraction with strict model

2 votes
Accepted

How to take make OFFSET & LIMIT with COUNT (OVER?) when having a subquery?

2 votes

WHILE Loop for data migration/merge with multiple fields for matching

2 votes
Accepted

Need help in picking solution and understanding when to add columns vs EAV

2 votes

Create a function/tsql to get strings from the 1st table/data and compare and convert if from the value of second table

2 votes
Accepted

Convert rows into columns and group some colums

1 vote
Accepted

SQL Server Show table when hovering over a keyword

1 vote
Accepted

Constrain unique value between multiple tables

1 vote

Do you think is necessary to create an auxiliary translate table for table that has only two elements (id and name)

1 vote

Why does SQL Server not use the Index it recommends?

1 vote

Very similar queries, vastly different performance

1 vote
Accepted

SSIS job -- how to create stored procedure that repeats SSIS jobs?

1 vote
Accepted

How to join different tables with same propriety tables?

1 vote
Accepted

How can I fill in a foreign key value after creating the first entry of the table the foreign key is referencing?

1 vote

GROUP By Statement to detect duplicates

1 vote
Accepted

How to query in such a way that values becomes columns?

0 votes

How to structure predicate to trigger a clustered index seek after a certain record with a composite key?

0 votes

How to delete foreign key with lots of references

0 votes

How to avoid conditional join in order to write a tsql view

0 votes

Calculate Inventory Costing Based on First in, First Out (FIFO)

0 votes

Split Multiple Columns Into Multiple Columns by Delimiter