Use two statements: 1>SSELECT FILE BY @ID 2>SELECT FILE SAMPLE 2 Or
1>SELECT FILE SAMPLE 2 2>SSELECT FILE BY @ID -----Original Message----- From: Bob Woodward [mailto:[EMAIL PROTECTED] Sent: Thursday, May 25, 2006 4:11 PM To: [email protected] Subject: RE: [U2] OK...Is there a way....UV Have you tried: SORT FILE SAMPLE 2 BobW -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: Thursday, May 25, 2006 12:16 PM To: [email protected] Subject: [U2] OK...Is there a way....UV I want to sort a file by @ID and only take the first two items... SELECT FILE BY @ID SAMPLE 2 doesn't work, it first takes the sample of 2, then sorts it. SELECT FILE BY @ID SELECT FILE SAMPLE 2 works, but takes two lines How can I phrase my SELECT so it will sort first, then sample later, instead of sample first, sort later? I'm running UV. George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - Delivering the best in health care information and education worldwide. http://www.slackinc.com ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
