CREATE TABLE #Tracker( [Id] [int] NOT NULL, [Ticker] [nvarchar](4) NOT NULL, [SlopeOfLine] [int] NOT NULL, ) GO INSERT INTO #Tracker (Id, Ticker, SlopeOfLIne) VALUES (1, 'MSFT', 5) INSERT INTO #Tracker (Id, Ticker, SlopeOfLIne) VALUES (2, 'MSFT', 2) INSERT INTO #Tracker (Id, Ticker, SlopeOfLIne) VALUES (3, 'MSFT', 1) INSERT INTO #Tracker (Id, Ticker, SlopeOfLIne) VALUES (4, 'MSFT', 0) INSERT INTO #Tracker (Id, Ticker, SlopeOfLIne) VALUES (5, 'MSFT', -3) INSERT INTO #Tracker (Id, Ticker, SlopeOfLIne) VALUES (6, 'MSFT', 1) INSERT INTO #Tracker (Id, Ticker, SlopeOfLIne) VALUES (1, 'DELL', -2) INSERT INTO #Tracker (Id, Ticker, SlopeOfLIne) VALUES (2, 'DELL', -1) INSERT INTO #Tracker (Id, Ticker, SlopeOfLIne) VALUES (3, 'DELL', 2) INSERT INTO #Tracker (Id, Ticker, SlopeOfLIne) VALUES (4, 'DELL', 4) INSERT INTO #Tracker (Id, Ticker, SlopeOfLIne) VALUES (5, 'DELL', 3) INSERT INTO #Tracker (Id, Ticker, SlopeOfLIne) VALUES (6, 'DELL', 4) GO SELECT T1.Id, T1.Ticker, T1.SlopeOfLIne FROM #Tracker t1 LEFT OUTER JOIN (SELECT * FROM #Tracker WHERE SlopeOfLine<0) T2 ON T2.Ticker = t1.Ticker AND T2.Id > t1.Id WHERE T2.Id IS NULL AND t1.SlopeOfLine < 0 GO This may or may not be faster than the subquery method used above.

I have a project where I am converting a very complex MS Access front end to a VB.Net application. There are close to a hundred tables in a SQL database containing mostly but not completely static data that I plan on turning into individual classes. So for each class I have a strongly typed dataset for per table, and a class. Each table has an ID (IDENTITY) field as a unique key. What I am wanting to do is have a generic way of populating and updating each of these classes. Here is what I have so far. First I created a new Attribute class

Then in my class I use this to flag each property with the field that is associated with it in the database (the database is close to 10 years old and has no naming conventions whatsoever).

Imports System.Reflection

Public Class TransportMethod
Implements IEquatable(Of TransportMethod)
Private _code As String
Private _iD As Integer
Private _description As String
Private _requiresAttendant As Boolean

Public Sub New(ByVal row As dsTransportMethod.dtTransportMethodsRow)
    ProcessRow(row)
End Sub

<DataTableSource("TransportMethod")> \_
Public Property Code() As String
    Get
        Return \_code
    End Get
    Protected Set(ByVal value As String)
        \_code = value
    End Set
End Property

<DataTableSource("TransportMethodDesc")> \_
Public Property Description() As String
    Get
        Return \_description
    End Get
    Protected Set(ByVal value As String)
        \_description = value
    End Set
End Property

<DataTableSource("TransportMethodID")> \_
Public Property ID() As Integer
    Get
        Return \_iD
    End Get
    Protected Set(ByVal value As Integer)
        \_iD = value
    End Set
End Property

<DataTableSource("RequiresAttendant")> \_
Public Property RequiresAttendant() As Boolean

I have an application is running on a local LAN. I need to create a service that other users on the LAN can send XML data to, have it process it, and return back an XML recordset. It will need to be able to queue requests from multiple clients. I am looking for some ideas on where to get started. The clients will all be authenicated via Windows. They all will be connected directly via LAN. VB.NET is my preferred development language (have both 2003 and 2005) Thanks for your time. Lee