Did a little "googling" and found that Unix records date as the number of seconds since 1970-01-01 00:00:00 UTC (GMT). With that, 1220140800 is Saturday, 2008-08-31 00:00:00 UTC.

Is 1220140801 October 1, 2008?

richard (10/30/2008)

---

OK, have done some further tests:

1. created new table:

CREATE TABLE TEST

REF INT NOT NULL,

DATE DATETIME NOT NULL

2. Inserted 4 rows - made sure that the REF was sequential...

eric (10/30/2008)

---

Hi Forum,

I need to create a Stored Procedure which will receive the name of a table as parameter and perform numerous operations (probably using a 'Curse her' :crazy:) on...

Gun control, being able to hit what you are aiming at. In the United States, we are guaranteed the Right to Keep and Bear...

John, aren't you glad I pointed you to Jeff's article?

Jeff, I guess I should add that one to my sig block as well.

Because it is the last table.

Would help to see the complete query.

Frances L (10/29/2008)

---

I have table in MS ACCESS:

has hire_date, rehired_Date, Termination_Date.

I want to

select rehired_date as hire_date when terminate_date

How to write this statement ?

ig:

hired_date as 10/1/07

termination...

Tommy, don't think that is what (MERGE in SQL 2008) the OP is looking for. Original post indicated 4 tables with 100 records each, into one table with 400...

Sounds like a Running Totals type query. Please read this article written by Jeff Moden, it should help you.

http://www.sqlservercentral.com/articles/Advanced+Querying/61716/

Just a little more info. Are all four tables completely identical, or are there only 4 fields that are identical? If there are other fields that aren't, do...

Write a query using a CROSS JOIN or two against you biggest tables. That may slow your query down enough.

David Reed (10/29/2008)

---

Humorous? Maybe. Looking at this from the perspective of the men and women in uniform who actually guard the wall for us 24/7/365, not so much.

:sick:

Laugh if ye...

So, to paraphrase your spreadseet, Fiscal Year 2009 starts the first day after the last Saturday in February (2/24/2008) and ends the on the last Saturday of February in the...