User PenutReaper

9 votes

Accepted

Sales, Taxes and Totals

answered Jul 23, 2015 at 15:39

6 votes

Accepted

SQL Group and Filter - Refining down a search including Dates

answered Sep 9, 2014 at 13:24

6 votes

Accepted

For a query over multiple databases, is it faster to do GROUP BY first or UNION first?

answered Oct 30, 2014 at 11:06

5 votes

Accepted

Bling Accounting - Badge summaries

answered Dec 16, 2014 at 14:27

5 votes

Finding person with most medals in Olympics database

answered Jul 31, 2014 at 15:12

5 votes

Luhn algorithm MS-SQL

answered Feb 20, 2015 at 16:42

4 votes

Accepted

Dividing by the total count based on occupation

answered Oct 24, 2014 at 11:46

4 votes

Accepted

Generate random records for table in SQL

answered Feb 3, 2015 at 12:51

4 votes

Accepted

Retrieve Father and Child structure in a Database Table

answered Aug 20, 2014 at 14:13

4 votes

Average of averages

answered Sep 12, 2014 at 14:52

4 votes

Accepted

Normalizing Invoices

answered Sep 30, 2014 at 11:00

4 votes

Accepted

Finding the runtime of a task by name

answered Sep 30, 2014 at 18:03

3 votes

Basic T-SQL to compare two same length strings

answered Sep 4, 2014 at 12:35

3 votes

Accepted

Query for finding possible "Not An Answer" posts

answered Sep 8, 2014 at 13:34

3 votes

Accepted

Fascinating, ma'am

answered Dec 17, 2014 at 9:32

3 votes

Chat server in Python

answered Sep 10, 2014 at 8:45

3 votes

Accepted

Unduplicated counts over various dimensions

answered Aug 18, 2014 at 11:02

3 votes

Accepted

SQL server efficiency, comparing date time of latest record and the one under it

answered Apr 7, 2015 at 14:16

3 votes

Dynamically re-index all indexes in all databases on server

answered Apr 9, 2017 at 21:25

2 votes

Accepted

Select Queries From Parent-Child Tables Model

answered Feb 13, 2015 at 13:14

2 votes

Finding max rating for a movie

answered Feb 3, 2015 at 11:28

2 votes

Assign Specific Value If BitField Is True

answered Oct 17, 2014 at 9:47

2 votes

Accepted

Most efficient way to get columns where one is minimum

answered Dec 9, 2014 at 12:02

2 votes

Average time to first answer

answered Aug 4, 2014 at 13:55

2 votes

Efficient way to extract the first row in a Group By group

answered Aug 4, 2014 at 14:23

1 vote

Extract last record inserted for each key identifier

answered Oct 6, 2014 at 12:59

1 vote

Replace CASE WHEN statement with something more sensible

answered Jan 20, 2015 at 13:28

1 vote

Accepted

Get Next and Previous "Load Day"

answered Aug 13, 2015 at 16:44

1 vote

Duplicate Payments using SQL

answered Nov 12, 2017 at 21:04

1 vote

Getting data from two tables

answered Nov 12, 2017 at 21:20

Stack Exchange Network

31 Answers

Sales, Taxes and Totals

SQL Group and Filter - Refining down a search including Dates

For a query over multiple databases, is it faster to do GROUP BY first or UNION first?

Bling Accounting - Badge summaries

Finding person with most medals in Olympics database

Luhn algorithm MS-SQL

Dividing by the total count based on occupation

Generate random records for table in SQL

Retrieve Father and Child structure in a Database Table

Average of averages

Normalizing Invoices

Finding the runtime of a task by name

Basic T-SQL to compare two same length strings

Query for finding possible "Not An Answer" posts

Fascinating, ma'am

Chat server in Python

Unduplicated counts over various dimensions

SQL server efficiency, comparing date time of latest record and the one under it

Dynamically re-index all indexes in all databases on server

Select Queries From Parent-Child Tables Model

Finding max rating for a movie

Assign Specific Value If BitField Is True

Most efficient way to get columns where one is minimum

Average time to first answer

Efficient way to extract the first row in a Group By group

Extract last record inserted for each key identifier

Replace CASE WHEN statement with something more sensible

Get Next and Previous "Load Day"

Duplicate Payments using SQL

Getting data from two tables