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
Sep 19, 2005
I forgot my SA password how can i know it.
View 1 Replies
View Related
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
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
Oct 23, 2007
can we reset sql server CE forgotten password ?
Regards
Mukesh Gupta
View 5 Replies
View Related
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
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