JokerUK (4/23/2012)

---

OK, I can add a date into the row, and I will see how that goes.

I figured that looking at an INT when deleting would be more efficient than...

Another idea would be to use cascading deletes. You said that is slower? My guess is due to indexes.

Why have day and month as columns with a datatype of int? Can you replace those with a datetime column, which could be the same value as the parent table?...

Yes that type of delete is going to perform horribly, especially with that much data. There is no need for a loop here at all. This should be a single...

Is there a question here?

homework or interview?

huh?

How about some ddl and sample data? Then post what you have tried. The error message is pretty self explanatory. When using aggregates all non-aggregated columns must be included in...

rarara (4/23/2012)

---

ACinKC (4/20/2012)

---

Hopefully it would either have those two steps wrapped in a transaction or drop the table first,...

You are correct that I am a bit confused by what you are trying to do. We need to see ddl (create table statements), sample data (insert statements), desired output...

Yeah that would be an interview ending request for me. I have facebook and there is absolutely nothing on there that would in anyway shape of form be offensive to...

Have no fear, we don't bite. 😀 It is hard to know all the details from your description but it seems that you could use what is called a "calendar"...

If you want some real help take a look at the first link in my signature. Honestly I am surprised that over 300 points you wouldn't know to post ddl,...

To me it seems like the easiest implementation of this would be to have a delete trigger on the "List" table. Then it can simply delete the "child" table. Then...

Define before or after. You are going to need to find something to use to order by. Once you have figured that out need to investigate "islands". Jeff Moden has...