A simple crosstab will do.  You will need to use dynamic SQL if you want to handle an unknown amount of 'questions'.  Noticed I added and ID field.  When dealing...

Try this and also note the example on how to give us some data to work with.

DECLARE @myTable TABLE (somedate DATE)

INSERT INTO @myTable
VALUES...

The problem is you are using dynamic sql in your procedure and the text isn't quoted properly. 

Try this:

set @sql =N'insert into eligiblemember(Memtype, Division, MemberID,...

Just throwing in my testimony for the same guys who convinced me.

Set Based Loops - "Learn it, Use it and you'll never want to go back."

Well you need to specify a time frame if you only want the last 15 minutes.

i.e.

WHERE

Is this perhaps what you are looking for? 

SELECT
Id,
IsRegistered,
IsAccepted,
DBContent,
CASE WHEN IsRegistered = 1 AND IsAccepted = 0 THEN 1 ELSE 0 END AS Passed

FROM...

You should do some research as suggested but here are a few things to keep in mind.
1. A clustered index IS the your table and thus can only have...

I've had similar issues as well, plus extra line spacing when pasting.  Commented code is also strange.

--What's with this?

I would also like to add that the BEGIN...END isn't even necessary in this case.  It's used to group t-sql statement together.  However in your case it will either do...

Maybe it's me but trying to follow up on posts is not as intuitive as it once was.  I was eventually able to find my posts under my profile but...

I'm not sure if I'm missing one of the core requirements but if the application is already calling a SP, I'd rewrite that SP to handle the process from end to end and just do...