ok, i have to move on from this and get working on the actuall app - but i WILL keep learning SQL - i promise.

A question however:

using SQL Server managment...

ok, i after much reading i came up with another solution

is this approach better?

I moved the SP into a table-valued function that returns a table containing the course progress

I then...

Matt,

i changed my queries to go with your suggested "old method" and its working like a charm,

thank you very much. Have a cyber-beer on me

Hello,

the above advice worked spledidly however i now have another question

below is the query

SELECT *

FROM (SELECT ...

hi, thanks to you and the above poster for the excellent and swift replies.

I do already have the following tables in my system

users (each user is unique by username)

questions

questionOptions

questionnaires...