Skip to main content
RichardTheKiwi's user avatar
RichardTheKiwi's user avatar
RichardTheKiwi's user avatar
RichardTheKiwi
  • Member for 13 years, 6 months
  • Last seen more than a month ago
Profile Activity
Stats
107,226
reputation
23.8m
reached
2,009
answers
26
questions
Communities
View all
About

A programmer who works with Microsoft SQL Server.
SQL Server Minesweeper, anyone?

Interesting posts:
SQL Server: How to rotate a table 45 degrees?
SQL Server: A Puzzle solved in SQL
SQL Server: Recursive CTE, why Row_Number doesn't work
SQL Server: Clustered index key update = delete + update!

Other interesting posts:
SQL: SUMPRODUCT operator in MSSQL, MySQL, Oracle?
SQL Server: SQRT() vs POW() bake off
SQL Server: String or binary data would be truncated
SQL: Check if string is numeric (MSSQL, MySQL, Oracle)
SQL Server: Better ISDATE function for format 103 (dmy)
SQL Server: Symmetric matrix manipulation
Oracle: Using MODEL to perform iterative calculations

Essential Online Tools:
SQL Fiddle
Format tab values as Text-Table

Badges
View all badges
26
gold badges
201
silver badges
265
bronze badges
Top tags
View all tags
6,289
Score
1,382
Posts
68
Posts %
4,114
Score
801
Posts
39
Posts %
2,218
Score
419
Posts
21
Posts %
1,962
Score
348
Posts
17
Posts %
1,818
Score
313
Posts
15
Posts %
788
Score
171
Posts
8
Posts %
Top posts
View all questions, answers, and articles
319
Turning a Comma Separated string into individual rows
Mar 30, 2011
304
SQL query to insert datetime in SQL Server
Oct 18, 2012
300
Detect if value is number in MySQL
Feb 21, 2011
275
Positive Number to Negative Number in JavaScript?
Apr 6, 2011
246
SQL Server SELECT INTO @variable?
Jan 28, 2011
212
Difference between database and schema
Mar 16, 2011
162
mysql SQL: specific item to be first and then to sort the rest of the items
Mar 24, 2011
151
mysql sort string number
Mar 24, 2011
147
Usage of MySQL's "IF EXISTS"
Apr 3, 2011
120
PostgreSQL: SQL script to get a list of all tables that have a particular column as foreign key
Mar 18, 2011
Top network posts
View all network posts
39
Stack Overflow Annual User Survey 2012
38
For absolute performance, is SUM faster or COUNT?
30
Revealing voting patterns - new trend?
26
Tips for getting really good answers on SO
22
Steward Badge gaming visible in the Review Close Queue