Skip to content

Instantly share code, notes, and snippets.

@jmreynolds

jmreynolds/BadAlias.sql

Last active April 22, 2016 20:59
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jmreynolds/1c490b8f1adb4d1adab265d9e711fb2d to your computer and use it in GitHub Desktop.
Save jmreynolds/1c490b8f1adb4d1adab265d9e711fb2d to your computer and use it in GitHub Desktop.
Download ZIP
Gist with samples for my SSMS and LinqPad blog post
Raw
BadAlias.sql
SELECT [t1].[column] FROM [MyTable] AS [t1]
Raw
BetterTimeTruncate.sql
DATEADD(hour, datediff(hour, 0, protocolCommands.[Time_stamp]), 0) AS GroupTime
Raw
UglyTimeTruncate.sql
CONVERT(DATETIME,
(CONVERT(NCHAR(4), DATEPART(Year, [t0].[Time_stamp])) +
('-' + (CONVERT(NCHAR(2), DATEPART(Month, [t0].[Time_stamp]))
+ ('-' + CONVERT(NCHAR(2), DATEPART(Day, [t0].[Time_stamp]))))))
+ (' ' + (CONVERT(NCHAR(2), DATEPART(Hour, [t0].[Time_stamp]))
+ (':' + (CONVERT(NCHAR(2), @p0)
+ (':' + CONVERT(NCHAR(2), @p1)))))),
120) AS UglyNastyMess
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment