Definitely worth including. No need to be embarrassed that your code isn't perfect; we all start somewhere. We may need sample data as well (see the article in...

Jonathan Melo (10/16/2009)

---

I despise cursors myself. When I'm really, really stuck to go row by row, I use a WHILE construct with a key instead. Somewhere, in my head, there's...

Are you saying that they are going to delete single values from those columns or they are literally deleting the entire column so that it won't exist in the table...

This indicates to me that your original concept of a delete trigger was correct. You don't need an 'update' trigger which is what you'd need...

You didn't answer the question. What is the end goal? What are you using the schema2 table for? What purpose is it intended to serve? What...

The new column(s) do not need to be added to the index, they just allow you to use this method without creating a temporary table. I've given you two...

Take a look at the article in my signature on cross tabs. If you need more help writing the code, please post table definitions and sample data according to...

That's not a little change.

What is the real goal here? It seems like auditing to me. You want to track historical values in your table. There are...

Jonathan Melo (10/16/2009)

---

First, Garadin, I'd like to thank you a lot for the effort you're putting in this problem. It looks like you went through a lot of trouble to...

Excellent, thanks Tim, I'll whip something up for you in the morning. Is adding a field to the table an issue? Ordinarily, I'd do without, but it looks...

Thanks for providing what you've already tried. Take a look at the article in my signature on Running Totals. I believe this to be the perfect method for...

So I thought about it for a while, this is what I came up with. I'll state up front that I can already see half a dozen ways to...

Yes.

rahulsony111 (10/15/2009)

---

I am not inserting those 4 rows cause they are already in the Schema2.DIMCNAM

I am just leaving them as it is. I dont have to bother about future data...

There is no direct equivalent. Which way you should go is determined by what you need to do with it. Pass the date along with it from 2008...