Re: Can a SQL login have more than one user - Database Discussion Boards

Paul Conrad16-Jul-12 10:55

16-Jul-12 10:55

It doesn't work like that around here. We don't just give out code. You should really try working on your own code and when you run into any problems with it, then ask.

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

Can a SQL login have more than one user

yousefshokati14-Jul-12 19:53

yousefshokati

14-Jul-12 19:53

Hello .
I know that a SQL login is used to log into the server and SQL user is used to log to database but i want to know that is their a 1 to 1 correspondence between a SQL Login and SQL user or a login can have more than one SQL user that can be mapped to it.
Thanks

Re: Can a SQL login have more than one user

Mycroft Holmes14-Jul-12 20:27

Mycroft Holmes

14-Jul-12 20:27

yousefshokati wrote:
user that can be mapped to it.

How are you mapping a user to a login? As a SQL login consists of a user name and a password how are going to know if a user has not shared that information.

We use integrated security for the developers, applications has their own sql identities and pass in the workstation id and no other connections are allowed!

Never underestimate the power of human stupidity
RAH

Re: Can a SQL login have more than one user

yousefshokati14-Jul-12 20:50

yousefshokati

14-Jul-12 20:50

I am asking only that
A SQL User (database -level security) must map to a login . It is very obvious .Now I am only asking you that can a login have more that one database-level user ?
We know that a Login and a user are related with each other by SID Ok? Now i want to know that is it possible for a login , that can have nmore than one user ?

Re: Can a SQL login have more than one user

Mycroft Holmes14-Jul-12 22:28

Mycroft Holmes

14-Jul-12 22:28

Ah, more context...

Yes a user can have many connections, an example would be using SSMS each query window creates it's own connection using your credentials. If, in SSMS, you look at the activity monitor you will find multiple SID per login.

You terminology is difficult, what do you mean by a User. A database is only interested in a connection, each connection has credentials. A set of credentials (presumably your User) may login multiple times.

Never underestimate the power of human stupidity
RAH

Re: Can a SQL login have more than one user

ManishaSCode15-Jul-12 3:34

ManishaSCode

15-Jul-12 3:34

Hi,

Principals are entities that can request SQL Server resources.
SQL Server Login is SQL Server-level principal
A database user is a principal at the database level.

One Login can be associated with many users (one per database).

Thanks

https://sites.google.com/site/freelancermanisha/

Re: Can a SQL login have more than one user

Jan Steyn16-Jul-12 0:34

Jan Steyn

16-Jul-12 0:34

Re: Can a SQL login have more than one user

rimazuc17-Jul-12 0:07

rimazuc

17-Jul-12 0:07

yes an SQL login can be mapped to more than one DB user. Picture an SQL login as an access to a building while a DB user provides specific access to rooms in the building.

No access to the building (Login) then no access to the rooms (DB user).

Sql query that sorts data by top quantity per category

Hardz13-Jul-12 16:49

Hardz

13-Jul-12 16:49

Hi,

How to sort this sample data and query below by quantity and by category?:

Select Qty, Category From Inv1 Order By Qty Desc, Category

Qty Category
65 Cat3
55 Cat3
50 Cat2
45 Cat3
40 Cat1
30 Cat1
25 Cat1
25 Cat2
15 Cat1
15 Cat2

so that the output would be look like this:

Qty Category
65 Cat3
55 Cat3
45 Cat3
50 Cat2
25 Cat2
15 Cat2
40 Cat1
30 Cat1
25 Cat1
15 Cat1

Thanks in advance!

Hardz

Re: Sql query that sorts data by top quantity per category

PIEBALDconsult13-Jul-12 19:00

PIEBALDconsult

13-Jul-12 19:00

Perhaps ORDER BY Category,Qty DESC ?

Re: Sql query that sorts data by top quantity per category

__TR__15-Jul-12 0:49

__TR__

15-Jul-12 0:49

SQL

Select Qty, Category From Inv1 Order By Category DESC, Qty DESC

Re: Sql query that sorts data by top quantity per category

Hardz15-Jul-12 15:18

Hardz

15-Jul-12 15:18

Hi,

Thanks for the reply, but what I want to accomplish is that to determine the highest Qty then prioritized the Category that has the highest Qty, from this sample Cat3 contains the highest Qty(65) then sorted from high to low, next is Cat2(50), and Cat1(40). If I changed for ex. the Qty at cat1(40) to 95 then Cat1 now is the first priority of sorting, then Cat2 and so on, so the sorting may varies from high to low no. of Qty per Category, not by Category per Qty.

