skip to main | skip to sidebar

All Things Mark Stein

Mark Stein's blog chronicling daily things in his life including Crockett (his beagle/basset hound dog), social happenings, home remodeling projects, photography, outdoor adventures, concert reviews, guitar playing and oh... work

Tuesday, December 17, 2013

Delete Dupes

WITH g AS (
 SELECT ROW_NUMBER() OVER(PARTITION BY city, state, zip ORDER BY city, STATE, zip) AS row
 FROM dbo.Geography) 
DELETE FROM g
WHERE row > 1;
Posted by Mark Stein at 11:28 PM No comments:
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Categories

  • Colorado - Around Denver
  • Concerts
  • Crockett
  • Guitar
  • House
  • LINQ
  • photography
  • Programming: .NET
  • Programming: Javascript
  • Programming: SQL
  • Travel

About Me

Mark Stein
View my complete profile

Blog Archive

  • ►  2016 (1)
    • ►  February (1)
  • ►  2014 (1)
    • ►  May (1)
  • ▼  2013 (1)
    • ▼  December (1)
      • Delete Dupes
  • ►  2011 (2)
    • ►  July (1)
    • ►  February (1)
  • ►  2010 (4)
    • ►  August (1)
    • ►  July (1)
    • ►  June (1)
    • ►  February (1)
  • ►  2009 (2)
    • ►  July (2)
  • ►  2008 (4)
    • ►  August (2)
    • ►  February (1)
    • ►  January (1)
  • ►  2007 (26)
    • ►  October (1)
    • ►  September (3)
    • ►  August (3)
    • ►  July (3)
    • ►  June (6)
    • ►  May (1)
    • ►  March (2)
    • ►  February (7)

My Favorites

  • LinkedIn Profile for Mark Stein
  • Mark Stein Photography
  • Daily F-Stop (Mark's Photo Blog)
  • Roadside Peek (retro places)
  • Snow.Com (Let's go skiing)
  • Rock On Colorado
  • Herman's Hideway

Other Blogs

  • def kenny t. - Ken T's Blog