Why bother with the GROUP BY and HAVING?  A simple WHERE meets your needs here.

SELECT @RetVal = MAX(RevNo) + 1
  FROM dbo.tblRevision
 WHERE DocumentID = @DocumentID

'Joins' in diagrams are actual relations - a.k.a. Foreign Key Constraints.  What you are trying is not an option in database diagrams.

Outer joins are for queries.  If you need to...

Well, this one often falls into the same religious-war category as allowing NULLs in columns; many people don't like to change their ways.  This thread should get rather heated.  Let's see...

Because you aren't performing any aggregate functions (sum(), count(), min(), ...), you don't need to use GROUP BY.  The DISTINCT will take care of it.

Otherwise, you will need to add all...

CALs - either per-seat or per-user - do not count connections.  If a user has a per-user CAL, that user may simultaneously open multiple connections to several per-server-licensed SQL Server services...

I got my paper score reports and vouchers for 71-431, 71-441, and 71-444 over the last two weeks.

I took mine at a Thomson-Prometric center.  People who took them with...

Option #2: T-SQL.  "It's greyed out when I try" sounds like you're trying this in Enterprise Manager.  Fire up Query Analyzer and:

1.  Ensure all the tables you're referencing were created...

For per-processor licensing, you license only the processors you use, not the number of processors in the box.  You can choose to license some or all of the processors in...

There is no raw performance gain from having multiple filegroups on the same physical array.

  However, you can manage backups on different schedules to shrink backup times by placing tables that...

  To log in to SQL Server as another NT-authenticated user:

  1.  Find EM, Query Analyzer, etc. shortcut icon.

  2.  Shift+right-click the icon

  3.  Select 'Run as...'

  4.  Provide user/pass/domain info

  The...

  sp_OAStop will stop the COM execution layer, which should release all open references to your library - and every other active in-proc COM call as well.  See BOL for...

http://msdn.microsoft.com/sql/

Look for 'CTP' (right side of page).

It's not something built in to the current Reporting Services.  It's still possible, though.  In order to use a multivalued parameter, you have to do some extra work, and it's...

Instead of a 'report control', Reporting Services reports may be opened using the application designed for the report type - a web browser (or web browser control) for HTML reports,...

Ask the developer to look up "ADO.NET" on MSDN. 

Normally, when a solution involves xp_cmdshell, it's time to look at the solution.  There's often...