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

checking against issue numbers

From	John Kim <jinumarketing@gmail.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	checking against issue numbers
Date	2011-11-10 00:45 -0800
Organization	http://groups.google.com
Message-ID	<5cd2d06a-9e43-4434-82e7-3077404e96cc@k5g2000pre.googlegroups.com> (permalink)

Show all headers | View raw

I run online based study guides program.  I email out new issues every
week, mon / wed / friday.

I have new sign ups every week.  and each of these sign ups, I need to
follow up on the issues subscribers haven't attempted.

In one table, I have last issue numbers sent out so far.  So Week #1 -
issue 12, Week #2, issue 9, Week #3, issue 6, and so on.

I download each subscribers log in and study guide attempt record thru
online MySQL table, and import to MS SQL.

I need to check these records against above mentioned table.  So for
example, if Week #1 signed up student has attempted issue 1, 2, 3, 4,
7, and 8, but didn't do all of issues sent up to issue 12, I need to
come up with SQL code that will generate issue 5, 6, 9, 10, 11, and
12.. which are issues this student has not attempted as of yet.

Can anyone tell me / help me with SQL code that will check these
attempted issue number records against issues sent out thus far table
record and come up with issues not attempted as of yet??

... let's say, the table says Week #2 is sent to up to issue #9.  But
downloaded MySQL records show only issue 1, 2, 3, 5, and 8 are
attempted.. Then SQL code should check these 1, 2, 3, 5 and 8 against
Up to Issue 9 in the table.. in this case up to Issue 9, and come up
with Issue 4, 6, 7, 9.

The table only has the data of issue 9; the last issue number sent out
so far.. Another table shows records of issue numbers of all attempted
issue.

So issue 9 should be checked against issue 1, 2, 3, 5 and 8.. and come
up with 4, 6, 7, 9.

Could anyone please help me with SQL code to compare these two
table .. and come up with issues not attempted??

thanks.

Back to comp.databases.ms-sqlserver | Previous | Next — 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