Groups > comp.databases.ms-sqlserver > #796

Re: checking against issue numbers

Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!news.musoftware.de!wum.musoftware.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From	"Andrew Morton" <akm@in-press.co.uk.invalid>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: checking against issue numbers
Date	Fri, 11 Nov 2011 11:02:13 -0000
Lines	32
Message-ID	<9i4e1oFcn5U1@mid.individual.net> (permalink)
References	<5cd2d06a-9e43-4434-82e7-3077404e96cc@k5g2000pre.googlegroups.com>
X-Trace	individual.net KbgtjTa0RJF0pjIwgzK1Xwb7em4Q8P2vvqu5RVan0qhVsfNYUp
Cancel-Lock	sha1:99F80jmgrF+/OyoLQQWvH1k5EFY=
X-Priority	3
X-MSMail-Priority	Normal
X-Newsreader	Microsoft Outlook Express 6.00.3790.4657
X-MimeOLE	Produced By Microsoft MimeOLE V6.00.3790.4913
X-RFC2646	Format=Flowed; Original
Xref	x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:796

Show key headers only | View raw

Maybe this'll give you an idea:

declare @LastIssue int;
select @LastIssue = 9;

select n from
(select 1 as n
union select 2
union select 3
union select 4
union select 5
union select 6
union select 7
union select 8
union select 9
union select 10
union select 11
union select 12) as t
where n < @LastIssue
except
(select 2 as n
union select 3
union select 5
union select 7)

-- outputs 1 4 6 8

HTH,

Andrew

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

checking against issue numbers John Kim <jinumarketing@gmail.com> - 2011-11-10 00:45 -0800
  Re: checking against issue numbers "Andrew Morton" <akm@in-press.co.uk.invalid> - 2011-11-11 11:02 +0000
    Re: checking against issue numbers "Andrew Morton" <akm@in-press.co.uk.invalid> - 2011-11-11 11:52 +0000
    Re: checking against issue numbers John Kim <jinumarketing@gmail.com> - 2011-11-11 05:20 -0800

csiph-web