all you really need is this:

Insert into dbo.SITE_PUBLICATION_CHANGE_HISTORY

...

And, I actually have to agree with Sergiy, to a point. There is also additional information that may change what you are doing. Is this an amoritization schedule,...

Without seeing the code for the trigger, hard to say, but, why not just code the insert statement in the trigger with NULL where you need to put nulls instead...

Haven't gone to bed yet, just finished dinner. It is only 7:42 PM where I live in the USA.

Jeff Moden (11/20/2008)

---

Adrian Nichols (11/20/2008)

---

I wouldn't say that makes you elitist in...

That will probably help. What I am looking for is a pattern, if one exists.

Jeff Moden (11/20/2008)

---

Lynn Pettis (11/20/2008)

---

Kicking_Fish0713 (11/19/2008)

---

Thanks for a quick response.I don't use hardcoded values that's why I'm using a cursor.Can you pls send me a sample script using a cursor?

Thanks...

Sergiy, I don't think he is looking for the last day of each month. To be honest, I am not sure if he knows the right question to ask....

Here is code that meets your requirements in your original post. I leave it to you to figure out how to add the date criteria to the query.

create table...

First, why are you using a cursor to begin with?

Second, you haven't provided enough information for use to even help you. Please read the article below in my signature...

This is what you should have provided us:

create table dbo.Orders (

OrderID int,

UserName varchar(25),

OrderDate datetime

);

create table dbo.Tasks (

...

Let's ask a different question first. Are the dates you are using supposed to be the last day of every month?

What do you expect? You posted your problem in a SQL Server 2005 forum, you are going...

Which table is getting locked and scanned?

If you notice, the column you are commenting out is from the second table of your join.

Curious, and others may have a similiar problem, but what was done to resolve the problem?