http://www.developerbarn.com/ Structured Query Language (SQL) is the talk of databases. Discuss topics such as joins, triggers and other advanced SQL topics. en Mon, 06 Sep 2010 12:42:08 GMT vBulletin 60 http://www.developerbarn.com/images/misc/rss.png http://www.developerbarn.com/ http://www.developerbarn.com/sql-development/2244-aggregates.html Tue, 31 Aug 2010 19:42:03 GMT Ok, I know I'm going to feel really silly when someone answers this because it should be very basic, but I'm at a loss at this point on how to select a record based on a min/max value. I realize I can use a Having clause, but it doesn't produce what I want.

Take the following data:

Create Table Customer (CustomerId int primary key, DateofBirth int);
Insert Into Customer (CustomerId, DateOfBirth)
Values (1, 19010801);
Insert Into Customer (CustomerId, DateOfBirth)
Values (2, 19100101);
Insert Into Customer (CustomerId, DateOfBirth)
Values (3, 19201201);

Select * from Customer

Results:
CustomerId DateOfBirth
1 19010801
2 19100101
3 19201201

Ok, so if I want to know the customerid of the person with the min or max date of birth, how would I go about it?

I can write:

Select customerid, Min(dateofbirth), Max(dateofbirth)
From Customer
Group by customerid


but it just yields all records grouped by customerid. What if I wanted to see just the customerid and the dateofbirth of the min or max?

Thanks! ]]> SQL Development Flam http://www.developerbarn.com/sql-development/2244-aggregates.html http://www.developerbarn.com/sql-development/2236-username-question.html Sun, 29 Aug 2010 21:25:30 GMT I've been slightly perplexed at the results of the following query depending on where I'm running it from:

SELECT spid, nt_username
FROM sys.sysprocesses
where spid=@@spid

(I realize I can run SUSER_Name() as well as a variety of other username functions, this is just an example)

Anyway, I have 2 different modules for an application. Both of them run on the same database, just out of different ports on the server. They run from SQL Server 2005. Both modules have their own built-in query executors (limited functionality; select statements only).

The thing that confuses me is that if I run the aforementioned query, one module always returns the nt_username value=the local machine username
while the other module returns tthe nt_username=the admin security group in SQL Server.

So for example, the results from module 1 of the above query might be:

SPID nt_username
55 FLAM

while the results of module 2 might be:

SPID nt_username
62 T_Admin

I'm not sure if this is something on the application or something I can change in SQL Server.

Anyone have any ideas?

Thanks much! ]]> SQL Development Flam http://www.developerbarn.com/sql-development/2236-username-question.html