The problem is exactly what JBoals states. Int will sort 1-10-100 however varchar because it is a dictionary sort order will sort 1,10,100,2,20,200,3,30,300... so either change the column (which would...

quote:

---

Antares, will that work? The first part I mean, the ORDER BY clause. I thought you needed to have all sort columns...

Just change the last bit of the last comment I woudl suggest do this way.

Do Until rs Is Nothing

Do Until rs.EOF

'process...

SQL.LOG is the default name of the ODBC trace file. Open the control panel applet ODBC Data Sources. On the Tracing tab you will find the defined path and there...

FOr SQL 2000, if you need to resize on the fly conside SET ROWCOUNT x which will return the number of rows defined by x. Also, overall performance with SET...

Sounds like a resource issue. Usually if the box grounds to a halt using QA with sp_who will be the only thing that runs unless you have really maxed it...

First, are you returnning multiple sets? If so then perform a nextrecordset in your asp page on the recordset object and should be there.

"Don't roll your eyes at me. I...

Sorry, the xp dll's have a specific format internally that allow SQL to interact with them but as for looking at the code most likely will not be able to...

This is my opinion at least doing the Microsoft ciriculum. Cost is ridiculous. If your company will pay then go for it. Might also consider doing MCSE or MCSD or...

Make sure you cleints are connectiogn and supplying the windows authencation information. If is then backup your server. Now try regsvr32 with the -u switch to unregister comnevnt.dll then register...

First you need to get the date without time or at least starting at miidnight so that can be easiest done with CONVERT (Ex. CONVERT(varchar, GETDATE(), 101) returns format mm/dd/yyyy...

For output when you select you can use the CONVERT function with format, see BOL for more. However in QA and EM it will output in military unless you select...

crdate >= @lastdateused and crdate <= getdate

is the same as BETWEEN, however BETWEEN generally runs fastest.

If you cannot see from the execution plan the problem then try

SET SHOWPLAN_TEXT ON

GO

YOURSELECTQUERY

GO

and post...

Hey Robert

The key is your statement here.

quote:

---

The number of failing rows exceeds the maximum specified.

---