Keebler;394415 wrote:INSERT INTO Bellevue_Pending
SELECT *
FROM Bellevue_Doc
WHERE Destroy_Date<"06/16/10";

Does this look right? I want to take any entry dated before 06/16/10 and insert it into the pending table.

Also, how can I automatically set 06/16/10 to be today's date?

I'm having total brain failure today and Google hasn't been much help.

Thanks.

Keebler;394433 wrote:What I'm trying to do is pull all records with a date before the current date for Destroy_Date and put them into a Pending Table. I don't need to update records, just run the query to move entries from one table to another based on the Destroy_Date being before the actual date.

Also, how can I automatically set 06/16/10 to be today's date?

Thunder70;394453 wrote:nerds...

justincredible;394450 wrote:Or you could do something like:

INSERT INTO Bellevue_Pending (col, col, col, col, Destroy_Date)
SELECT col, col, col, col, CURDATE()
FROM Bellevue_Doc
WHERE Destroy_Date<"06/16/10";

DECLARE

CURSOR get_doc_recs
IS
SELECT * FROM Bellevue_Doc
WHERE Destroy_Date < TRUNC(SYSDATE);

BEGIN

FOR c_doc_recs IN get_doc_recs
LOOP
c_doc_recs.Destroy_Date := SYSDATE; -- Sets Destroy_Date to "right now"

INSERT INTO Bellevue_Pending
VALUES c_doc_recs;
END LOOP;

END;

Keebler;394478 wrote:I guess I'm making this more complicated than it sounds.

WHERE Destory_Date < CURRENTDATE is what I want. So I want all records out of Bellevue_Doc where the date in Destroy_date is before the current date and insert those records where the destroy_date is before the current date into Bellevue_Pending. Nothing needs updated with the current date.

Keebler;394810 wrote:I finally got it to work. My SQL was correct. There was just some gay Windows 7/Office 2007 Content Adviser that was blocking me from Running my query. Once I took that off it worked.

Thanks for all the help Justin and PITman

justincredible;394821 wrote:A Microsoft product gay? Who knew?