Index Hints?  Table Hints that reference indexes yes, but Index Hints?

The Systbl.chm can be found at:

http://www.microsoft.com/sql/techinfo/productdoc/2000/systables.asp 

Are you trying to log the beofore and after changes? Maybe eomehting like this?

Insert

LogTable

(

refnoBefore

, refnoAfter

)

Select

d.refno

, i.refno

From

insertedi

inner join

deletedd

on d.id = i.id

Results via UDF

Select s.ServerName From dbo.fnAvailableServers() s

Create Function fnAvailableServers()

Returns @server table

(ServerNamevarchar( 255 ))

as

Begin

Declare

@rc int

, @object int

, @Method varchar(255)

, @cnt int

, @i int

, @name varchar(255)

-- initialize...

From http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnserv/html/server01242000.asp

Server.CreateObject vs. CreateObject

Recommendations

Use Server.CreateObject. If you're using MTS/COM+ library packages, use Server.CreateObject to avoid blocking of threads.

Why

CreateObject equates to calling CoCreateInstance by the scripting engine. If you...

You can also get the error when attempting to update a variable instead of a column ( note @MyField instead of MyField):

UPDATE MyTable SET @MyField = 'beta' WHERE MyField...

Thanks. That worked

Here is the function I use. You can use it withing a join to filter other tables.

Select * from fnSplit('2541,2542,5362,36585,36884', ',')

Returns:

ItemId Item ...

I use IsNull instead of Coalesce, it's faster. BTW, either way, if there are indexes for the column, the indexes WILL be used.

Use Northwind

Declare

@CustomerIDnchar( 5 )

, @CompanyNamenvarchar( 40 )

Select

@CustomerID...