[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] sql delete from table where 1 = 1
- Subject: [sqr-users] sql delete from table where 1 = 1
- From: prashanth reddy <bpreddy78@yahoo.com>
- Date: Mon, 23 Jan 2006 08:31:28 -0800 (PST)
- Delivery-date: Mon, 23 Jan 2006 11:33:52 -0500
- Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding;b=CundtY3dRxHf3gniy+TeabnwFR7FIKrTlvp8/dDirJD5tAVeEJChfHDgNnRey9no6kO+Bpn7WVChWBGSwRcxxZ6BN0mUhv11W+v1++FLepp9BbfneT/q2P2otMUGHj5lbdM/QDgPXy5VUwhRFpJoXRAWdAbB/ApZyXmTgCTs7lU=;
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
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
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users