Are you sure you are in the correct database.

If you run Query analyser whilst the databases node is selected in QA then the database you will be connected to will...

This are the 2 functions,

so you can do something like

SELECT * FROM dbo.SplitTokenString ('1,2,3,4,5,',',')

which will return

1

2

3

4

5

IF EXISTS (SELECT 1 FROM sysobjects WHERE name='SplitTokenStringPositions')

DROP FUNCTION dbo.SplitTokenStringPositions

GO

CREATE FUNCTION dbo.SplitTokenStringPositions...

The recompile issue is larger than just using the WITH RECOMPILE and is not just for temp tables.

You shouldn't significantly alter the contents of a table and then use that...

Creating temporary tables and populating them in an SP can cause all sorts of problems in SQL 7 and 2000 due to recompilations that occur when the original plan for...

Ditto

There are a number of scripts on this website for udfs that return a table of values from a delimited list.

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

Thought I had replied to this. The problem is more to do with the memory of the machine. The server only allows a certain amount of memory of XML documents,...

I have posted a procedure into scripts (awaiting review) that takes a sql statement as the input an prepares the document it returns. i.e it mimicks the use of sp_xml_preparedocument

It...

What error do you get?

I have created a jobs table and tried your sp and don't get a problem. Is the column nullable?

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

OPENXML is the neatest solution as it does not require any new functions and performs better than a custom user defined function.

If you want to go down the userdefined route...

What sort of reasons might they not be updated?

Why are using a cursor. you should be able to dump the data from the xml document into a table variable and...

Just a note that table variables are not in-memory structures the data is written to disk in the same manner as any other table. The benefits are due to the...

Oracle have a Migration Work Bench that might do the trick?

http://technet.oracle.com/docs/tech/migration/workbench/content.html

<rant>

The options in ADO (2.6) are return the data from the database, translate to xml using save method then using XSL transform it into the form you want i.e getting...

This mechanism should really be avoided due to the fact that indexes cannot be used optimally. Dynamic SQL is not a bad thing if used correctly. Inserting 100000 rows into...

I am really torn because I see the returning of an XML document with hierachical data as really neat and will reduce the master, detail calls to the database to...