jcrawf02 (2/17/2009)

---

RBarryYoung, am I missing something here? the function name is LatLonDistance(), but the tests use calculateDistance()?

Is there a missing piece to this, or is it just a...

Thanks for the feedback, Tim.

Then how do you walk? ...

How would the "variable file name" be automatically determined/provided?

Here's script that I use to create test tables of any size:

ALTER proc [dbo].[TestTable_Create](@name as varchar(55), @reccount as int) as

--sproc to make as TestTableXX

BEGIN TRY

exec('Drop table TestTable'+@name)

END TRY

BEGIN CATCH

Print '...

The time will vary hugely depending on your configuration and the average data length of your rows, but I would figure on a couple of hours at a minimum. ...

This is actually a SSIS expression. You would probably have better luck asking in that forum.

I agree with the others that joining to INSERTED is important. I just wanted to add also, that this:

nwinningham (2/16/2009)

---

UPDATE candidate

...

Jeff Moden (2/14/2009)

---

Ok... now I trust it... just gotta remember to NOT let the fact that GroupNums aren't unique across items but the combination of Item and GroupNum works as...

I have already posted 2 examples in this thread. If they are not what you need, then you will have to be more specific.

I can think of a few possibilities, but this is hard to comment on at such an abstract level. Could you post the query for us? That would...

Glad I could help.

Cool tip, Noel! I stand corrected... 🙂

AFAIK, changing the schema name of an object cannot be done: you would have to DROP the object and then recreate it with the new schema name.

And as Gus...

.. and as Bruce says, post the trigger code if you want an answer to your specific problem.