Alan above walked you through XML in general, but... um... hm. A few comments (not on Alan's work, that was pretty thorough).

No. For text it's...

Carlos, so you're looking for how we usually approach creating many to many tables?

This would usually imply that you have a 1 to...

Yeah, sorry,...

TecNQ (5/8/2013)

---

What I am trying to do is report by each student ID, the number of Qualifications and Units.

But as you may have already seen, it's reporting the same COUNT()...

No worries, usually it's a case...

kevinv (5/8/2013)

---

I'm seeing a difference in a query between SQL 2005 and SQL 2008 and I'm not understanding. The below demonstrates it. On SQL 2008, the second query below will...

In case you're simply having google-fu failure, here's the link explaining the code:

http://msdn.microsoft.com/en-us/library/ms186734.aspx

MSDN article on ROW_NUMBER().

OVER is a keyword to tell it you're about to tell it your intentions, that's...

EDIT: This is a textwall, I know, sorry for that but I got on a roll. Peter, a response to you starts about 1/3 of the way down. /EDIT

L'...

alan_lynch (5/2/2013)

---

so my problem now is that I am the owner of this procedure but I cannot modify it because it is now encrypted and grayed out. is there...

CREATE PROCEDURE TestProc

WITH ENCRYPTION

AS

...

GO

Final check, what does it say when you rt-click -> Script Stored Procedure as -> Create To -> New Query Editor window?

My guess is they most likely encrypted the procedures....

There are a couple of ways that can be grayed out, but to get rid of a series of Q&A... are you the sa on the box or DBO of...

L' Eomot Inversé (5/2/2013)

---

Take care not to forget...

LOL, I know. I've actually printed it out and hung it on my cube wall.

Last thing first. 🙂

L' Eomot Inversé (5/1/2013)

---

So we can either continue to try to understand each other - which may be difficult, given the different backgrounds - or we can...