I was...

Thanks for the mapping, and well done on anticipating it =)

This is more or less what your trigger should look like. Keep in mind that triggers like this should...

Looking into it.

First few questions:

Is the ScheduleID *changing* on an update to ptSchedule?

What is the primary key on ptSchedule?

Whatever, Hax Corbett.

Whoa... we tied... and it still put yours first. Hax.

Variables in a trigger are something that should be avoided as much as possible. Your trigger will only work for 1 row. Triggers are fired once per operation,...

Why would you need to display 300,000 rows in a crystal report? Who is going to go through that much data? This is starting to seem like a...

Seems to me that most of that time is just the client trying to display that much data. Why would you need to return 300,000 rows of data to...

LOL, that's awesome. Geek Humor rocks. :hehe:

Hmmm. in that case SP will be fired only for first row. if firing an sp is absolutely required for each inserted row, cursor will be needed. Any alternative to...

You're going to have to be a lot more specific on your setup... and your reasons for wanting to do this. Do all the tables hold the same data?...

This thread is a continuation of : http://www.sqlservercentral.com/Forums/Topic616449-338-1.aspx

Sorry Akzsurtep, I missed your last reply.

So, you have your table of Start and End Dates. I don't understand why you've turned...

Depending on what you're going to do with that column, you could do it in many ways.

Here are a couple:

Trigger on the table with criteria on when to restart the...

hefterr (12/22/2008)

I a a newbie so please so I appologize if this is an obvious question.

How does one define the length or scope that a temp table (#mytemp) will exist....

That makes a bit more sense. Just use something like this instead of an overly complicated case statement:

WHERE

...