Recent content by aauxta

Thanks mija and it sure gets me a clear fresh start.

I have got this table: DateEntered code ----------- -------- 1/1/2004 abc 1/1/2004 def 1/5/2004 def 2/2/2004 abc 2/9/2004 xyz 4/1/2004 abc 4/1/2004 xyz and I want to turn it into: code 1/2004 2/2004 3/2004 4/2004 ----- ------- ------ ------ ------- abc...

This really got me and it seems really simple though: StudentID CourseID Grade --------- -------- ----- 123 111 A 123 222 B 456 111 A 456 222 A 456 333 A I just couldn't figure out how to use just one query to find out the...

Hi, Just wonder if any of you run into problem writing cookies in different version of IE. I have a very simple login page setup and goes in the following order: 1) login page 2) login process page 3a) sucess: go to main page 3b) fail: back to login page the cookie is written in the name of...

Did you have your IIS server set to execute "script only"? Cheers, Aauxta

Thanks, and now that I run into another problem with DELETE. We can locate the names for the duplicate entries but what's the best way to remove the extra ones? Do I need to write a batch file in order to get all these done or is there a better way to do it? Appreciate your thoughts. Thanks...

I think this should be simple but it still got me so I am hoping someone could help me out here: I have a table with first_name and last_name and some of the first_name and last_name has duplicate records in that table. I am trying to remove the additional ones to it and I was thinking to try...