i have two tables.

one table - tbl_attempted issue has number field with the following
values.


number field record values - 1, 3, 4, 5


the other table - tbl_issues_out has another number field with the
following value.


number field record value - 7


IS THERE A WAY TO CHECK THESE TWO TABLES and come up with values,


2, 6


??


the other table with value 7 is the issues sent out so far, and the
first table is attempted issue so far.


since issue 1, 3, 4, 5 and attempted, and up to issue 7 are sent
out..


SQL code should compare 7 against 1, 3, 4, 5 and come up with 2, 6.


CAN ANY BODY HELP ME WITH SQL CODE TO DO THIS??

John Kim wrote:
COULD YOU NOT MAKE ANY PROGRESS BY LOOKING AT MY PREVIOUS REPLY?

--
Andrew

John Kim (jinumarketing (AT) gmail (DOT) com) writes:
You need a table with numbers, that is a table that has all numbers
from 1 and up. Read more here:
http://www.sommarskog.se/arrays-in-sql-2005.html#tblnum
You should only to read down to the header "An Inline Function".


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx