.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Sandeep Singh
Melody Anderson
Eminent IT
Post New Web Links

Select Latest row with latest date

Posted By:      Posted Date: October 28, 2010    Points: 0   Category :Sql Server

Hi there,

This is what I'm trying to accomplish,

Date               Customer_name     Balance

Feb-01-2010    Customer1               $100.00

Oct-20-2010    Customer2                $300.00

I'm trying to get the latest row values from the table above.

Thanks very much.



View Complete Post

More Related Resource Links

Latest Records depending on Last Modified Date

Hi there,             I have to get the latest records from the table depending on Last Modified date. Table: ID  Function   Apply        Approved    Withdrawn   LastModifiedDate 1    Coding    1/1/2010   15/1/2010   21/1/2010     21/1/2010 3:58:23 1    Coding    1/1/2010    NULL           NULL           21/1/2010 4:58:23 2    Testing    1/1/2010   15/1/2010   21/1/2010    21/1/2010 3:58:23 3    Analysis  1/1/2010    NULL           NULL           21/1/2010 4:58:23   Output is needed on the basis of last modified date if same fucntion comes more than 1 time. else all other functions need which appears once in table. ID  Function  Apply      Approved    Withdrawn        LastModifiedDate 1    Coding   1/1/2010    

Display latest date in GridView



           I m getting data from database using SQL

string mysql = "SELECT [ID],[FirstName],[LastName],,[MiddleInit],[DateLastModified] FROM [Databse] WHERE ([ID] = '54321') ORDER BY [DateLastModified]";

I have 4 rows for this sql and I m displaying in GridView. I want the latest modified date as my first row but it is displaying in a reverse order. How can I display rows using Latestmodified date without sorting.


Windows 2000 Registry: Latest Features and APIs Provide the Power to Customize and Extend Your Apps


The Windows registry as it is recognized today first appeared in Windows 95. Its introduction simplified the storage of initialization information and made that data more secure. This article covers the history of the registry, the form it took in the early days, and its current incarnation in Windows 2000. Practical tips for managing data in the registry are outlined, along with descriptions of special keys, functions, and file types. Manipulation of the registry to customize both application behavior and certain features in Windows is discussed. Also covered are future directions of the registry, including the use of XML to store registry information in a hierarchical fashion.

Dino Esposito

MSDN Magazine November 2000

Where to find the latest list of critical SQL Server fixes?

Hi, Where can I find the latest list of critical SQL Server fixes?

Filters Latest Versions?

I created a dynamic data site with asp.net 3.5 and I see it doesnt have the filter folder yet, so which are the latest version and blog post with instructions in how to install the filters part.?I saw this but this is from 2008http://csharpbits.notaclue.net/2008/09/dynamic-data-futures-advanced-filters.htmlThx

Kindly guide me to get a quick start with latest NHibernate Technologies

I worked on NHibernate around 4 years ago, now in one of the project I want to implement it again. Can someone share their experiance about latest tools available to speedup the development of NHibernate.I have used a tool to generate ORM Mapping (I think its name was Puzzle.Net), can you also sugesst some good tools for NHibernate.

How I select Start of week is Friday from date of Year ?

Hello everyone, I am tring to solve How i select Start date is Friday from week? Details for which i want to show I have dtmDate column in a query. from that date i display week of that date as per using (ww,dtmDate) as dtmWeek, and parameters are StartDate & EndDate Suppose I select StartDate as 1/1/2007 & End Date as 12/31/2007   I  do not want to show Output as: Weeks                      Column1          Column2 1/1/2007 (Thuesday)       5                     6 1/2/2007 (Wed)               4                     2 | | 1/5/2007  (Friday)            1                      8 1/6/2007 (Saturday)        7                     

Can animation extender be used to replicate Twitter's smooth-scrolling, latest-tweet control?

I'm not going for the exact same control, but if I can find a smart way to automatically/smoothly scroll through text from the database on Timer Tick intervals of 5 seconds... then I can use that as a template. My main idea would be to just dynamically create panels with the text inside of them, then dispose of them when they come towards the bottom of the list... but 3 things stop me 1) it would be a lot of work, 2) when the last panel cycles to the bottom of the display area then how do I make it smoothly disappear? 3) What would I use for the display spot?- a Panel won't work because if its contents exceed the set height, it either just expands to fit it or adds scroll bars. I basically want it to have slideshow functionallity how the images smoothly scroll every few seconds (without the scroll bar), and instead of images I want to use text. Any ideas?

Only $379, down from $489, Latest Generation Kindle DX Wireless Reading Device, Free

AVI to iPad Converter is a professional but easy-to-use iPad Video Converter which can convert AVI to iPad, convert DivX to iPad and XviD to iPad with perfect quality and fast conversion speed. Besides AVI videos, this AVI to iPad Converter also can convert MPG, MOV(Quicktime), FLV(Youtube), VOB, Mp3, AAC and other popular fomats for iPad Wi-Fi, iPad Wi-Fi+3G, iPad 16GB, other iPads, iPod touch, iPod nano 5G, iPod shuffle even iPhone, iPhone 3G and AppleTV and the updated iPhone OS 3.1.3. Guide: How to Convert AVI to iPad for enjoying with iPad? Step 1: Free download, Install AVI to iPad Video Converter and then run it. Step 2: Set output format according to your iPad by clicking "Profile ..." and the following pops up. Step 3: Click"Open File" to load AVI/divx/xvid videos. You can add many AVI video files as you wish at the same time . Step 4: Click "Convert" button and start converting AVI Videos to iPad. Just a few minutes, the whole conversion is ok, and then you can enjoy the converted files with your iPad. AVI to iPad Converter is an excellent solution for iPad owners to enjoying your AVI videos, XviD and DivX videos.   ----------------- Related iPad Software PDF to ePub Converter | iPad Manager for ePub (win+Mac) | iPod Touch Manage for ePub (Win+Mac) | iPhone Manager for ePub (win+mac) | PDF Converter Ultimate -

What is the most uptodate .NET Framework I can use on Windows XP with latest service pack?

Hi, I am doing consultancy work for a small company that still uses Windows XP. I want to develop a .NET Windows Application for them in C#. Can anyone tell me what is the latest version of .NET Framework I can use on an XP machine (with latest SP). I will be developing code on a Vista Home Machine and will port it to this XP machine. If you know where Microsoft keeps info on this then that would be useful. Thanks. John. 

what is the latest version for SQL Server 2008 R2

We are using Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)   Apr  2 2010 15:48:46   Copyright (c) Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 5.2 <X64> (Build 3790: Service Pack 2).    LISA86

What is the latest version of Business Intelligence Development Studio (BIDS) 2005

When open BIDS 2005 and go to help ---> about i see the following: Microsoft Visual Studio 2005 Version 8.0.50727.42  (RTM.050727-4200) Microsoft .NET Framework Version 2.0.50727 SP2 Do I have the latest service pack installed for BIDS?

change latest news runtime

one of my client has the requirement of changing the latest news section of website dynamically or runtime so not to publish the site and host it agian and again.this section is in master page how can i achieve this in asp.net c# 

What are the latest advancement in MS VisualStudio 2010?

Give me the latest advancement in VS 2010?

Latest on OleDb Access to 64 Bit MS Access


I am building an application using VS 2010 on Windows 7 (64bit) running Office 2010 (64 bit).  The application needs to access a MS Access database (accdb).  I have downloaded and installed the updated oledb drivers "Microsoft Access Database Engine 2010" from http://www.microsoft.com/downloads/en/details.aspx?familyid=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en

My connection string is "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=F:\\<path>\\<filename>.accdb"

I still get the error "Microsoft.ACE.OLEDB.12.0" provider is not registered.

I see the provider in the registry (I assume it is the right place since the installer put there...HKLM.SOFTWARE.CLASSES.)

Visual Studio Data Sources gets the same error connecting to the database through the server explorer.



select top row for multiple entry for a date in table


My current query is

select  Date= createdon , Total=count(*) from ReportDetail where 
reportid = 9 and (CreatedOn BETWEEN '07/01/2010' AND '09/30/2010') 
group by  createdon
order by createdon desc

return data like

2010-09-21 09:36:46.493    112
2010-09-21 08:33:12.667    114
2010-09-21 07:45:20.830    176
2010-09-21 07:33:34.340    114
2010-09-20 07:27:43.753    125
2010-09-17 10:04:27.120    75
2010-09-16 11:50:05.777    52

What I am looking for

2010-09-21 09:36:46.493    112
2010-09-17 10:04:27.120    75
2010-09-16 11:50:05.777    52

Basically for 9/21, I want to get only one latest row. Please advice.

Error while adding reference to latest version of AjaxControlToolkit


HI All,

I am a bit new to ASP.Net Ajax and as such new to Ajax itself. I have a site which uses ASP.Net Ajax.  It used the version AjaxControlToolkit version 3.0.30512.0. I have now changed it to version 3.5.40412.2 by deleting the old reference and adding a reference to the latest one . I build the soultion and everything appears fine witjhout any errors. But the site fails to load showing a yellow page with the message AjaxControlToolkit Version="3.5.40412.2" missing reference to 'AjaxControlToolkit.ExtenderBase.Base Scripts.js.BaseScripts.js'. What does this mean ?

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend