Skip to main content
John Cappelletti's user avatar
John Cappelletti's user avatar
John Cappelletti's user avatar
John Cappelletti
  • Member for 11 years, 11 months
  • Last seen this week
  • Barrington, RI, United States
Profile Activity
Stats
81,290
reputation
4.0m
reached
3,488
answers
10
questions
Communities
View all
Badges
View all badges
7
gold badges
46
silver badges
67
bronze badges
Top tags
View all tags
5,288
Score
3,159
Posts
90
Posts %
3,944
Score
2,306
Posts
66
Posts %
2,422
Score
1,250
Posts
36
Posts %
312
Score
222
Posts
6
Posts %
309
Score
186
Posts
5
Posts %
291
Score
180
Posts
5
Posts %
Top posts
View all questions, answers, and articles
53
SQL Server date format yyyymmdd
Dec 27, 2016
42
How can I convert a float into int using the 'round' method in SQL Server?
Sep 20, 2016
37
Get list of columns in a temp table in SQL Server
Dec 22, 2016
26
SQL Server: weighted average + GROUP BY
Mar 3, 2017
22
Get date from int (YYYYMMDD)
Aug 3, 2016
18
TSQL ORDER BY with nulls first or last (at bottom or top)
Mar 23, 2017
18
SQL select dummy data
Jul 9, 2018
17
How to make JSON from SQL query in MS SQL 2014
Oct 9, 2016
15
How to unpivot columns using CROSS APPLY in SQL Server 2012
Feb 7, 2018
14
Address standardization within a database
Dec 20, 2016
Top Meta posts
1
0
4
Ranking Discrepancy
Top network posts
View all network posts
9
How to create a row for every day in a date range using a stored procedure?