Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

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

Re: checking against issue numbers

Show all headers | View raw

John Kim wrote:
> 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.
I don't know how you expect us to be able to help without providing us table 
structures (field names and datatypes - you only need to show us the ones 
that are relevant to your questions) and sample data in tabular format, 
followed by desired results from that sample data, also in tabular format. 

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 01:27 -0800
  Re: checking against issue numbers "Bob Barrows" <reb01501@NOSPAMyahoo.com> - 2011-11-10 06:29 -0500
    Re: checking against issue numbers John Kim <jinumarketing@gmail.com> - 2011-11-10 05:48 -0800

csiph-web