Forgot How To Do This In SQL

Sep 13, 2007

I am having a serious brain f@rt right now. I am querying a table full of customers, dates and payment amounts

 I am looking to get each customer, the most recent payment amount and most recent payment date.

 

SELECT Customer, MAX(TranDate) As TranDate, TranAmount GROUP BY Customer, TranAmount

 ...gets me the following:

customer1      9/14/2007   100.00

customer1      9/14/2007    50.00

customer2     9/1/2007       75.00

The problem being that each customer has multiple payment amounts so when I GROUP BY the TranAMount column I am getting multiple rows for the same customer. I am looking for a single row or customer, date and amount for each customer. What am I forgetting?

View 5 Replies


ADVERTISEMENT

Forgot SA Password

Sep 19, 2005

I forgot my SA password how can i know it.

View 1 Replies View Related

FORGOT THE SA PASSWORD FOR SQL 6.5 DATABASE

Jun 21, 1999

I have tried every SA password in our documentation and I cannot get into the database. I want to dump the database and clear up the transaction log. Can anyone help me?

View 1 Replies View Related

Forgot The SQL Authentication Details

Nov 14, 2006

Hi guys,

this is my first post and I am new to SQL server 2005 (well, SQL in general).

I have installed SQL server 2005 but cannot remember if I set authentication for it. I have just tried to access a database on this server through ASP (classic, not .NET) but get the error message saying that login failed for <servername>IUSR_<servername>.

There must be a simple way around this.

Also, is there a way for me to create trusted connections for my server now that it has been installed?

If anyone can give me a few ideas about authentication, etc, I would really appreciate it.

View 1 Replies View Related

Resetting Sqlce Forgot Password

Oct 23, 2007



can we reset sql server CE forgotten password ?


Regards
Mukesh Gupta

View 5 Replies View Related

I Forgot My SA Password For My Instance Of SQL 2000

Sep 5, 2006

Hi all,

I have SQL 2000 and I forgot my SA password and cannot login as administrator using windows authentication.

Is there any way to reset SA password?

"Mixed Mode" authentication is enabled.

If I change authentication mode in register to Windows only and then after restarting SQL change it back to Mixed, will it reset SA password to "null"?

Thanks in advance.

View 9 Replies View Related

How Can I Login To My MS SQL Server 2005 If I Forgot My Login Password

Oct 8, 2007



Hi,


I am using SQL Server 2005 at home.
My problem is I forgot my password to log in to my server.
I only remember user name is 'sa'.
I haven't used it for two to three months. So I forgot password.
Previously, When I used sql server 2000, my login is as windows login. so no problem.
But this time, I set seperate log in and I got this problem.
Any help will be appreciated.
Thanks
George

View 11 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved