[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
RE: [sqr-users] sql delete from table where 1 = 1
- Subject: RE: [sqr-users] sql delete from table where 1 = 1
- From: "the dragon" <ceprn@hotmail.com>
- Date: Mon, 23 Jan 2006 10:37:54 -0600
- Bcc:
- Delivery-date: Mon, 23 Jan 2006 11:40:33 -0500
- In-reply-to: <20060123163128.83771.qmail@web52008.mail.yahoo.com>
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
That means everything, because 1 always = 1....
peace,
clark 'the dragon' willis
PSA: Salary <> Slavery. If you earn a salary, your employer is renting your
services for 40 hours a week, not purchasing your soul. Your time is the
only real finite asset that you have, and once used it can never be
recovered, so don't waste it by giving it away.
I work to live; I don't live to work.
"Time is the coin of your life. It is the only coin you have, and only you
can determine how it will be spent. Be careful lest you let other people
spend it for you."
Carl Sandburg
(1878 - 1967)
----Original Message Follows----
Hi,
I'm testing a sqr, I found a procedure
delete-old-data.
I'm not sure how the Where statement is identifying
the old data, Where 1 = 1.
BEGIN-PROCEDURE DELETE-OLD-DATA
!**************************************************************************
BEGIN-SQL
DELETE FROM TABLE_NAME WHERE 1 = 1
END-SQL
END-PROCEDURE
Please can someone enlight me...
Thanks
_________________________________________________________________
Don’t just search. Find. Check out the new MSN Search!
http://search.msn.click-url.com/go/onm00200636ave/direct/01/
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users