What are you trying to show? Based on your post I don't see any reason for a running total.

Edit: Nevermind, should have kept reading before posting.

Or convince your powers that be to change what they are asking you accomplish.

abitguru (3/25/2013)

---

Lynn Pettis (3/25/2013)

---

abitguru (3/25/2013)

---

Thanks so much guys, sorry if I dont put real code, I dont understand it..

I will try Lynn solution, and see if it "fits".

I will post...

abitguru (3/25/2013)

---

Thanks so much guys, sorry if I dont put real code, I dont understand it..

I will try Lynn solution, and see if it "fits".

I will post real code of...

Here is a start: sys.database_permissions

GilaMonster (3/25/2013)

---

abitguru (3/25/2013)

---

2 - A user can generate a internal requirement, so when I store this on the db, I take next number to save the internal requirement with this...

abitguru (3/25/2013)

---

This is all process,

to numerate I select by parameter to use by fields cereq and use the field proximo to get next number,

insert using number get from previuos query...

Well, look closely at the descriptions. You will see database_role, windows_user, sql_user. The ones you don't see under users are probably the database_roles.

Guess where you will find those in...

The FOR XML is tokenizing the greater than sign (>). Would need to see all the code to actually help you.

KoldCoffee (3/25/2013)

---

Thanks for clarification of terms. Logins = Server, Users = Database. Object Explorer complicates the issue itself, but referring to 'Logins' under Database->Security->Logins....which you say is USERS...

KoldCoffee (3/25/2013)

---

Thanks for clarification of terms. Logins = Server, Users = Database. Object Explorer complicates the issue itself, but referring to 'Logins' under Database->Security->Logins....which you say is USERS...

KoldCoffee (3/25/2013)

---

Thanks for clarification of terms. Logins = Server, Users = Database. Object Explorer complicates the issue itself, but referring to 'Logins' under Database->Security->Logins....which you say is USERS...

For the list of Logins that matches Databases > Security > Logins, try the following:

select * from sys.server_principals where type in ('U','G','S');

KoldCoffee (3/25/2013)

---

When I run that and do a visual comparison with results of database->security-> Logins, it does not match.

I need to be able to make a...