WayneS (6/13/2012)

---

I'm assuming that your table has columns like:

cs1_start, cs1_end, cs2_start, cs2_end, etc.

Is there any particular reason that you didn't create a properly normalized, separate table for this data?

userId

courseId

start

end

(FK link...

you mean the PRINT will only show...

Gaz:

Yes, i am using the PRINT command to see what i get.

If the output query is fine i will change it to EXECUTE.

Thanks for the reply.

I want the value to be seen, not the literals to be concatenated.

How do i do it?

I've put a more detailed code now.