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 4 5 ... 59

Title	Δ
Pivot in SQL Server T-SQL	0.00
Transpose multiple columns to rows from different tables	0.00
Combine column from multiple rows into single row	0.00
SQL query for below input and output?	0.00
SQL transforming one row to columns with unknown number of distinct...	+1.69
SQL Converting Columns to Rows	+1.78
how to get numbers before certain character string	+0.33
Write a SQL query to convert table from A to B	-0.52
SQL Server : special calculation for value in a view	0.00
Split multi-month records into individual months	+0.13
Get the only the last row in a sequence. SQL Server	+0.43
Cannot convert Varchar to DateTime - Conversion failed when convert...	+0.81
SQL Server : create a table where the columns are a row - index mod x	-1.88
Using SELECT result as string_pattern in REPLACE function	0.00
Unpivot subquery	0.00
Duplicate Removal from Different Rows interchanged columns	+1.02
How to merge results of OPENJSON into single list and remove duplic...	0.00
T-SQL to get the 5th word in each row in a database	+1.45
HTML data update for XML column with new value in SQL Server	0.00
How to Build select Query split Temp Value to two column one Per Nu...	0.00
How to add column Unit to @Header per every row have Flag Allow 1?	0.00
function that returns table struct with values when rowIndex is given	0.00
How to format/Scrub Source data for Import into SQL Server SSNs and...	0.00
Enforce the precision in datetime column	0.00
How to repeat a record n times - SQL Server	0.00
How to retain index when unpivoting data (SQL Server)	0.00
Converting date to YYYYMMDD format in SQL Server 2016 from T format	0.00
Change my data result from my table SQL Server	+0.33
how to get between dates from From dates to To dates column in to s...	+0.21
Split a string and retain character position	+1.20
Split record with start- and enddate into separate records in SQL?	-0.39
String split on multiple fields to one result	-0.36
Get newest record per group from subquery	0.00
Getting all the combinations of 6 numbers from a set of specific nu...	-0.33
TSQL - Create a GUID from a random text and then get back the origi...	-0.12
In SQL Server: Create Pivot Table with each Date as a own column	0.00
SQL Server : how to replace or convert string "ddMMM" to...	+0.75
Generate date sequence in T-SQL	-1.27
How to query all occurences of a header of a XML column in SQL Server	0.00
Calculate Histogram in SQL Server Where There Are Missing Buckets	+0.98
Given a specific column value, merge two columns in T-SQL	-0.90
How to parse a string with multiple underscores and dashes	+0.33
Adding sorting override to tree data with CTE	0.00
Query to extract only records which have failed	-1.93
Extract string between two characters in a string	-0.56
How do you pivot some columns into rows using sql or t-sql	+1.17
How do you pivot some columns into rows using sql or t-sql	-2.17
Concatenate Array Values Using Json_Query	0.00
Get last one year records	-1.93
How to get the second word in a string using t-sql?	-2.50