For choice of front end user application IIS and other Web Servers serving web pages are actually the majority used method. But any language is pretty well capable (C, Delphi,...

Also, if using Front Page there are two good books,

Front Page Inside Out http://www.amazon.com/exec/obidos/tg/detail/-/0735615101/qid=1085780084/sr=8-1/ref=sr_8_xs_ap_i1_xgl14/102-1779313-4044117?v=glance&s=books&n=507846

Front Page Bible http://www.amazon.com/exec/obidos/tg/detail/-/076453582X/qid=1085780147/sr=1-2/ref=sr_1_2/102-1779313-4044117?v=glance&s=books

but in reality depending on your server software if using IIS5 or...

How do you mean. There are many ways tables can be viewed and each has a specific way. FOr instanes if you are querying sysobjects in a db then use...

SELECT COUNT(*) FROM

 Customers C

LEFT JOIN

 Orders O

 INNER JOIN

  [Order Details] D

 ON

 O.OrderID=D.OrderID

ON

 C.CustomerID=O.CustomerID

Just to throw in here the short and simple is this.

Any join is closed out...

Are you sure, I thought you were geenrated multiple recordset in that case and could use .NextRecordset to move thru them. Sorry nothing to test with here to be sure.

What does the user account have for permissions and if no one knows for sure just disable all permissions until a user grips and tells you who added.

That would then mean thet ISNUMERIC actually does and explicit conversion of whatever you are entering.

Try

SELECT

N.[ID], N.TRANS_DATE, N.AMOUNT

FROM

tblName N

INNER JOIN

(SELECT [ID], MAX(TRANS_DATE) TT FROM tblName T2 GROUP BY [ID]) TQ

ON

N.[ID] = TQ.[ID] AND

N.TRANS_DATE = TQ.TRANS_DATE

Please run in query analyzer the following:

set showplan_text on

go

update q12004

set q12004.batch = adnh.batch

from adnh

join q12004

on adnh.phone = q12004.col035

go

And post the output back here. This will show us your execution plan...

I have 2 SQL 2000 servers I patched to .859 that started this. Something in the patch causes it and I haven't narrowed it down yet. Without reinstalling, the Hotfix...

Try NEWID() for ORDER BY, it isn't a number but does have the desired effect.

What ways have you tried from your machine? EM, QA, other? If the issue is in EM you may need to remove the server for being registred then reregister it...

Take an immediate snapshot of sp_who2 and use Performance Monitor to check Network, Memory, IO and CPU while the problem is occurring.

Sounds like somewhere the network may be fuzing out...

Take a look here http://support.microsoft.com/default.aspx?scid=kb;EN-US;303774

Try this

order by

      (case when @orderby = 1 then [text]

           when @orderby = 2 then left(convert(varchar,[timestamp],112),6)

    when @orderby = 3 then deptid

           when @orderby = 0 then left(convert(varchar,[timestamp],112),6) end)

Note:...