I have managed to get the output that I want and below is my code. It may look pretty messy but well, that's the way it is :)

Thanks sknake for your help!

SELECT student_name,...

hmm, let me get this right. First you are creating a temp table to store the data to replicate the problem. For my case, I do not need to create a temp table right?

Next, your insert statements...

sknake: i am restricting the number of hurdles to 5 at the client level so i'm sure it wouldn't be much of a problem. if i am insisting on my design, how should i make it work? I can't use cross tabs...

Hi, I am doing a student progression system where the application is able to keep track of student marks. I have a problem currently and I've been spending nights on this.

Let me briefly explain....

Hi,

I am trying to do a search function on my GridView. However when I tried using ( LIKE '%' + @ea_name2 + '%' ), it would only return me values if "ea_name2" is not null. I would like that SQL...

Alright, I've created a new thread in the ASP.NET section. Click here (http://www.daniweb.com/forums/thread165610.html) to go to that thread.

Hi,

Here's a simple scenario:

Users are required to fill up a certain type of questionnaire which has a deadline that is set by an administrator. Take for example the deadline is 31st January...

Hi,

I am currently trying to develop my system that would send an email reminder to a user when the deadline for a particular matter is approaching. I did a bit of a research online and I realised...

I have managed to find a solution to this problem

SELECT DATEPART(year, q.attempted_date) AS Year, DATENAME(MM, q.attempted_date) AS Month,
AVG(CASE WHEN w.category_id...

Hi,

I've tried removing the question.category_id from the GROUP BY clause but AVG() doesn't seem to work. It works perfectly fine for SUM() but not AVG().

Below is how the output looks without...

Hi all,

I have managed to get my average using cross tabs but only if I have grouped it by their categories. If I remove the GROUP BY clause, the cross tabbing doesn't seem to work. Can anyone...