Regards,

Hardz

Re: Sql query that sorts data by top quantity per category

Luc Pattyn15-Jul-12 16:27

Luc Pattyn

15-Jul-12 16:27

This works fine for SQL Server:

SELECT Qty, t1.cat FROM Inv1 AS t1
INNER JOIN
(SELECT MAX(Qty) AS mq, cat FROM Inv1 GROUP BY cat) AS t2
ON t1.cat=t2.cat
ORDER BY mq DESC, Qty DESC

However, you didn't fully specify what you want: when two categories have equal maxima, what should happen? The above may intertwine such categories!

This wouldn't:

SELECT Qty, t1.cat FROM Inv1 AS t1
INNER JOIN
(SELECT MAX(Qty) AS mq, cat FROM Inv1 GROUP BY cat) AS t2
ON t1.cat=t2.cat
ORDER BY mq DESC, cat, Qty DESC

Luc Pattyn [My Articles] Nil Volentibus Arduum

Re: Sql query that sorts data by top quantity per category

Hardz15-Jul-12 16:50

Hardz

15-Jul-12 16:50

Hi Luc,

Your 2nd code worked perfect for me, coz you're right for your assumption that when there's an equal maxima between these categories it will automatically sorted by category.

Thank you very much.

Regards,
Hardz

make a databse with ADO.Net

messages13-Jul-12 4:50

messages

13-Jul-12 4:50

SQL

Hi everyone
Is it possible to create a database of "Data Source configuration wizard"?
let me explain you select it from Data->Add New Data Source in the visual studio and then you select Database in "Choose a Data Source Type"  after select "DataSet" you have to make a "Add Connection" this window has an item "Connect a Database->Select or enter a database Name",Is it possible to create a database instead name of a database?

Re: make a databse with ADO.Net

Sandeep Mewara15-Jul-12 0:15

Sandeep Mewara

15-Jul-12 0:15

messages wrote:
Is it possible to create a database instead name of a database?

No. It's a datasource configuration wizard. It's expected that database is pre-defined. Create your database from before and then configure it using the wizard.

Sandeep Mewara
[My last article]: Server side Delimiters in ASP.NET[^]

should i Make new database after Financial year

Varinder Raii11-Jul-12 20:57

Varinder Raii

11-Jul-12 20:57

Hi Friends..

I want to know should i Make new database after Financial year or just create new session in the current database .

Please tell me with reasons.

Re: should i Make new database after Financial year

Richard MacCutchan11-Jul-12 23:33

Richard MacCutchan

11-Jul-12 23:33

How on earth can anyone answer this question without knowing anything about your business?

speaking as ...

Re: should i Make new database after Financial year

Eddy Vluggen11-Jul-12 23:39

Eddy Vluggen

11-Jul-12 23:39

The idea to start a "new" database comes from an accountant, not a technician; a new year means a new book, a new page, a clean slate to them.

In a database, that's just silly. Include a date on the record, and you can select/manipulate the data is if you were working in a database with only data from that particular year (thanks to the WHERE clause)

Advantages include;

Easy maintenance (one database, as opposed to 20 clients with 4 years worth of databases)
Easy backups (since all is in one database)
Easier cross-querying (summing the data over multiple years)
Easier to understand (KISS applies to almost everything, everywhere)

The only disadvantage is that the accountant won't understand why you put the data in the "same books". That's the reason why they're not involved when creating a technical storage-facility, only when describing the data - they may explain what they need, but can hardly explain how it should be stored.

Bastard Programmer from Hell Suspicious | :suss:

if you can't read my code, try converting it here[^]

Re: should i Make new database after Financial year

PIEBALDconsult13-Jul-12 3:51

PIEBALDconsult

13-Jul-12 3:51

No, but you could have tables where you summarize various periods for future comparisons and such.

Generate Excel From SQL

vvashishta11-Jul-12 19:48

vvashishta

11-Jul-12 19:48

I want to generate Excel Worksheet through a SQL Query fired on the table directly export data to an Excel Sheet.

- Happy Coding -
Vishal Vashishta

Re: Generate Excel From SQL

PIEBALDconsult11-Jul-12 19:54

PIEBALDconsult

11-Jul-12 19:54

No, you really don't. Excel is the devil's workshop.

I prefer to generate XML, it's more flexible. It can also be converted to CSV which Excel can read.

Re: Generate Excel From SQL

Eddy Vluggen11-Jul-12 23:43

Eddy Vluggen

11-Jul-12 23:43