You can take an existing Git repo and add a remote using the git URL provided when you created your app. You may need to do this to associate a Git repository with an existing application.
The Heroku git:remote command will add this remote for you based on your applications git URL.
heroku git:remote -a myApp
Git remote heroku added.
WITH cte AS (
SELECT [Field1], [Field2]
row_number() OVER(PARTITION BY [Field1], [Field2] ORDER BY [Field1]) AS [rn]
FROM [Table1] WHERE [Column1]=[Condition1]
DELETE cte WHERE [rn] > 1
I was working late at our St. Vincent Place HQ on the day after the referendum and heard some noise down at George Square with Google Glass so I went down to investigate and got the following footage…