Nice catch Sergiy! :w00t:

Based on what you provided, however, this is where I would start:

insert into dbo.table (

...

First, again, all the code is better than part of the code. In this case, however, I have a question, is this particular question based on a trigger fired...

I have to agree with Jeff. Keep the temporary tables and figure out how to get rid of the RBAR in your code. It's all the looping that...

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 (

...