Check the compatibility level of the database:

exec sp_dbcmptlevel YourDBName

It needs to return 7.0 or greater, otherwise TOP isn't available.

>>All 4 tables have indexes. 

But are any of the columns being updated, indexed ? When you update an indexed column to change the value, SQL Server not only has...

Are there any indexes on the columns being regularly updated ? Are the columns being updated fixed or variable length ? Is the WHERE clause on each update statement referencing...

To get text into a table in SqlServer, there are several alternatives:

- DTS package

- BULK INSERT command from within a T-SQL batch/procedure

- bcp command line tool (and calling bcp from...

There is no direct comparison & it depends on what you're trying to do. utl_file allows file I/O from within stored procs, right ?

Thanks for getting back to us on it.

Thankfully this will all go away when we get ROW_NUMBER() OVER() in Sql2005.

Possibly due to teh "*=" ? From BOL ...

Transact-SQL Joins

In earlier versions of Microsoft® SQL Server™ 2000, left and right outer join conditions were specified in the WHERE...

Doh. Thanks Remi.

Cerebral cortex system error: Please install more caffeine and try the operation again.

Heh, good catch. The images get inserted with file: tags pointing to the local disk, so only the author of the reply can see them. Guess you have to host...

Select Name, Sum(Laps) As TotalLaps

From

(

  Select Name, Laps

  From Tom

  Union All

  Select Name, Laps

  From Dick

  Union All

  Select Name, Laps

  From Harry

) vtable

Yes, you can use CASE in a WHERE clause:

SELECT *

FROM YourTable

WHERE pkID =

  CASE @ID

    WHEN 0 THEN pkID

    ELSE @ID

  END

This:

>>try using the...

When SQL Server generates statistics, it uses sysindexes to hold entries, and these are named "_WA_Sys_*". The 'status' column should distinguish them from 'normal' indexes.

Create a new package. Add the text file source from either the connection toolbox, or the connection menu:

You need to post the full SQL - considering that the error relates to columns in the Select and Order By lists and you omitted the column names from both,...

Open EM. Expand this item:

Management->SQL Server Agent->Jobs

Right-click on Jobs, select New Job. See the "Steps" tab, create a new step and observe where a SQL statement can be pasted. This...