Actually, I think I got this thing working now, using Jeff's advised code with a bit of ingenuity. I think this post is done, unless I develop an extended problem...

Im finding it difficult to implement that case structure into a select statement. Im trying

DECLARE @ColumnMatches INT

SELECT a.Username, a.Gender, a.Photograph, a.Description_text, a.Voice_Message, @ColumnMatches

AS "Matches",

CASE "Matches"

WHEN a.Age_Range =...

Here's an extended problem (which I was unable to solve and not sure if it can be at all).

So Jeff's code works, but another field that I have in the...

Thanks for the reply Jeff, is there any way to do it using simple Count functions?

Because I'll have to write a function/stored procedure to use the CASEs won't I?

Awesome, that works as far as I can tell, thank you very much Jeff!

Okay, no one's replying. But I'm almost there, just did it using a FULL OUTER JOIN (I think its working okay, but I don't have much dummy data in my...

I want him to have SELECT (only) from the view and modify base tables, but I too am now pretty sure he needs permissions such as UPDATE/INSERT/DELETE to be able...

Is that the only way though? what about if BOB only had a SELECT permission on the view?

And again whats the syntax to update the base table, does it just...

yeah thats the exact code I have so you didnt really help there. But how do you mean yours worked, like when you login as the newuser what happens, do...

Hmm, I might need to check the specification, but I don't think this is about users, I'm pretty sure there is just one user, the administrator and technically he has...

That seems rather complex, I think there should be an easier way (if not I guess I will have to try your suggestion). Plus I don't want to rollback transaction,...