True, but that's not "SQL" so much as it is an implementation artifact of T-SQL and SQL Server. And it's got so many conditions on it that I frankly...

Great. What is the answer?

Matt Miller (12/31/2008)

---

Have you tried simply using SQLXML? Using XQuery for this in SQL is reminiscent of buying a hammer and some nails, but then throwing away the hammer...

Heh. Only 20 replies, but over 2400 views on this thread...

So, lest the extremely important lesson of this discussion might be lost on any of the lurkers out there,...

You know, as long as we are on the subject: One thing that I would really like to see is a "Challenges" forum. Someplace were one of us...

Paul (6/7/2008)

---

I have been working on this problem and have a something that gives me what I want, but it takes 7 seconds to process. Any ideas why this is...

You know, I am not sure that you can have a named instance of SQL 2000, without it also being the default instance. I have a very strong recollection...

Also: Forgetting that the order that AND clauses are evaluated in at run-time has nothing to do with the order that they are written.

So:WHERE IsNumeric(StringColumn)

AND CAST(StringColumn As NUMERIC)...

Oh without a doubt:

And it's even more pernicious corollary: Order(rows returned) = Order(rows inserted)

Are you getting any errors?

Suggest you try using 'USE [?]; ... ' instead.

Then search for that command in msdb.dbo.sysjobsteps of the calling server.

Yes, how are you doing this?...

That said, I do however know of three indirect ways to effectively do this. The first is through SSIS as Ninja has already mentioned.

The second is to create a...

I do not believe that there is any direct way to do this (effectively GRANT EXECUTE on xp_cmdshell). The problem is as follows:

First, the ability to use xp_cmdshell is...

How are you "calling" one job from another?