ColdCoffee, that helps very much. Thanks for taking the time to write that!

Thanks, John. The reason for so many INSERT statements is that I scripted the table using SSMS, so it, by default, prints an insert for each row to be added...

ColdCoffee,

Yes, it works. I must have been doing something a little different. Anyway, the one piece I think it's missing is a line that has Joe, ST, CoveredByBase, then all...

ColdCoffee,

Thanks for the response. Unfortunately, the query you wrote doesn't return any rows. I wonder if there's something going on with the HAVING clause.

Actually, I may have figured it out.

I think what had happened is that I originally created a login Domain\Sales, then mapped a user with the same name to 'Reporting.' Then,...

Are you sure? I can click on...

Ok, here's what I did:

1) I disassociated "Domain\Sales" from the "Sales" database role (that way I could test the user itself).

I tried logging in as Domain\testuser and received an error...

I created a test AD user and added it to the Domain\Sales group. Then, I started another instance of SSMS by using Run As... and specified Domain\testuser and its password....

calvo (5/10/2011)

---

First, make sure your instance is in Mixed Authentication mode.

After this is done, you can create a new login specifying a windows account (or group). Search for the windows...

Ninja's_RGR'us (5/2/2011)

---

The "simple" way is to create groups and assign permissions to those groups. Then add the users to that group to get all the permissions.

That's the easy part....

<> 'A' would only exclude the one record where Status = 'A'. I want to exclude the entire person if any of his/her records have a status = 'A'.

GSquared (3/1/2011)

---

Then you're looking at two tables. One that joins majors to programs, one that joins years to programs. This could be a Majors table that has an...

GSquared (3/1/2011)

---

You need one table with each row having a Program, a Major, and a Year. It will have one row for each year a major was included in...

GSquared,

I'm not sure you're looking at this the same way that I am. You said:

Here's part of what you posted as a sample result:

Program,Year,Major

Education,2006,Math

Education,2007,Biology

Education,2008,NULL

Education,2009,NULL

Education,2010,NULL

Why would you only have Math in...

GSquared (2/28/2011)

---

From what I can see of your table, you have essentially a full cartesian join of three tables: Program, Year, Major. That means you have a number of...