vijayanandgawle

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. DELETE FROM MyTable WHERE ID NOT IN ( SELECT MAX(ID) FROM MyTable GROUP BY DuplicateColumn1, DuplicateColumn2, DuplicateColumn3)

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 can be controlled by a simple style sheet. How do I make a basic div block? This is the code for a basic div: Content goes here (images, text) In the above code, there are a few variables that need to be defined: •id: This is just the number of your div. It helps you sort out easily which div element is which when you have many layers. It's also useful for identifying layers so that you can have different style attributes in your style sheet for each div element. •Top: This is the number in pixels that your div element will be positioned horizontall

Bing Map Virtual Earth intellisense Sample Soution The solution can be downloaded from: http://www.aggregatedintelligence.com/Samples/VEandWS/VEandWS.zip Reference: * 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 VE Maps in your ASP.Net app. It provides you with a server side VE Map control, which means that you can load it with data in your server side code). * VE intellisense for Visual Studio 2008: http://www.codeplex.com/VEJS (This will make your life extremely easy to work with the VE map control, as it provides you with intellisense inside Visual Studio).