The answer query post isn't the same as the first posted question query.  The 2nd post has an 'ELSE' statement which translates the results to -1.  If you run the...

2 comments:

- identity field makes a good primary key because it makes indexes and joins smaller but, if it is the primary key, there should be another unique key to...

I think all the database issues have been covered so i'm just bringing up requirement ideas.

I would change the owner field to a larger size so it can acommodate the...