Thanks

Doh! Thanks

Tried running the stored procedure

EXEC dbo.spShowJobRunSnapshot('9/16/2012', '9/16/2012 23:59')

But I get the follow Error Message:

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near '9/16/2012'.

Not sure how it is a vague question?

Which Course Codes?

Yes which ones there are loads?!

But when I report against these tables I am not using free-hand sql, I am using BI Products like Business Objects etc..which won't let me create Common table expressions when...

The reason why it is not like the table how you did it, is because if you join to another table then the report would show many lines.

Hi, what's OP mean?

So did you create a similar function

Hi,

Thanks for your advice so far and what you have shown me.

The table you created QuestionFieldsNormalized was what the table originally looked like that when pulling the data from the...

Hi, Basically these are custom fields that the user can add on the application side, they can add the same custom fields multiple times in any order, so the table...

Hi, So what would your table design look like compared to the that i have? Thanks

Any one?

Thanks, what does the operator % actually do though? Never seen it used in sql, well except as a Wildcard