Removing duplicates (Handy)

   

--delete x from
   select * from
     (
      select *,  rn=row_number() over (partition by amount, number order by id)
      from [exTable]
      --where exTable.number = '1019351'
    ) x
    where rn > 1;

Comments

Post a Comment

Popular posts from this blog

Bootstrap Modal Popup is Grayed Out

The popup shows up, but after it pops up the whole page becomes unusable.  So not only was it not displaying right, the whole page is frozen.  I found a StackOverflow post, below describing how the popup may have that behavior when it is nested inside elements that have positioning elements, which fits with previous experiences I have had.  One of the answers described how appending the modal popup to the body of the page  "$('#mytModal').appendTo('body');" would be a way of getting it out of any positioning elements.  Previously on a different page I had moved it out of some divs and it worked right.  However in this particular site the modal is in a ASP.Net site as a user control where the "offending" positioning element is in the master page and it contains the user control.  I stuck the script in the user control, but the behavior was the same.  When I used Firebug I saw that I was getting a "$ is not defined" message. With Jquery we ne...
Read more

Telerik - Custom Group Footers In RadGrid

As anyone that has dealt with this knows Telerik only supports a single Group or Header Template.  So what happens when you want to change them?  You really only have two options from what I have seen.  The first option is to have something in the data that is brought back that you can use in the designer code in the form of a conditional.  Too bad I do not see a way to check the data based on level like some sort of ParentID like some people have done.  If the ParentID is null  It would look something like below where you check it in the designer: < asp : Label runat = "server" ID = "Label2" Text = '<%# "Number of items in group: "+ (((GridGroupHeaderItem)Container).AggregatesValues["AvailableUnits"]) %>' Visible = '<%# ((((GridGroupHeaderItem)Container).AggregatesValues["AvailableUnits"]) != null)%>' > Or you can use the code behind to really get at the groupIDs like this per...
Read more

DNN Site Crawler - LuceneController is disposed and cannot be used

http://www.dnnsoftware.com/forums/forumid/198/threadid/527555/scope/posts/threadpage/2 Found out our app pool is recycling every minute or so due to unrealistically low virtual memory settings, and that was causing problems.  That Site Crawler seems to be used for when you use the site search functionality.  However I have disabled that Site Crawler in HOST->Scheduler which we do not use, and that got rid of the error.
Read more