Skip to content

Instantly share code, notes, and snippets.

View seansparkman's full-sized avatar

Sean Sparkman seansparkman

View GitHub Profile
Set-WindowsExplorerOptions -EnableShowHiddenFilesFoldersDrives -EnableShowProtectedOSFiles -EnableShowFileExtensions
choco install DotNet4.5
choco install git
choco install fiddler4
#Enable Web Services
choco install IIS-WebServerRole -source WindowsFeatures
choco install IIS-ISAPIFilter -source WindowsFeatures
choco install IIS-ISAPIExtensions -source WindowsFeatures
SELECT *
FROM (
SELECT [ID],
ROW_NUMBER() OVER(ORDER BY ID DESC) AS Row
FROM [Stats].[dbo].[OriginCodes]
) codes
INNER JOIN
(
SELECT [Id],
ROW_NUMBER() OVER(ORDER BY ID DESC) AS Row