SQL SERVER – Delete Duplicate Records

Following code is useful to delete duplicate records. The table must have identity column, which will be used to identify the duplicate records. Table in example is has ID as Identity Column and Columns which have duplicate data are DuplicateColumn1, DuplicateColumn2 and DuplicateColumn3.DELETEFROM MyTableWHERE ID NOT IN(SELECT MAX(ID)FROM MyTableGROUP BY DuplicateColumn1, DuplicateColumn2, Dupli...

div element

What is a div element? A div element is a block of content that can be positioned anywhere on your site by using absolute positioning and the tag. The purpose of div elements is to hold content, whereas frames hold pages. This content can be placed anywhere on your site and it can even overlap. The content can consist of images or html. All of the style elements like scrollbar color and font color...

July 14, 2010 Designs 0 Read More →

Bing Map Virtual Earth intellisense

Bing Map Virtual Earth intellisense Sample SoutionThe solution can be downloaded from: http://www.aggregatedintelligence.com/Samples/VEandWS/VEandWS.zipReference: * Virtual Earth SDK reference: http://dev.live.com/virtualearth/sdk/ * Virtual Earth Dev site: http://dev.live.com/virtualearth/ * Virtual Earth Tools for Visual Studio: http://dev.live.com/tools/ (This is an alternate way to use...