Stack Exchange

John Cappelletti

Barrington, RI, United States

top accounts reputation activity favorites subscriptions
Top Questions
Top Answers
26
SQL Server date format yyyymmdd
stackoverflow.com

14
How to convert a float into int using round method in ms sql?
stackoverflow.com

13
How to make JSON from SQL query in MS SQL 2014
stackoverflow.com

13
Address standardization within a database
stackoverflow.com

12
SQL Server: weighted average + GROUP BY
stackoverflow.com

11
TSQL ORDER BY with nulls first or last (at bottom or top)
stackoverflow.com

11
Get list of columns in a temp table in SQL Server
stackoverflow.com

11
Get date from int (YYYYMMDD)
stackoverflow.com

10
convert yyyy-mm-dd hh:mm:ss to yyyy-mm-dd in sql
stackoverflow.com

10
Determine days of week from bit mask
stackoverflow.com

9
How to unpivot columns using CROSS APPLY in SQL Server 2012
stackoverflow.com

9
Best method to split columns into rows?
stackoverflow.com

8
SQL: Select Duplicate Values using Distinct, Not Exists, CTE, Union
stackoverflow.com

8
SQL Server 2014 Random Value in Group By
stackoverflow.com

8
SQL Server - Remove all non-printable ASCII characters
stackoverflow.com

7
Unpivot Multiple columns from specific Table
stackoverflow.com

7
Why does LEFT(Datetime,1) give me “J”?
stackoverflow.com

7
Inserting XML into SQL Server table
stackoverflow.com

7
SQL Server search using like while ignoring blank spaces
stackoverflow.com

7
Convert Alphanumeric value to a unique numeric value in SQL
stackoverflow.com

7
SSMS 2012: Convert DATETIME to Excel serial number
stackoverflow.com

7
How to parse a complicated string in SQL Server
stackoverflow.com

7
convert string to both date and time
stackoverflow.com

7
TOP N as stored proc parameter without using dynamic SQL?
stackoverflow.com

7
What's the most efficient way to normalize text from column into a table?
stackoverflow.com

7
Create a year/quarter table in SQL without a loop
stackoverflow.com

7
Transpose SQL columns to rows
stackoverflow.com

7
Return column in separate row in SELECT statement
stackoverflow.com

7
How to ignore few properties in SQL Server JSON value
stackoverflow.com

7
get the data type of columns in a select query
stackoverflow.com

1 2 3 4