Having now executed my due diligence, creating a 1-col view and simple mod's to Celko's example have given what I needed, if not all I wanted. I think I can play w/it when I'm able and find a way to have it produce only the "omissions". What it does now is show me the "inclusions", so I have to fill in the gaps, as it were.
Anybody interested in seeing the details? Lemme' know, Steve in Memphis ----- Original Message ----- From: "J. Stephen Wills" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Cc: "Hari Kusumba" <[EMAIL PROTECTED]>; "Bala Pamarti" <[EMAIL PROTECTED]>; "Minoo Shinde" <[EMAIL PROTECTED]> Sent: Wednesday, March 05, 2003 12:59 PM Subject: [rStreet] AUTONUM||Equivalent in a View (and about) Finding Missing/Omitted Numbers in a Sequence of Numbers ... > Okay, I don't own a theater, to borrow fm Celko's examples in"SQL for Smarties", but I certainly have a similar need to examine a series of numbers, a sequence, or actually a set of sequences, as there can be 1:N numbers missing - these can be "missing" at any point in the recordset and may or may not be contiguous. > > To use today's example. I have a sample of 340 records, originally numbered (ID'd) 1:340. Now, due to processing (a 3rd party system that has its own way of doing things) some of the records will have their ID changed. F/example, these 340 records now have MAX(ID)=348. So, by "eyeballing" in the Data Browser, I found that ID's 19,20,58,199,209,298,300,326 [COUNT(listmembers)=8] have been changed to 341:348. (The numbers are only relevant to illustrate the example, which, is "real world", as of 11:42am CST, today.) > > My counts all "balance", so I have all the records I'm s'posed to have, but I'd like to execute a query against the ID's I actually receive post-processing versus what I had pre-processing. I'd hoped that Celko's examples would be close - and they may be, but I haven't done complete due diligence yet - but I thought I'd ask y'all about this too. > > In short, I'm trying to describe via SQL the discontinuities in a data-set. That is, have the query results show me, using today's example the 8 ID's that are "missing"||"skipped" fm the set of ID's. > > Any ideas? If not, any interest in finding out what I do, if I meet success? > > Thanks & Later, > Steve in Memphis > > > [Non-text portions of this message have been removed] > > > ------------------------ Yahoo! Groups Sponsor ---------------------~--> > Get 128 Bit SSL Encryption! > http://us.click.yahoo.com/LIgTpC/vN2EAA/xGHJAA/PhFolB/TM > ---------------------------------------------------------------------~-> > > The rStreet List is dedicated to database application development, > R:BASE, PHP, Visual Basic etc... > > All products mentioned on this list are the trademarks of their resepective companies. > > Post: [EMAIL PROTECTED] > Unsubscribe: [EMAIL PROTECTED] > http://groups.yahoo.com/group/rStreet/ > > Scott Salisbury - [EMAIL PROTECTED] > > Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/ > >
