select * from [table] where ID in (select min(ID) from [table] group by company )

Community Server[^] is nearing release, and it may fit your needs. Jon Sagara I bent my wookie. My Articles

I'm not certain, but doesn't escape convert funny characters into the hex equivalent??? Typo...it's escape NOT encode!!! It's frustrating being a genius and living the life of a moron!!!

alter database set RECURSIVE_TRIGGERS on Wout Louwers

Regex can be horribly unreliable and a complete pain when unforeseen formats creep up. I recommend using SgmlReader[^] written by a fellow Microsoftie. HTML is, if you don't know, an SGML grammar, as is XML and XHTML (which is actually an XML grammar that only looks like HTML because it uses the XHTML namespace as the default namespace so that namespace prefices aren't required). This posting is provided "AS IS" with no warranties, and confers no rights. Software Design Engineer Developer Division Sustained Engineering Microsoft [My Articles]

Thank you Charles. *->>Always working on my game, teach me *->>something new. cout << "dav1d\n";

I take it that you are trying to save the html of the table to some file on the server? If this is the case, then you could create a htmlwriter and then call the render on the table control. Then save the stream down to a file.

Hi there. Here's a link[^] to another forum thread that shows an example of doing the same thing - Select @@Identity - in Microsoft Access. This should help you.

Thanks Jesse. I had thought of inheritance but your suggestion made me tinker a bit and it works really, really well. *->>Always working on my game, teach me *->>something new. cout << "dav1d\n";

Self joins! There are a beautiful thing when some Neanderthal wants a denormalized report from you nice orderly normalized data structure.:wtf: Try this (works on sql server. Access is ???):select top 1 * from testloan t1, testloan t2, testloan t3 where t1.loanid<>t2.loanid and t2.loanid<>t3.loanid and t1.loanid<>t3.loanid order by t1.loanid desc, t2.loanid desc, t3.loanid desc Bill

That, and the "hidden" Java applet called "JS_Subscribe" or somesuch. They probably work in concert to catch all browser folk, regardless of Java or Flash capability. My guess, anyways :) Jeremy Kimball

I know this is not what you have asked but: Have you tried removing the need for a cursor? Cursors are "very" rarely needed. It has been my experience that changing cursors to properly indexed set operations removes any significant time-out issues.

A great article relating to your inquiry...Enjoy http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnbda/html/authaspdotnet.asp

Where/How are you trying to save the data? You should open up a filestream and save the data to that if your saving server side.

or <.*?> which is simpler. Help me dominate the world - click this link and my army will grow