Bruce W Cassidy (2/3/2009)

---

[font="Verdana"]I'm still struggling with reading most of the questions. ...

Yep. Figured that out when I...

G² (2/3/2009)

---

I used to work at an insurance company and we had a similar requirement. We used two columns, an effective date and an end date. So when...

Roy, Your link doesn't work.

I think the term you are looking for is EffectiveDate. In the case of your example this should also include the time as well, so perhaps EffectiveDateTime would be...

I did get to hear him do this one. And, yes, I could still hear him doing it as I read it also.

Here is a quick question before i try answering your question. Is the most recent record in the HOUSE_HISTORY table considered current where as the other records are historical...

Kit G (2/3/2009)

---

Not sure if this is the one you're...

You know, Carryball just doesn't have the same "kick" as Football. Of course we have to add the American to it so that the rest of world knows we...

How many rows in the table?

Anybody have Goerge Carlin's description of football handy? I think that pretty much tells it all quite well.

NotManyPoints (2/3/2009)

---

Lynn, yes possibly I was a little harsh, but if it does not kill us it makes us stronger blah, blah…..

To know it was not a concern you must...

Sql Student (2/3/2009)

---

Thanks,

But there are no topics for incremental backup in Books online. I need to learn how to setup incremental bakps that runs every 4 hours and how can...

santhosh (2/3/2009)

---

If our database is in simple recovery mode. Is there any chance to overwrite the uncommitted data by any other user?

If this happened how to rollback the data from...

Should have seen this from the initial post, this is PeopleSoft. How was/is this query generated and supported? Is it built and maintained using the PeopleSoft tools? ...