Select g.name

From tblGroups g

Join tblGroupMemberships gm

  On gm.groupId = g.GroupId

Where gm.UserId = 7

Or the same thing turned around

Select g.name

From tblGroupMemberships gm

Join   tblGroups g

  On   g.GroupID = gm.GroupId

Where gm.UserId =...

Chris,

Yes, my concern is trapping for errors. I would like to make the code as bulletproof (within reason) as possible. 

I'm not so concerned about a "fatal" error since as...

 "...so is the comma separated group list in the user table the best way..."

Bite your tongue!  Pretty much listen to what David said although I think you want your third...

If siteglobalcode can be null then you may have to do something like this:

Where...And Isnull(siteglobalcode,'') =

Case 

    When @p_sitecode is null then Isnull(siteglobalcode, '')

    Else @p_sitecode

End

Of course the second Isnull parameter...

Edited to correct syntax:

Where...And siteglobalcode =

Case 

    When @p_sitecode is null then siteglobalcode 

    Else @p_sitecode

End

Steve,

Thanks for the suggestion.  I'm also consdering:

Declare @pk int,

           @error int

Select top 1 @pk = MyPrimaryKey

From MyTable

Where ...

Select @error = @@error

If @error <> 0

   Begin

        Raiserror...

Many people develop the false idea that Sql Server or any relational database will return rows in the order they were inserted.  Although this may...

If your looking for another way to teminate the while loop you can use BREAK.

example:

While 1 = 1

   ... your code

   if <condition to terminate loop>

        BREAK

  ...

You can return values by using an "output" paramenter or by capturing the value returned by the "Return" statement.

Its well documented in BOL.

Everything you need to know about SQL Dates:

http://www.sql-server-performance.com/fk_datetime.asp

with credit to Frank Kalis

He's a link to info on the snapshot isolation level in sql 2005.

http://msdn.microsoft.com/sql/2005/2005articles/default.aspx?pull=/library/en-us/dnsql90/html/sql2k5snapshotisol.asp

I don't believe you can do that in Sql 2000.  However I think Sql Server 2005 will have a method to accomplish what you are asking.  For now you need...

I guess I just don't understand because I don't see how the statement above could ever return any rows since grouping by OrderNumber, EmailAddress would never have a count...

For a full and complete excellent explanation of all of the above and more check out Frank's article noted above:

http://www.sql-server-performance.com/fk_datetime.asp

Very nice piece of work!  Thanks Frank.

What John posted should work.  Just sort on the date column in the table. You can still select and convert that column for display in any format of your choice.