SqlContext.Pipe.Send("...") does the same thing as a Sql Print statement.

You are converting a Datetime to a Datetime, which has virtually no effect. You must convert the Datetime source into some string, like so:

SELECT

CONVERT(varchar(10), GetDate(), 101)

Please show us the calling SQL code.

Seems like "What Security is mapped by this ID?" should be a Service also. At least in an SOA environment.

In a non-SOA environment, I would have a Securities table...

Hmm, good question.

glad we could help.

Jeff:

My understanding is that only objects actually IN the ResourcesDB can directly access other ResourcesDB objects. And all of the 'sys.*' objects are actually in the ResourcesDB,...

Sure, just replace this:

WHILE(@Cnt > 0)

BEGIN

SELECT @ProductOptionID = ProductID FROM @TableVar WHERE ID = (@Cnt);

DELETE FROM Production.utbProductUtbProductOption

WHERE ProductID = @ProductID AND ProductOptionID = @ProductOptionID

SET @Cnt = @Cnt-1

END

with this:

DELETE FROM Production.utbProductUtbProductOption

...

Lacking an XLATE() type built-in function in T-SQL, CLR is probably the way to go.

It's not clear to me what the problem is that you are alluding to. Tables with ID fields as PK's refer to each other all the time without any...

By the way, it does not appear that you need to be using that WHILE loop, and it will perform terribly compared to a set-based approach.

AFCC Inc. Com (6/3/2008)

---

My problem is that no matter how many nodes I pass in I always get 2 for the length.

SELECT @Cnt = LEN(ProductID) FROM [SplitList](@List)

@Cnt always = 2...

Is [Table] really a view?

Okaaaaaaayyyyy....

Is this a general CPU problem or a specific one?