The UK Home Automation Archive

Archive Home
Group Home
Search Archive


Advanced Search

The UKHA-ARCHIVE IS CEASING OPERATIONS 31 DEC 2024


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: OT another SQL question


  • To: <ukha_d@xxxxxxx>
  • Subject: RE: OT another SQL question
  • From: "Dr John Tankard" <john@xxxxxxx>
  • Date: Fri, 4 Oct 2002 14:08:48 +0100
  • Mailing-list: list ukha_d@xxxxxxx; contact ukha_d-owner@xxxxxxx
  • Reply-to: ukha_d@xxxxxxx

Its big 1...999999.

The only way I could think to do it was to create a table that's auto
inc, insert 1000000 records and do a not in to a select DeviceID in
Devices

John

> -----Original Message-----
> From: BUTLER, Tony, FM [mailto:roaming@xxxxxxx]
> Sent: 04 October 2002 13:56
> To: 'ukha_d@xxxxxxx'
> Subject: RE: [ukha_d] OT another SQL question
>
>
> John,
>
> What is the range of the numbers?
> Do you really want it to list all missing from 1000 to 9999?
>
> T.
>
> > -----Original Message-----
> > From: Dr John Tankard [mailto:john@xxxxxxx]
> > Sent: 04 October 2002 13:52
> > To: ukha_d@xxxxxxx > > Subject: [ukha_d] OT another SQL question
> >
> >
> > Sorry for the OT post
> >
> > Is it possible in SQL to do this :-
> >
> > I have a table:-
> >
> > Devices
> > --------
> > DeviceID
> > ..
> >
> >
> > And in the table there are some missing device numbers ie
> >
> > 1000
> > 1001
> > 1003
> > 1004
> >
> > In SQL is it possible to list missing numbers ie 1002 ?
> >
> > John
> >
> >
> >
> > ------------------------ Yahoo! Groups Sponsor
> > ---------------------~-->
> > Home Selling? Try Us!
> > http://us.click.yahoo.com/QrPZMC/iTmEAA/MVfIAA/IBOolB/TM
> > --------------------------------------------------------------
> > -------~->
> >
> > http://www.automatedhome.co.uk
> > Post message: ukha_d@xxxxxxx
> > Subscribe:  ukha_d-subscribe@xxxxxxx
> > Unsubscribe:  ukha_d-unsubscribe@xxxxxxx
> > List owner:  ukha_d-owner@xxxxxxx > >
> > List of UKHA Groups here -
> > http://groups.yahoo.com/group/UKHA_Grouplists/
> >
> > Your use of Yahoo! Groups is subject to
> > http://docs.yahoo.com/info/terms/
> >
> >
>
>
> **************************************************************
> *********
>       Visit our Internet site at http://www.rbsmarkets.com
>
> This e-mail is intended only for the addressee named above.
> As this e-mail may contain confidential or privileged
> information, if you are not the named addressee, you are not
> authorised to retain, read, copy or disseminate this message
> or any part of it. The Royal Bank of Scotland is registered
> in Scotland No 90312 Registered Office: 36 St Andrew Square,
> Edinburgh EH2 2YB
> Regulated by the Financial Services Authority
> **************************************************************
> *********
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~--> Sell a Home for Top $
http://us.click.yahoo.com/RrPZMC/jTmEAA/MVfIAA/IBOolB/TM
---------------------------------------------------------------------~->

http://www.automatedhome.co.uk
Post message: ukha_d@xxxxxxx
Subscribe:  ukha_d-subscribe@xxxxxxx
Unsubscribe:  ukha_d-unsubscribe@xxxxxxx
List owner:  ukha_d-owner@xxxxxxx
List of UKHA Groups here -
http://groups.yahoo.com/group/UKHA_Grouplists/

Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/


Yahoo! Groups Sponsor
ADVERTISEMENT

http://www.automatedhome.co.uk
Post message: ukha_d@xxxxxxx
Subscribe:  ukha_d-subscribe@xxxxxxx
Unsubscribe:  ukha_d-unsubscribe@xxxxxxx
List owner:  ukha_d-owner@xxxxxxx
List of UKHA Groups here - http://groups.yahoo.com/group/UKHA_Grouplists/


Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Home | Main Index | Thread Index

Comments to the Webmaster are always welcomed, please use this contact form . Note that as this site is a mailing list archive, the Webmaster has no control over the contents of the messages. Comments about message content should be directed to the relevant mailing list.