StackRating

An Elo-based rating system for Stack Overflow

Home | About | Stats and Analysis | Get a Badge

Rating Stats for

John Cappelletti

Rating
1624.85 (983rd)

Reputation
48,842 (2,077th)

Page: 1 2 3 ... 59

Title	Δ
Add a calculated column to pivot table columns in SQL Server	0.00
SQL Server: increment row number only one value	0.00
Is there a method to simply transpose a table in SQL. This table co...	-0.18
Create data ranges based on list of dates	+0.79
SQL Server : return row from two rows based on the precedence of on...	+0.91
SQL Server count distinct for each record	+0.36
Replace "NULL" values to "0" via SQL Pivot	+1.81
Retrieving row and column number from within a string in sql	+1.35
Pivoting data on SQL Server	0.00
SQL Server: Unique Composite Key that looks order	+0.33
Replace string at the starting position of fields	0.00
Is there a way to extract individual values from a varchar column u...	0.00
SQL server Query to get result after calculation	0.00
SQL Server concat empty string (not null)	0.00
Save a comma separated array in a string in a table	+1.74
Can I select all XML attributes in SQL without knowing the attribut...	-0.65
How to format the time value in format 00:00:00 for a time column	+1.29
How can I sort between characters and numbers in column	+1.94
Looking to find the minimum date given two columns (name and date)	0.00
Parse string in SQL Server 2016	0.00
SQL Server parse JSON to update another table	+0.34
How to convert column declared in database as varchar to time in SQ...	+1.83
Convert Full Date as String to Date SQL Server	+0.94
Finding and removing address duplicates	0.00
SQL Server order by clause issue	-0.18
SQL Server split string built in function vs old-style TVF for spli...	+1.68
SQL group need related value instead of aggregate function	+1.20
SQL Server use column value as column names and convert to json array	-1.84
Converting spaces and brackets to unicode in query result	0.00
Add data from one table into another	0.00
UNPIVOT Holiday Hours	+1.82
convert time in string to number of hours	-1.41
Why JSON import to a table shows all null values?	0.00
ORDER BY - Sorting the column consisting money with units	0.00
Sort numbers followed by a letter with datatype varchar	-0.64
How to fill ParentID column in one update statement?	-2.38
MS SQL Server how to instantly insert a 1 to 10 number column to ta...	+2.11
Alternative to placing scalar function in Where clause	0.00
How to substitute a partial string?	0.00
How to select only the most recent	+1.68
Recursive CTE listing all ancestors as columns	+1.25
How to combine If statement with Substring command in SQL?	-2.02
SQL query to produce multiple top 1 from single table	-1.00
Introduce incremental run number in sql based on another column	0.00
How do I pivot data (from long to wide), sum by ID, while merging d...	0.00
TRY_CONVERT in CASE WHEN	-0.16
How calculate two geo distance (Latitude,Logitude,Altidute) points...	0.00
Split Date/Time Data by Hour and Expand a Range of Date/Time into R...	+1.94
Getting The Period in Special Format	-1.46
Convert string type date field (dd/mm/yy hh mm ss ) to string YYYYM...	-0.28