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

Re: checking against issue numbers

From	"Andrew Morton" <akm@in-press.co.uk.invalid>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: checking against issue numbers
Date	2011-11-11 11:02 +0000
Message-ID	<9i4e1oFcn5U1@mid.individual.net> (permalink)
References	<5cd2d06a-9e43-4434-82e7-3077404e96cc@k5g2000pre.googlegroups.com>

Show all headers | 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