Select src.*

From dbo.Student src

 Inner Join dbo.StudentCourse sc

  On src.StudentID = sc.StudentID

 Left Join dbo.StudentCourse sc2

  On  src.StudentID = sc2.StudentID

  And sc2.CourseID in (2, 3)

I'm struggling with the bit where Scott Mills is in the Favourite_Show table, but anyway...

Try copying D2.T2 into D1, then doing a...

If you are contructing the code then you can add the ID number in yourself, e.g.

'SELECT SubjectDisplay FROM PM_RuleSubject WHERE RuleSubjectId = 1'

becomes

'SELECT 4, SubjectDisplay FROM PM_RuleSubject WHERE RuleSubjectId =...

I've done this plenty of times with .NET, but unfortunately at home so I don't have the code with me right now.  Have you tried putting a non-Null value in...

Do you mean you want to make a copy of a SQL table in your Access database?  Or perhaps you want to add the SQL table into Access as a...

Are any other processes running on the server that you don't know about?  For example, I once had a problem when there was conflict between IT backups and jobs running...

I think what you're saying is that you've written code that effectively negates the need for spexecute and params.  The danger then is that your code has missed something that...

To answer your first question: yes, use a table to store the value.  But, that contradicts what you ask in the second question, so sorry about that

Yep, that's what I was going to do, just not got round to it yet 

Nice article

The solution I use is to populate a table overnight with the full syscomments text for each object, across multiple databases.  This table...

"Site owned by Red Gate Software" - it's that easy, surely?

"Site supported" does bring about an image of cheerleaders and raucous fans!

Well said, Jon - saved me the trouble.

I did a bit of dabbling and it seems easy enough to get one of the Globals into a SQL function.  From there,...

Can you implement a standard naming convention then?  If so, you could create a table that maps the folder name (or part of) to the customer code required in the...

Nice article

It was very clear.  To me, at any rate

I think one forum per company/package is too much.  I like the idea of one...