Is AthleteID a number?

If you hardcore the ID does it work?
"SELECT * FROM AthleteT WHERE AthleteID=1"
Replace 1 with an existing ID

I think the problem is Active. If that's a Y/N value in SQL Server it's either 0 or 1, not -1, and it shouldn't be in quotes.

SQL = "SELECT * FROM TeamT Where Sport='Wrestling' AND Active=1"

One of the hardest things about switching from Access to SQL Server is remember the different syntax.

Changing the Y/N values to either 0 or 1, with or without quotes was not the issue. I even removed that WHERE clause altogether, and it wasn't the problem. Changing the AthleteID to 1 only should the first athlete in the database.

Of course it did, because that's what you're asking it to do,
Where is AthleteID coming from? A Query string?

Where is AthleteID from? Is it from the first Recordset?
If so try this.

SQL2 = "SELECT * FROM AthleteT WHERE AthleteID=" & RS("AthleteID")

Hi Kevin, when I added & RS("AthleteID") it gave me one name, however, it was at least the first person on the list I needed. It is the information from another table.

Alex, the AthleteID coming from a second Query string.

All this was working fine when I was using an uploaded database, but I started having problems when I switch to using SQL on the server.

I don't think we have the full picture

Where's the loop to show all of them?

What's the purpose of the page?
Get all active Wrestlers then display them in a list?

Definitely need a loop for that.

Yes, to get all active Wrestlers then display them in a list?

Here is the entire page:

<!--#include file="header_athletes.asp"-->
<!--#include file="security_check.asp"-->

<BR>
<%
Sort = Request("Sort")
If Sort = "" Then
Sort = "AthleteID"
ElseIf Sort = "LastName" Then
Sort = "LastName, FirstName"
ElseIf Sort = "FirstName" Then
Sort = "FirstName"
ElseIf Sort = "SID" Then
Sort = "SID"
ElseIf Sort = "DOB" Then
Sort = "DOB"
Else
Sort = "AthleteID"
End if
%><!--#include file="database-connect.asp"--><%
SQL = "SELECT * FROM TeamT Where Sport='Wrestling' AND Active='-1'"
RS.Open SQL, Conn

Set RS2 = Server.CreateObject("ADODB.Recordset")
SQL2 = "SELECT * FROM AthleteT WHERE AthleteID=" & RS("AthleteID")
RS2.Open SQL2, Conn

AthleteInfo = RS2("LastName") & ", " & RS2("FirstName") & " " & RS2("SID")
RS2.Close
Set RS2 = Nothing

response.write "<div align=center>"
response.write "<TABLE border=1 width=800 cellspacing=0>"
response.write "<TR bgcolor='#009900'>"

URL = "wrestling_roster_eligible.asp"
URL2 = "wrestling_

Yeah, you need a while loop.

while not rs2.eof
   ' do stuff here
   rs.movenext
wend

I will try this. Thank you!!!!!

That doesn't seem to be working either. :-(

Before when I was just using the Database, it worked just fine. Now that I am using the SQL server, that is when the issues started. I used to just use a query, now I must do things from the table.

Is there only one record in AthleteT for each AthleteID?

What does not working mean? Any errors or wrong/missing information displayed?

Yes, one record in AthleteT for each AthleteID?

Think there's a typo

rs.movenext => rs2.movenext

while not rs2.eof
   ' do stuff here
   rs2.movenext
wend

Yes, I did fix that

What did you add to your loop?
The 'do stuff here' bit