StackRating

An Elo-based rating system for Stack Overflow

Home | About | Stats and Analysis | Get a Badge

Rating Stats for

Nolan Shang

Rating
1437.77 (4,534,745th)

Reputation
2,109 (79,824th)

Page: 1 2 3 ... 6

Title	Δ
Hide a row based on a condition in WHERE	0.00
How can I filter my SELECT with ID's not in all columns	-1.24
How to test a SQL Procedure with type objects	0.00
Eliminate Duplicates in Concatenated String	-1.26
Select multiple rows having distinct columns with a condiction	+0.26
mssql changing value in the column under condition	0.00
Recursive self join over file data	+0.45
Is it possible to do multiple pivots without explicitly naming each...	-0.13
How to join 2 colums and remove some observations but keep others?	-1.04
Accumulating previous rows with grouping	-0.14
Fetching column names from another table in SQL	+0.13
SQL Query - Sum Rows	-0.50
Combine SQL select data-set multiple rows into a single row based o...	-0.16
Find records with the same id and put in the same row	-0.78
T-SQL query that includes missing records	-0.46
Recursive CTE for parent and child relationship in SQL Server	-1.41
How to exclude few rows from displaying? "DISTINCT" - SQL...	+0.13
SQL Server 2012 split nvarchar(max) carriage returns into separate...	0.00
SQL Server Linked Server Update - terrible performance	+0.58
Get all stored procedures that perform a read, update, delete in th...	0.00
SQL IF/ CASE statement	-0.13
How to avoid not to query tables or views in scalar functions?	+0.13
Not able to use temporary column created using Cross apply in Left...	-1.25
How to select a value based on the position from a delimited column...	+0.58
How can I parse one field into multiple fields in the same table?	+1.05
How can I duplicate the result set like below	+1.67
SQL Server Insert rows from a table into another table with null va...	0.00
Import a Multi-format Delimited File	+0.56
Populate HTML Email Template with Data from SQL Server Query via Or...	0.00
How to get distinct id in subquery from fact table	+0.13
How to create tables in a linked table using OPENQUERY?	0.00
Fixed width file to sql server wide table	+0.59
Finding nth row using sql	-0.11
Multiple SQL running two queries then querying the result for one r...	-0.42
Import Multiple Different .txt Files to SQL Server from a Folder	0.00
SQL - WHERE with CASE statement	+0.32
Multiple complex string concatenations in SQL Server	+0.06
I want to update my table according to previous month	+0.06
How to search on a varchar column using a number?	+2.38
How to select recent errors that were raised in an SQL-Server datab...	0.00
Calculate percentage of a value in a column when count is given	-0.50
How to extract partial string based on characters in SQL server?	+1.77
SQL Server query where relationship does not exist between three ta...	+1.17
Passing comma separated values to sp_executesql	0.00
Group by, deriving only one data set and more than one dataset	+0.49
SQL Server Stored Procedure: Read data from URL text file	0.00
Error with group by in inner query of correlated sub query	-0.04
Need to delete a row if it is occurring twice in a year and quarter...	-0.48
How to get column and row information from SQL?	0.00
How to keep singles values in a Column with SQL with a certain fiel...	+0.50