Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Report group by Date Range
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...- aauxta
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
-
In one query statement
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...- aauxta
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
Cookie problem with different IE version
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...- aauxta
- Thread
- Replies: 0
- Forum: Microsoft: ASP (Active Server Pages)
-
Remove duplicate record in a table
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...
