What about:

select

 o.customerID

 , o.orderdate

from

 northwind..orders o

where

 o.orderdate=

  (select

    max(o1.orderdate)

  from

   northwind..orders o1

  where

   o.customerID = o1.customerID)

group by

 o.customerID

 ,o.orderdate

In order to get this running you need to execute sp_addextendedproc with this DLL. Otherwise SQL Server doesn't know how to handle it. And yes, it will be then an...

Can it be you're doing this exercise for some sorting reasons?

Here are several methods that will sort correctly on a VARCHAR:

SELECT

 TOP 1000 n = IDENTITY(INT)

INTO

 Nums

FROM

 Sysobjects S1...

Search the site here. This is a FAQ.

I for myself like the stuff by Ken Henderson.

To add to Steve:

If in your place ASP hosting is also much more expensive than PHP hosting, you might want to use a PHP based content management system like mambo, postnuke...

< vbg >

Sorry for being late on this.

Actually,  I think there is more than one way to solve this.

Given your sample data:

set nocount on

use...

I will paint an "L" on my forehaed for the rest of the day!!

Bear with me, since I am a non-native english speaker.

What...

There are many ways for this. If you search the web for trees and/or hierachies and SQL Server, you'll find some very good approaches. Maybe you can start from here:...

Hm, a little bit vague is your description. Anyway, does this help you:

http://support.microsoft.com/?kbid=274463 

Can't comment on the formatting of MONEY. However, MONEY gets also funky when division and/or multiplications are involved in calculations with MONEY:

declare @m1 money, @m2 money, @m3 money

declare @d1 decimal(19,4),...

Even if you can repair it for now, check your hardware closely to make sure it won't happen again.

If it doesn't help, I would call MS PSS.

May I ask what's the purpose of this whole exercise? What are you trying to accomplish?

Have you searched the script section here?

Anyway, it would also help if you could post the procedure along with sample data and the desired output.